I deleted few rows from a Table by mistake - how to recover?

[kalvarahul]

Hi All,
I deleted few rows from a Table by mistake. Please could you write on the ways to rollback that data?

I have still not commited any transaction.

Please provide the steps / links / docs for this case.

Thank You.

[Atli]

Hi.

Take a look at this page in the MySQL reference manual.

It basically says that unless you have started the MySQL service without autocommit, or having issued 'SET AUTOCOMMIT = 0', 'START TRANSACTION', or 'BEGIN' before issuing you DELETE query, your changes are permanent.

I did read somewhere about being able to use Binary Logs (mysqlbinlog) to recover the actual INSERT queries, if the binary logs are enabled. Somewhat like this:

mysqlbinlog binary_log_file > query_log.sql
 

As far as I can tell, there is no other way to recover deleted rows. Unless you have a backup.

[pbmods]

Changed thread title to better describe the problem (did you know that threads whose titles contain phrases such as, 'urgent' actually get FEWER responses?).