Foreign Key Constraints

Help
Anonymous
2011-03-10
2013-05-29
  • Anonymous - 2011-03-10

    I'm using automysqlbackup to backup a a few InnoDB databases, and its working great.

    The one problem that I have is that foreign key constraints are being dumped in line with each table definition. This means that when it comes to importing the database from the backup, many constraints will fail (because the related table is not even in existance yet).

    The 'normal' way of getting around this is to only run all contraints after all tables have been created. However, I don't see an option for this in automysqlbackup.

    Any ideas on the best way around this?

     
  • Anonymous - 2011-06-17

    In case anyone else reads this, the answer is to use the following statement at the top of your import file:

    SET FOREIGN_KEY_CHECKS=0;

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks