Foreign key handling

Aug 14, 2012 at 2:14 PM

Hi,

I would like to know how are handled foreign keys when doing backup...

So when I execute script for data restoration on top of existing database (from production to dev instance), I would not have script errors ?

Thanks.

Coordinator
Aug 17, 2012 at 7:13 AM

Hi,

before restoring the data, SET foreign_key_checks = 0;

after finished restoring data, SET foreign_key_checks = 1;