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.
