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

admin

mysql> show binary logs;
" h, ~2 S* ]& Z% ]" @ERROR 1381 (HY000): You are not using binary logging
; z7 `( F( K0 m  [' F; l  G4 ~
解决办法：
修改my.cnf文件：
在[mysqld]中添加
) D1 s0 z$ Z5 Q3 G0 x. o( k; ]# [$ Nlog-bin=log-bin.log    binlog日志：
并设置3天清理一次bin.log日志
  V: @; z7 f# q3 hexpire_logs_days=3
重启数据：
' b6 ]" z+ N( P. k; [/ Z, {1 m3 gservice mysqld restart
' o. x# K" {" V, l# V& t4 l( \Shutting down MySQL. SUCCESS!
  \& D& e' J: D5 y7 M, AStarting MySQL. SUCCESS!
' p. a+ `! L$ {( {9 q
. g, K8 i  d8 ]: M
0 m7 }. k, i7 ^; v7 K( o删除binlog日志
mysql> show binary logs;
( |0 B8 _( I/ |) ?+----------------+-----------+
* g1 b! h2 q2 ?7 D| Log_name       | File_size |
+----------------+-----------+
7 B- ?9 |" X7 P6 R5 C5 i, ?) _| log-bin.000001 |     56932 |
| log-bin.000002 |    116186 |
/ [7 c/ A: F$ {0 f| log-bin.000003 |     21390 |
- o) R) I% G  n1 w| log-bin.000004 |    125912 |
9 c. d. u* V9 G7 E' V+----------------+-----------+
$ t1 t* O5 c+ ]$ `4 rows in set (0.00 sec)
) K* o. i/ ]! D# Jmysql> purge binary logs to 'log-bin.000001';
2 Q, M* S; }& n0 sQuery OK, 0 rows affected (0.00 sec)
8 a1 p/ G1 Z1 \5 F