A simple method of extracting SQL based on time points using mysqlbinlog

This article mainly introduces the simple method of using mysqlbinlog to extract SQL according to the point in time, the content of the article is carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, let's learn about the simple method of using mysqlbinlog to extract SQL according to the point in time.

Export the binlog logs from the test library 2017-08-14 16:30:29 to 2017-08-14 17:30:31 as 1.sql:

Mysqlbinlog-- start-datetime= "2017-08-14 16:30:29"-- stop-datetime= "2017-08-14 17:30:31"-- database=test mysql-bin.000893 > 1.sql

For MIXED (partial SQL statements) and ROW mode are recorded in base-64 mode, the SQL section is displayed as base64 encoding, and two parameters need to be added to the normal display:

Mysqlbinlog-v-base64-output=DECODE-ROWS-start-datetime= "2017-08-14 16:30:29"-- stop-datetime= "2017-08-14 17:30:31"-- database=test mysql-bin.000893 > 1.sql

In addition, the mysqlbinlog command cannot filter the table directly, so it can be combined with the grep command to achieve the purpose of filtering the table.

After reading the above about the simple method of using mysqlbinlog to extract SQL according to the point in time, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information column.