Re: FN-FORUM: MySQL retrieving lost data

date posted 1st October 2003 19:07

Hi Jon,

> Please, please, please.... someone tell me this is possible!

In addition to the methods already given, MySQL has an optional fall
back method, but you'd probably have had to enable this manually so it
might not do you any good this time.

MySQL can, by specifying particular parameters on the command-line for
mysqld or in the my.cnf file, log all SQL commands that update data to
log files. By replaying the contents of these log files, you may be able
to get back some/all of your data.

The relevant links to the MySQL site are...

http://www.mysql.com/doc/en/Update_log.html
http://www.mysql.com/doc/en/Binary_log.html


Backups are of course the proper solution, but this has got me out of a
bind on more than one occasion where I've blanket deleted or updated
rows accidentally.

Cheers,

Steve