Modify deployment script capability

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

Modify deployment script capability

Postby mniAP » Thu Mar 15, 2012 6:29 pm

Hi
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 1.0.0.351
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;
mniAP
 
Posts: 1
Joined: Thu Mar 15, 2012 6:16 pm

Postby Michael Christofides » Fri Mar 16, 2012 7:22 pm

Hi

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.

Thanks again,
Michael
Michael Christofides
 
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 2 guests

cron