Compares and synchronizes MySQL database content
Moderators: Chris Auckland, eddie davis, Michael Christofides
Just downloaded the trial today
I'm moving data from one mysqldb to another. It's a direct transfer from staging to prod
The mysql dbs are in different servers. The schema transfer worked without problems.
However when I run the data transfer, I get an error for a Set Foreign Key Checks statement.
I think the way around in this case is to just ignore those statements and try however there is no way to do this. Could you suggest an alternative.
Also is there any way to overwrite data in the target database instead of update
I've included the error below:
Bug report generated at 3/15/2012 10:17:52 AM
Program version 22.214.171.1241
System.Exception: When deploying couldn't execute the statement:SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
- Posts: 1
- Joined: Thu Mar 15, 2012 6:16 pm
Thanks for the report. Which version of MySQL server is on staging and which is on production?
It'd also be great to know which storage engines you are using on both.
One final question, could you run the script manually and send us the error that is displayed? Hopefully this will give us more information and help resolve the issue.
- Posts: 94
- Joined: Wed Apr 20, 2011 6:37 pm
- Location: Red Gate Software
Return to MySQL Data Compare
Who is online
Users browsing this forum: No registered users and 0 guests