Shulou(Shulou.com)06/02 Report--

Editor to share with you the use of linux mysqlbinlog command to view binary log files, I believe that most people do not know much, so share this article for you to learn, I hope you will learn a lot after reading this article, let's go to learn the method!

Use the mysqlbinlog command to view the binary log file, which records all DDL and DML statements.

Syntax format: mysqlbinlog [parameters] [log file]

Common parameters:

Reference example

View the binary log file / var/lib/mysql/mysqld-bin.0001:

[root@linuxcool ~] # mysqlbinlog / var/lib/mysql/mysqld-bin.0001

Query the binlog for a period of time:

[root@linuxcool] # mysqlbinlog-- start-datetime= "2017-01-09 17:50:00"-- stop-datetime= "2017-01-09 18:00:00" bin.000025

Mysqlbinlog dismantles the library, dismantles all operations of the test library, and then restores:

[root@linuxcool ~] # mysqlbinlog-d test mysqlbin.000002 > test.sql above is to use linux's mysqlbinlog command to view all the contents of the binary log file, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.