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

admin

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

解决办法：
修改my.cnf文件：
* C" \: c+ Q. ^, i+ ?在[mysqld]中添加
log-bin=log-bin.log    binlog日志：
并设置3天清理一次bin.log日志
4 J  H( o2 [9 v) x; |3 dexpire_logs_days=3
6 ~& o# H) w1 f6 C% J重启数据：
service mysqld restart
Shutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!
' L; y" F7 v( \$ U! v" _
' {( u- K; F" W. J- X
' D2 d& h8 X' S& j+ m2 I- ]& l删除binlog日志
mysql> show binary logs;
" r1 n) D, E1 ?; J. p4 w# g+----------------+-----------+
| Log_name       | File_size |
+----------------+-----------+
! E& e1 K+ `7 F5 u: ^6 p| log-bin.000001 |     56932 |
| log-bin.000002 |    116186 |
% L/ h' ^$ j6 g! b% I5 y) E0 I| log-bin.000003 |     21390 |
| log-bin.000004 |    125912 |
6 p; s% D" i7 `6 O1 |& N+----------------+-----------+
4 rows in set (0.00 sec)
% p) V. `% q9 F6 d0 ]9 Z' @mysql> purge binary logs to 'log-bin.000001';
$ P& j' R% c1 E. b1 lQuery OK, 0 rows affected (0.00 sec)
  X5 T: r2 C) O9 S" e