View mysqlbinlog version Check the binlog log opening status 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! You may also be interested in:
|
<<: Sample code for implementing PC resolution adaptation in Vue
>>: VScode Remote SSH remote editing and debugging code
Table of contents Overview How to make full use o...
It is very common to use webpack to build single-...
Whether it is Samba service or NFS service, the m...
Table of contents 1. Create a vue-cli default pro...
Many concepts in UI design may seem similar in wo...
This tutorial shares the process of manually inst...
Lots of links You’ve no doubt seen a lot of sites ...
A jQuery plugin every day - to make search histor...
Table of contents 1. Pre-analysis 1. Variable pre...
A jQuery plugin every day - step progress axis st...
Table of contents 1. Project Description 2. Nginx...
01. Command Overview The gcc command uses the C/C...
First look at the effect diagram: The complete co...
more is one of our most commonly used tools. The ...
This article records the graphic tutorial of MySQ...