Specify Recovery Time

• To indicate the start and end times for recovery, use the --start-date and --stop-date options for mysqlbinlog, in DATETIME format.
  • For example to stop at a specified point in time.

    mysqlbinlog --stop-date="2007-06-07 7:59:59" \
    

      /var/log/mysql/bin.1234 | mysql -u root -p

    • This command recovers all of the data up until the date and time given by the --stop-date option.
  • For example to start from a specified point in time.

    mysqlbinlog --start-date="2007-06-07 8:00:00" \
    

      /var/log/mysql/bin.1234 | mysql -u root -p

    • In this example, SQL statements logged from 8:00 a.m. on will be re-executed.

• To display a log file without execting it use the command:

  mysqlbinlog /var/log/mysql/bin.1234 > /tmp/mysql_restore.sql

  • Then open the file /tmp/mysql_restore.sql in a text editor such as vi.

How do I specify recovery position?

---

---

© 2007 John Michael Pierobon

Notes