Example of restoring a database using the bin-log

1. Check whether logs are enabled:
Show variables like 'Log _ bin ';

2. view the current Log File Name:
Show master status;

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

4. View mysql logs:
Mysql-bin.000001 for mysqlbinlog
Mysql-bin.000006>/root/bbx. log

5. Use the new binlog: (update database logs)

Copy codeThe Code is as follows:
Method 1: [root @ bogon mysql] # mysqladmin-uroot-p flush-logs
Method 2: mysql> flush logs;
Method 3: [root @ bogon mysql] #/etc/init. d/mysql restart