CODEWITHSUNDEEP
mysqldatabase-restore
DevNull
DevNull

Reputation: 763

Is it possible to restore a MySQL database to a previous state in time?

I just realized that the MySQLWorkBench destroys the target (makes a replacement) when performing synchronize model. Making changes on the source and model between synchronizations leaves you with a weird bastard. So is it possible to return to a given snapshot in time?

Upvotes: 3

Views: 17172

Answers (1)

spencer7593
spencer7593

Reputation: 108430

A recent backup of the database taken using mysqldmp should be sufficient for you to restore the database to the time of the last backup.

After a restore, it's possible to roll forward changes from the binary log to a particular point in time. http://dev.mysql.com/doc/refman/5.1/en/point-in-time-recovery.html

Aside from that, there is no rollback to a "snapshot in time" and no "flashback query" functionality in MySQL (at least not in the MySQL 5.1 Community Edition.)

Upvotes: 4

Related Questions