欢迎各位兄弟 发布技术文章

这里的技术是共享的

You are here

首页

Restore deleted mysql data

shiping1 的头像
星期六, 2014-10-25 15:37 — shiping1
up vote0down votefavorite

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

share|improve this question
 
3 
Asking the obvious, but Do you have backups? –  Kami May 9 '13 at 9:08
2 
possible duplicate: stackoverflow.com/questions/6924823/… , stackoverflow.com/questions/2173049/… , –  ılǝMay 9 '13 at 9:08
   
It is possible to restore deleted data. Are you using MyISAM or InnoDB? –  mwasif May 9 '13 at 9:09
   
I am a newbie i dont know what is MyISAM , lnnoDB –  user2210819 May 9 '13 at 9:11
1 
rackspace.com/knowledge_center/article/… –  Souvlaki May 9 '13 at 9:15
up vote1down voteaccepted

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.

share|improve this answer
普通分类: 
mysql
Powered by Drupal

友情链接

校园好文网

 www.shipingzhong.cn  个人技术网_前端_后台    备案号:苏ICP备18010659号-2