Possible to rollback changes to MySQL databases without any form of backup

mysql database-restore
Fábio Antunes picture Fábio Antunes · Oct 1, 2012 · Viewed 23.5k times · Source

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.

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.

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.

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)?

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)

Update

Possible that Windows XP system restore kept a previous version of MySQL DBs on file?

Answer

Mike Brant picture Mike Brant · Oct 1, 2012

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.

Related questions

Enable binary mode while restoring a Database from an SQL dump

I am extremely new to MySQL and am running it on Windows. I am trying to restore a Database from a dumpfile in MySQL, but I get the following error: $ >mysql -u root -p -h localhost -D database -o &…

Read More
restore all mysql database from a --all-database sql.gz file

I've backed all my mysql databases with he following command mysqldump -u root -ppasswod --all-databases | gzip > all.sql.gz just wanted to know will I be able to restore all of the database with following command gunzip < alldb.…

Read More
How to backup MySQL database on a remote server?

I have a MySQL database existing on a remote server. I only have sql connection privilege. I don't have FTP access to the server, and I need to do a complete dump of the database. I have tried mysqldump, but …

Read More