How can i rollback my last delete command in mysql?

+7 A:

if you haven't made a backup, you are pretty much fudged.

Omry 2010-03-01 14:50:57

So there is no way to undo that .... Oops i did it wrong..I should be using the select query to list what i should be deleting before actually executing the query.. A nice lesson leant to be more cautious

kvijayhari 2010-03-01 15:15:34

sadly that's the case. and yes, it's always a good idea to verify with select before using delete or update.

Omry 2010-03-01 15:49:58

This is one of the flaws of standard databases: They have no history, just a huge memory of "now".

Aaron Digulla 2010-03-01 15:58:47

I would argue that it's by design. keeping a history is very expensive. you want your database to be fast, not forgiving.

Omry 2010-03-01 16:25:26

A:

If you didn't commit the transaction yet, try rollback. If you have already committed the transaction (by commit or by exiting the command line client), you must restore the data from your last backup.

Aaron Digulla 2010-03-01 14:52:20

how to invoke rollbacki haven't exited from the command line client..

kvijayhari 2010-03-01 14:57:54

by default the command line client uses auto commit after each command.

stmax 2010-03-01 15:06:52

@Vijay: Just type "rollback;" + ENTER

Aaron Digulla 2010-03-01 15:57:56

A:

A "rollback" only works if you used transactions (http://www.sqlteam.com/article/introduction-to-transactions). That way you can group queries together and undo all queries if only one of them fails.

But if you already committed the transaction (or used a regular DELETE-query), the only way of getting your data back is to recover it from a previously made backup.

Select0r 2010-03-01 14:54:01

ansaurus

tags:

views:

answers:

How can i rollback my last delete command in mysql?

related questions