开发者

MySQL Wrong Restore Data Recovery

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 e开发者_如何学Cverything 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.)


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜