My (SQL) WorkLog: MySQL's Point-in-Time Recovery option

Thursday, June 11, 2009

MySQL's Point-in-Time Recovery option

If your MySQL server is started with the --log-bin option to enable binary logging, you can use the mysqlbinlog utility to recover data from the binary log files, starting from a specified point in time (for example, since your last backup) until the present or another specified point in time.

To restore data from a binary log, you must know the location and name of the current binary log file. By default, the server creates binary log files in the data directory, but a path name can be specified with the --log-bin option to place the files in a different location. Typically the option is given in an option file (that is, my.cnf or my.ini, depending on your system). It can also be given on the command line when the server is started. To determine the name of the current binary log file, issue the following statement:

You can check the possible options and complete steps in the online manual

1 comment:

daspeac said...

I have heard about another way of repair sql2005 mdl files. Besides, you can visit my blogs at: or where I’m trying to share my experience with regard to data corruption issues.

Post a Comment