Can I Revert MySQL Back to an Earlier State?

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.