无需任何形式的备份即可回滚对 MySQL 数据库的更改
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12679889/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Possible to rollback changes to MySQL databases without any form of backup
提问by Fábio Antunes
I understand I might be asking the impossible but, well never hurts to try.
我知道我可能会问不可能的事情，但是尝试永远不会有什么坏处。
Is it possible to rollback changes to a handful of MySQL databases without having any form of backup. The only thing left are the databases with the changes I wish to undone.
是否可以在没有任何形式的备份的情况下回滚对少数 MySQL 数据库的更改。唯一剩下的就是我希望撤消更改的数据库。
Why this happened you might ask, well simply putting it, Windows XP scheduler decided not to run the backup task as scheduled, therefore no backups were made previous to a few dozen queries queried to those databases.
你可能会问为什么会发生这种情况，简单地说，Windows XP 调度程序决定不按计划运行备份任务，因此在对这些数据库进行几十次查询之前没有进行备份。
I doubt it is possible to undo those changes, and if it is possible I don't know how. Maybe MySQL keeps some sort of record on the changes performed to a database, but I don't know.
我怀疑是否有可能撤消这些更改，如果可能的话，我不知道该怎么做。也许 MySQL 会记录对数据库执行的更改，但我不知道。
Does anybody knows a way to undo changes to a MySql database without any form of backup (neither dump file or files from the data folder)?
有人知道在没有任何形式的备份（既不是转储文件也不是来自数据文件夹的文件）的情况下撤消对 MySql 数据库的更改的方法吗？
Thank you.
谢谢你。
System Details:
Windows XP SP3
Server: localhost via TCP/IP
Software: MySQL
Software version: 5.5.25a - MySQL Community Server (GPL)
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)
系统详情：
视窗 XP SP3
服务器：本地主机通过 TCP/IP
软件：MySQL
软件版本：5.5.25a - MySQL 社区服务器 (GPL)
协议版本：10
服务器字符集：UTF-8 Unicode (utf8)
Update
更新
Possible that Windows XP system restore kept a previous version of MySQL DBs on file?
可能 Windows XP 系统还原保留了以前版本的 MySQL 数据库文件？
采纳答案by Mike Brant
Without having any database backup, you are probably pretty much out of luck. If you had mysql query logging or binary logging on, you could glean some information about what queries had been run since a certain point in time, but if you had destructive queries (UPDATE, DELETE, etc.) you will have no way of knowing what the previous data was.
如果没有任何数据库备份，您可能很不走运。如果您有 mysql 查询日志记录或二进制日志记录，您可以收集一些关于自某个时间点以来运行的查询的信息，但如果您有破坏性查询（更新、删除等），您将无法知道以前的数据是什么。
