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 (http://www.mysql.com/doc/en/Binary_log.html) for more information on binary log andhttp://www.mysql.com/doc/en/mysqlbinlog.html (http://www.mysql.com/doc/en/mysqlbinlog.html) on more information about mysqlbinlog utility on how you can revert the database to an earlier state.
© 2010, Oracle Corporation and/or its affiliates