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
Simply pull the image, create a container and run...
Transactional Characteristics 1. Atomicity: After...
The so-called cascading replication is that the m...
Table of contents Mainly used Postman functions D...
This article shares the specific code of js to ac...
Table of contents 1. Database Operation 1.1 Displ...
The previous article introduced how to achieve a ...
Find mirror We can search for images from the Doc...
Today, let’s get straight to the point and talk a...
How can we say that we should avoid 404? The reas...
As a backend programmer, you deal with Linux in m...
cursor The set of rows returned by the select que...
1. Execute the select statement first to generate...
The user organization has two Windows Server 2008...
The development of Docker technology provides a m...