MySQL Forums
Forum List  »  Backup

Backup and restore multiple datyabase data with circular references
Posted by: Thanassis Bakalidis
Date: February 11, 2015 04:15AM

Hello everyone.
I am trying to figure out what is the best way to backup and restore multiple databases with circular foreign key relationships. My schemata look more or less like this:

DB1.table1 references DB2.table2 and
DB2.table1 references DB1.table2

Backup with mysqldump works but when I try to restore to a new machine, then I get error 150 as -- whatever my restore order is data from one table are always missing. I have tried adding the disable key check flag with still no luck.

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup and restore multiple datyabase data with circular references
2072
February 11, 2015 04:15AM


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.