问题原文
原帖链接 · cronoklee · CC BY-SA 3.0
Our database became corrupt after a server restart so we ran a repair on all tables but we're now missing random pockets of data across all tables. When mySQL repair runs, does it back up the bad data before it is removed? Is there any other way to see what was deleted from the tables and restore it manually?
已采纳解答
原帖链接 · Reaces · CC BY-SA 3.0
Your only option is to restore a previous backup.
MySQL repair does not backup any data, in fact the manual recommends you create a backup before running the repair.
Caution Make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss. Possible causes include but are not limited to file system errors. See Chapter 8, Backup and Recovery.
You can either restore the backup and run from the backup, or restore the backup next to your now repaired table, and compare the data manually.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
