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

This post is about how to view binlog binary logs in mysql. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

For example, when creating a new table or updating data on an existing table, these events are stored in mysql binlog, the binary log of the MySQL database.

Binary logs are useful in MySQL replication, where the master server sends data from binary logs to remote servers.

When you perform any type of recovery operation in MySQL, you will also process binary log files.

The mysqlbinlog command is used to view the contents of the binary log in a readable, user-friendly format.

So how do we get access to mysql binlog?

Here is how to get the current binary log list command.

Execute the following show binary logs command from mysql, which displays all binary logs in the system.

mysql> SHOW BINARY LOGS;+-------------------+-----------+| Log_name | File_size |+-------------------+-----------+| mysqld-bin.000001 | 15740 || mysqld-bin.000002 | 3319 |....

If binary logging is not enabled on your system, you will see the following error message.

mysql> SHOW BINARY LOGS;ERROR 1381 (HY000): You are not using binary logging

Where is mysql binlog located?

By default, binary log files are located in the/var/lib/mysql directory, as shown below.

# ls -l /var/lib/mysql/-rw-rw----. 1 mysql mysql 15740 Aug 16 14:57 mysqld-bin.000001-rw-rw----. 1 mysql mysql 3319 Aug 16 14:57 mysqld-bin.000002.... Thank you for reading! About "how to view binlog binary log in mysql" this article is shared here, I hope the above content can be of some help to everyone, so that everyone can learn more knowledge, if you think the article is good, you can share it to let more people see it!

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.