Re: Revert using Binlog

2006-01-30 Thread Gleb Paharenko
Hello. If you have all inserts and updates on the tables from which you've lost your data, you can simply recover the whole database from the binary logs, however if the logs were create later than tables, most probably you won't get the consistent data in them. Use --stop-datetime option for mysq

Revert using Binlog

2006-01-29 Thread Rob Gormley
Am hoping someone can give me the safest advice here. Using 4.1 and InnoDB, someone in an attempt to be helpful set up a lot of foreign key constraints. However... ON DELETE CASCADE When we needed RESTRICT. Net effect? Some editing today lead to cries of "Where has half the data gone?" We have