Modify deployment script capability
mniAP
Posts: 2
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 @FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @UNIQUE_CHECKS, UNIQUE_CHECKS=0;
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 @FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @UNIQUE_CHECKS, UNIQUE_CHECKS=0;
Comments
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