How to convert mysql bin-log log files to sql files

View mysqlbinlog version

mysqlbinlog -V [--version]

Check the binlog log opening status

show variables like '%log_bin%';

After MySQL opens the bin-log log, non-query operations of the MySQL database will save records in the bin-log file. Generally, bin-log log files cannot be opened for viewing and require the use of mysql tools. Assume that the binary file mysql-bin.000011 is stored in the /mysql/data/ directory. You need to export the SQL statements about the database tide in the log file mysql-bin.000011 to the file tide.sql. Perform the following operations:

// Export the SQL statements about the tide database from the binlog file to the file mysqlbinlog mysql-bin.000011 -d tide > tide.sql 
// Select a time range to export mysqlbinlog --start-date="2017-08-12 15:00:19" --stop-date="2017-08-12 15:30:19" mysql-bin.000011 -d tide > tide.sql

If the binlog log file is recorded in ROW format

// Parse the row-format binlog log file into a base64 file. -v represents line break display. mysqlbinlog --base64-output=decode-rows -v mysql-bin.000011 -d tide > tide.sql

After execution, a tide.sql file will be generated in the current directory. You can use vim/vi to open the file.

Summarize

The above is the method that the editor introduced to you how to convert MySQL bin-log log files into sql files. I hope it will be helpful to you!