MySQL rollback on the MyISAM engine

Question

By mistake I ran the update query. This update made my table all rows values as o.

Is it possible to rollback the table values?

Not sure if you can rollback without transactions - http://dev.mysql.com/doc/refman/5.0/en/commit.html — Sachin Shanbhag, Aug 04 '10 at 10:22

score 11 · Accepted Answer · answered Mar 10 '11 at 21:41

11

MyISAM does not support transactions. Therefore, every individual statement runs as if it is enclosed by a transaction. You cannot roll it back.

answered Mar 10 '11 at 21:41

three-cups

score 3 · Answer 2 · answered Dec 07 '12 at 01:43

3

MYISAM dont support transaction support..

That's the reason best you should be using INNODB..

answered Dec 07 '12 at 01:43

Kdecom

score 1 · Answer 3 · answered Aug 04 '10 at 10:17

1

If you have no backup, and didn't run your update in a transaction, your data is gone for good.

answered Aug 04 '10 at 10:17

Mau

3 Answers3