MYSQL binary Log

Pre-Preparation:

By default, MySQL does not have logs, add logs and log files, and we can configure it ourselves.

configuration file is My.ini;

MYSQLD node;

The configuration item is log-bin;

To specify a path and name for the file. if: E:/db/mysq_log/mysqlbinlog

--------------------------------------------------------------------------------------------------------------- -----------------------------------

Configure the log file path and save:

To restart the MySQL service:

net start MySQL;

Log file:

MYSQL binary Log