Example of restoring a database using the Bin-log log _mysql

1, to see whether the log is enabled:
Show variables like ' Log_bin ';

2, view the current log file name:
Show master status;

3. Find out what binary log files are currently available:
Mysql> show binary logs;

4, view the MySQL log:
Mysqlbinlog mysql-bin.000001
Mysqlbinlog mysql-bin.000006 >/root/bbx.log

5, using the new Binlog log: (Update database log)

Copy Code code as follows:

Method one: [Root@bogon mysql]# mysqladmin-uroot-p Flush-logs
Methods two:mysql> FLUSH LOGS;
Method Three: [Root@bogon mysql]#/etc/init.d/mysql Restart