The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. … It contains all statements that update data. It also contains statements that potentially could have updated it (for example, a DELETE which matched no rows), unless row-based logging is used.

Is it safe to delete mysql binary logs?

No, you should not delete them by hand. If you delete them at the disk level, mysql will crash. The command to remove them is: PURGE BINARY LOGS TO ‘mysql-bin.

How do you read binary logs?

1. Get a List of Current Binary Logs. From mysql, execute the following show binary logs command which will display all the binary logs in your system. mysql> SHOW BINARY LOGS; +——————-+———–+ | Log_name | File_size | +——————-+———–+ | mysqld-bin.