ERROR 1381 (HY000): You are not using binary logging

admin

mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging

/ s' Z3 ~" s/ W0 F5 [  k解决办法：
修改my.cnf文件：
在[mysqld]中添加
log-bin=log-bin.log    binlog日志：
并设置3天清理一次bin.log日志
5 }) C# U+ y6 j: K" aexpire_logs_days=3
重启数据：
service mysqld restart
" y7 \" v; n& f: R( }8 N  sShutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!


删除binlog日志
mysql> show binary logs;
+----------------+-----------+
( R( r1 q& }9 t9 Q. I5 l% D- e| Log_name       | File_size |
+----------------+-----------+
& z5 H3 b+ D3 h| log-bin.000001 |     56932 |
9 `( N$ \0 [9 N' H7 w4 M' G& n# _/ ?. \| log-bin.000002 |    116186 |
| log-bin.000003 |     21390 |
| log-bin.000004 |    125912 |
, V# j# r. O5 n3 F' a+----------------+-----------+
; y9 s: o  N( K4 rows in set (0.00 sec)
mysql> purge binary logs to 'log-bin.000001';
( |2 f- H& A7 a1 H+ p& UQuery OK, 0 rows affected (0.00 sec)
; x- J7 Q4 g3 T. @9 }' f6 g8 N
" Z$ e1 F4 z9 c% u6 D# B9 l
2 x: L9 p2 V( n0 Z9 w+ @6 u