Mysql 查看和启用二进制日志
环境： RHEL 5.4
查看是否启用日志：
1. 查看是否启用了日志
mysql>show variables like 'log_bin';
Empty set (0.00 sec)
2. 查看当前的日志
mysql> show master status;
开启日志服务 :
在 my.ini 或 my.cnf 文件添加 log-bin 行
linux 可能为 my.cnf, 其实只需要在 [mysqld] 项，把 log-bin 前面的 # 注释掉即可
[root@MailSvr2 conf]# more my.cnf
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3308
socket = /home/coremail/var/mysql/mysql.sock
default-character-set=GBK
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3308
socket = /home/coremail/var/mysql/mysql.sock
datadir = /home/coremail/var/mysql
key_buffer = 256M
max_allowed_packet = 5M
table_cache = 256
评论0