Re: Reapply bin-log question( Help Please)

2007-06-20 Thread Clyde Lewis - DBA
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

Reapply bin-log question( Help Please)

2007-06-19 Thread Clyde Lewis - DBA
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

Re: Reapply bin-log question( Help Please)

2007-06-19 Thread Ananda Kumar
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