Restore deleted mysql data

Question

Is it possible to restore the mysql data which deleted by " delete from table " ? I found there is a software "ApexSQL", anyone used it before? Is it possible to restore? Or any other method that can be restore. I am not drop table .

http://www.apexsql.com/sql_tools_log.aspx?_kk=log%20explorer

possible duplicate: http://stackoverflow.com/questions/6924823/how-to-recover-just-deleted-rows-in-mysql , http://stackoverflow.com/questions/2173049/recovery-after-wrong-mysql-update-query , — ılǝ, May 09 '13 at 09:08
It is possible to restore deleted data. Are you using MyISAM or InnoDB? — Wasif, May 09 '13 at 09:09
http://www.rackspace.com/knowledge_center/article/mysql-engines-myisam-vs-innodb — iCantSeeSharp, May 09 '13 at 09:15

score 2 · Accepted Answer · answered May 09 '13 at 09:43

2

It is possible to recover deleted data (deleted with DELETE statement). For InnoDB you can use open source tool by Percona mentioned in their blog post. For MyISAM tables you can use ApexSQL or use this tool.

answered May 09 '13 at 09:43

Wasif

522
2
6

Restore deleted mysql data

1 Answers1

Linked