mysql-log
View turn on or not
SELECT * from information_schema.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'LOG_BIN';
SHOW VARIABLES LIKE 'log_bin';
SHOW BINARY LOGS;
Turn on the Log
vi /etc/mysql/my.cnf or /etc/my.cnf or /usr/etc/my.cnf or ~/.my.cnf
log-bin=mysql-bin
The log inside /var/log/mysql/error.log
沒有留言:
張貼留言