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

admin

mysql> show binary logs;
- o! S3 U7 x. b8 cERROR 1381 (HY000): You are not using binary logging

解决办法：
, c8 k: a' B8 O" I修改my.cnf文件：
在[mysqld]中添加
- l( o4 O, K) P" J4 Tlog-bin=log-bin.log    binlog日志：
并设置3天清理一次bin.log日志
. J* d8 u; h) ~+ I& L# qexpire_logs_days=3
重启数据：
! z1 j. o3 x! h) Kservice mysqld restart
Shutting down MySQL. SUCCESS!
Starting MySQL. SUCCESS!
6 v7 B9 K. o# Q' F
) n% `2 H9 G, B  o
  I% B2 z. _; i/ y删除binlog日志
8 A1 W) A9 J8 t- c! x$ imysql> show binary logs;
2 H7 @; P8 ]# j! n1 z+----------------+-----------+
8 \/ h# k( t4 s/ l  q| Log_name       | File_size |
+----------------+-----------+
6 C7 {: `+ P3 P9 D+ X| log-bin.000001 |     56932 |
| log-bin.000002 |    116186 |
5 i% y2 L- `, z" W! J| log-bin.000003 |     21390 |
- V, Z+ g5 k% H6 C, x0 D: H| log-bin.000004 |    125912 |
+----------------+-----------+
2 s' s% g3 w$ b4 N2 s4 rows in set (0.00 sec)
6 l% M+ o  h) |2 d9 r& N3 Nmysql> purge binary logs to 'log-bin.000001';
6 m5 Y# r, W& F) B) vQuery OK, 0 rows affected (0.00 sec)
$ z0 u# E$ p6 [: D0 g, w, H
. u" B. Z2 f( t