Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-408-701-9009
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +358 50 5710 528
Italy: +39 06-99268193
Israel: +358 50 5710 528
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Asia Pacific: +81 3 5843 1140
Related pages:
Learn about new MySQL releases, technical articles, events and more.
Can I Revert MySQL Back to an Earlier State?
Newsletters older than 6 months may have links that are out of date. Please use the Search to check for updated links.
Q: I want to be able revert my MySQL database "back in time". E.g.
if a programmer makes a mistake, having such a feature could be
a life saver. Is there any way, I can revert the MySQL database
to an earlier state?
A: Yes you can. The binary log keeps a complete history of all
queries that change the state of the database. This log can be used
to restore the database to a particular state if desired. Please
seehttp://www.mysql.com/doc/en/Binary_log.html for more information
on binary log andhttp://www.mysql.com/doc/en/mysqlbinlog.html
on more information about mysqlbinlog utility on how you can revert
the database to an earlier state.