Thanks a bunch for the suggested workaround. This method was exactly
what I was looking for.
Thanks again.
CL
At 01:33 AM 6/20/2007, Ananda Kumar wrote:
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the
Guys,
I'm attempting to reapply a number of bin-log files in a effort to
restore all changes that was made to a database. I'm performing the
following command, but continue to get a foreign key constraint error
message when doing so. Has anyone ever ran into this issue, and if
so, what is a
One possible way is to spool the contents of bin-log into a file.
mysqlbinlog oca-bin.000554 binlog_sql.sql.
This will give you all the data present in oca-bin.000554. Then you can set
the
foreign key check to 0 at the session level and then apply the
binlog_sql.sql.
Comment our everything