MySQL log file directory

By default, the MySQL binary log file is saved in the default data directory, such as:/usr/local/mysql/data

To modify the log save Directory (/backup/mysqlbinlog/mysql-bin):

Log-bin entries in the/etc/my.cnf file, such as Log-bin=/backup/mysqlbinlog/mysql-bin

MYSQL-BIN.0000XX logs are generated in directory/backup/mysqlbinlog/after MySQL is restarted

Note: Delete log restart when Mysql-bin.index and mysql-bin.0000xx need to be removed to restart or will be error

MySQL log file directory