MySQL Forums
Forum List  »  Backup

How to Backup/Restore data with foreign keys constraints
Posted by: Joao Miranda
Date: February 16, 2005 09:25AM

How can I use mysqldump to backup a database with foreign key constraints?
During the restore of a mysqldump file I got "Cannot add or update a child row: a foreign key constraint fails".
mysqldump has some option to disable foreign keys or something similar?
Any help or idea would by appreciated.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
How to Backup/Restore data with foreign keys constraints
24788
February 16, 2005 09:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.