mysql 日志 拥塞,mysqlbinlog

1)查看binlog日志是否开启 show global variables like '%bin%'

2)查看日志信息 show master status;

3) 刷新日志 flush logs; 重置日志 rest master

4) mysqlbinlog的使用

a)查看日志信息  /usr/local/mysql/bin/mysqlbinlog ./mysql-bin.000002 > /tmp/logbin.txt

b) 数据恢复  安位置恢复  c:\mysql\bin\>mysqlbinlog --start-position=185 --stop-position=338 e:/log/logbin.000001 | mysql -u root -p

按时间恢复 c:\mysql\bin\>mysqlbinlog --start-datetime="2010-01-07 11:25:56" --stop-datetime="2010-01-07 13:23:50" e:/log/logbin.000001 | mysql -u root -p

5)  mysql 的备份和导入

/usr/local/mysql/bin/mysqldump -uroot -p*** -l -F >> /tmp/aaa.log

c:\mysql\bin\>mysql -e "source e:/log/mysqldump.sql"