MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Backup and restore multiple datyabase data with circular references
2042
Thanassis Bakalidis
February 11, 2015 04:15AM
Re: Backup and restore multiple datyabase data with circular references
1300
Rick James
February 12, 2015 10:57AM
Re: Backup and restore multiple datyabase data with circular references
1355
Thanassis Bakalidis
February 13, 2015 02: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.