MySQL rollback on the MyISAM engine

Asked 4/8, 2010 at 10:5 Answered 7/12, 2012 at 1:43

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?

Sticky answered 4/8, 2010 at 10:5 Comment(2)

mistake is am not taken the backup... – Sticky 4/8, 2010 at 10:13

Not sure if you can rollback without transactions - dev.mysql.com/doc/refman/5.0/en/commit.html – Neuroma 4/8, 2010 at 10:22

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

Quianaquibble answered 10/3, 2011 at 21:41 Comment(0)

MYISAM dont support transaction support..

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

Pasteup answered 7/12, 2012 at 1:43 Comment(0)

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

Berhley answered 4/8, 2010 at 10:17 Comment(0)