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

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!

You may also be interested in:
  • Analysis and solution of a MySQL slow log monitoring false alarm problem
  • The role and opening of MySQL slow query log
  • Enabling and configuring MySQL slow query log
  • Detailed explanation of the binlog log analysis tool for monitoring MySQL: Canal
  • Detailed explanation of MySQL redo log (redo log) and rollback log (undo logo)
  • Analysis of MySQL Aborted connection warning log
  • Detailed explanation of MySQL transactions and MySQL logs
  • A detailed introduction to the construction and use of the tool Anemometer graphically displays MySQL slow logs
  • Detailed explanation of the reason why the MySQL 5.7 slow query log time is 8 hours behind the system time
  • Summary of MySQL log related knowledge

<<:  Sample code for implementing PC resolution adaptation in Vue

>>:  VScode Remote SSH remote editing and debugging code

Recommend

Detailed explanation of the process of building and running Docker containers

Simply pull the image, create a container and run...

Detailed explanation of MySQL transactions and MySQL logs

Transactional Characteristics 1. Atomicity: After...

Example of how to implement MySQL cascading replication

The so-called cascading replication is that the m...

js realizes the magnifying glass effect of shopping website products

This article shares the specific code of js to ac...

MySQL database operations and data types

Table of contents 1. Database Operation 1.1 Displ...

Sample code for JS album image shaking and enlarging display effect

The previous article introduced how to achieve a ...

How to operate Docker and images

Find mirror We can search for images from the Doc...

17 404 Pages You'll Want to Experience

How can we say that we should avoid 404? The reas...

Summary of 6 Linux log viewing methods

As a backend programmer, you deal with Linux in m...

How to use cursor triggers in MySQL

cursor The set of rows returned by the select que...

MySQL uses the truncate command to quickly clear all tables in a database

1. Execute the select statement first to generate...

Upgrading Windows Server 2008R2 File Server to Windows Server 2016

The user organization has two Windows Server 2008...

How to deploy SpringBoot project using Docker

The development of Docker technology provides a m...