search

Home >Database >Mysql Tutorial >mysql找回被删除的数据表_MySQL

mysql找回被删除的数据表_MySQL

WBOY
WBOYOriginal
2016-06-01 13:02:35916browse

D:\wamp\bin\mysql\mysql5.6.17\bin>mysqlbinlog.exe d:/mysql/data/mysql-bin.000068 > d:\d68.sql
D:\wamp\bin\mysql\mysql5.6.17\bin>mysqlbinlog.exe d:/mysql/data/mysql-bin.000069 > d:\d69.sql

D:\wamp\bin\mysql\mysql5.6.17\bin>mysqldump -uroot -p123456 zbphp.com < d:\d68.sql
D:\wamp\bin\mysql\mysql5.6.17\bin>mysqldump -uroot -p123456 zbphp.com < d:\d4.sql
CMD中执行，然后通过 sql里面的记录进行找回。如果失败，一条条的SQL校对。

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql使用索引优化order排序_MySQLNext article：MySQL新增用户以及数据库访问授权_MySQL

Related articles

See more