MySQL错误恢复数据恢复
我几乎可以肯定答案，但情况如此危急，我不得不问这个问题，尽管我对答案有 %99 的把握。
我们办公室的某人备份了 MySQL 数据库，并将其恢复到错误的目标数据库上，覆盖了该目标上的所有内容（两个数据库的架构相同）。根据MySQL备份文件的结构，我知道恢复操作首先删除所有表，然后创建它们并用备份数据填充它们。 问题是恢复模块是否将旧数据保留在任何地方？有没有办法检索旧数据？ （日志？...等）
I'm almost certain about the answer, but the situation is so critical that I have to ask this question even though I'm %99 sure about the answer.
Someone in our office made a backup of a MySQL database and he restored it on a wrong destination database overwriting everything on that destination (The schema of both databases were the same). According to the structure of the MySQL backup files I know that the restore operation drops all the tables first and then creates them and fills them up with the backed up data. The question is does the restore module keeps the old data anywhere? Is there anyway of retrieving any of the old data? (logs?.. etc.)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
仅当您已经复制了从站，或者您曾经复制过，并且具有 二进制日志。即使这样，您也需要可以恢复的旧数据库副本，并再次配置复制。
Only if you have replicated slaves, or you used to, and have binary logs. Even then you'd need an old copy of the database you can restore, and to configure replication again.