Mysqlbinlog realizes simple operation of visually viewing sql statements

The following mainly brings you mysqlbinlog visual view sql statement simple operation, hope that mysqlbinlog visual view sql statement simple operation can bring you practical use, this is also my main purpose of editing this article. All right, don't talk too much nonsense, let's just read the following.

Direct mysqlbinlog export of the file, the execution of the sql part of the sql statement is displayed in base64 encoding format, can not be read normally.

Therefore, when generating sql records, we cannot generate them in the usual way. We need to add the corresponding parameters to display the sql statement.

-base64-output=decode-rows-v

For example

Mysqlbinlog-- base64-output=decode-rows-v-- start-date='2017-05-16 12 12 start-date='2017 00'-- stop-date='2017-05-31 16 16 purge 2020 stop-date='2017 / root/mysql-bin | gzip > mysql.sql.gz

For the above visualization of mysqlbinlog to view the simple operation of sql statements, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.