Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the function of MySQL 5.5mysqlbinlog". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the function of MySQL 5.5mysqlbinlog"?

You can display the contents of binary log files through mysqlbinlog

The common parameters are as follows:

-- set-charset=charset_name adds a SET NAMES charset_name statement to the output file to specify the character set for processing log files

-- database=db_name,-d db_name displays only the log contents related to the database

-- start-datetime=datetime specifies the start time of log analysis

-- stop-datetime=datetime specifies the end point of log analysis

-- start-position=N,-j N specify the starting position of log analysis, that is, the number after # at

-- stop-position=N specifies where the log analysis ends

-- base64-output=value uses base-64 encoding format to display binary log contents

The AUTO ("automatic") or UNSPEC ("unspecified") parameters automatically display the contents of the binary statement. If the-- base64-output parameter is not specified, the effect is equivalent to-- base64-output=AUTO.

The NEVER parameter causes the binary statement not to be displayed

DECODE-ROWS decoding handles binary logs.

-- verbose,-v reassembles the events of the line and displays them as SQL statements with comments. If this parameter is specified twice, the output contains comments and indicates the field data type and some metadata.

[root@localhost binlog] # / software/bin/mysqlbinlog-- base64-output=decode-rows-v mysql-bin.000007 | more

[root@localhost binlog] # / software/bin/mysqlbinlog-- base64-output=decode-rows-v-v mysql-bin.000007 | more

-- incremental recovery using binary log files

-- method ①

[root@localhost binlog] # / software/bin/mysqlbinlog mysql-bin.000007 | mysql- usystem-paired MySQL 2015'

-- method ②

[root@localhost binlog] # / software/bin/mysqlbinlog mysql-bin.000007 > / backup/inc_000007.sql

[root@localhost binlog] # / software/bin/mysql-usystem-paired MySQL 2015 < / backup/inc_000007.sql

At this point, I believe you have a deeper understanding of "what is the role of MySQL 5.5mysqlbinlog". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.