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 220.127.116.111
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;