Bin-log log Operations Command in MySQL

To see if the log is open

1. Can be confirmed by MySQL profile my.cnf (MySQL defaults to open binary logging):
# Replication Master Server (default)
# Binary logging is required for replication
Log-bin=mysql-bin

Refresh Log

Flush logs;

View current log Location

Show master status;

View all current logs

Show master logs;

Empty all Bin-log logs.

Reset Master;

View Log Contents

Mysqlbinlog–no-defaults mysql-bin.00001;

Delete Bin-log

Mysql> purge binary logs to ' ablelee.000003 ';

Query OK, 0 rows affected (0.16 sec)

Turn off Bin-log Log

Find the profile my.cnf, for Linux, generally by default in the/etc directory, open this file, use the pound sign (#) to comment out the following two configuration items.

Log-bin=mysql-bin
Binlog_format=mixed

Show all logs

Mysql> show binary logs;