How to rollback the effect of last executed mysql query

mysql rollback
Rohit Banga picture Rohit Banga · May 15, 2010 · Viewed 26.6k times · Source

I just ran a command

update sometable set col = '1';

by mistake without specifying the where condition. Is it possible to recover the previous version of the table?

Answer

Amber picture Amber · May 15, 2010

Unless you...

  1. Started a transaction before running the query, and...
  2. Didn't already commit the transaction

...then no, you're out of luck, barring any backups of previous versions of the database you might have made yourself.

(If you don't use transactions when manually entering queries, you might want to in the future to prevent headaches like the one you probably have now. They're invaluable for mitigating the realized-5-seconds-later kind of mistake.)

Related questions

How can I roll back my last delete command in MySQL?

I accidentally deleted some huge number of rows from a table... How can I roll it back? I executed the query using PuTTY. I'll be grateful if any of you can guide me safely out of this...

Read More
How can I undo a mysql statement that I just executed?

How can I undo the most recently executed mysql query?

Read More
mysql transaction - roll back on any exception

Is it possible to roll back automatically if any error occurs on a list of mysql commands? for example something along the lines of: begin transaction; insert into myTable values1 ... insert into myTable values2 ...; -- will throw an error commit; …

Read More