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

admin

mysql> show binary logs;
. N# [: y* A% s6 g- Q1 x1 |2 N" kERROR 1381 (HY000): You are not using binary logging
5 K$ z$ @) X4 [( f+ n& s
解决办法：
$ L: X0 s2 b" w2 F8 s) A修改my.cnf文件：
, c& q, w9 ^  Z% n( d在[mysqld]中添加
log-bin=log-bin.log    binlog日志：
并设置3天清理一次bin.log日志
expire_logs_days=3
1 \" J  N3 Y! U6 h9 b重启数据：
service mysqld restart
Shutting down MySQL. SUCCESS!
3 I: k8 S& h9 i" X7 h" vStarting MySQL. SUCCESS!

. |9 }. G! T' E8 s* ?3 I/ U6 p& d6 {
4 @8 p& K9 }/ R2 ?6 D( i删除binlog日志
mysql> show binary logs;
% X% P" `% g9 \* b7 s2 W! c+----------------+-----------+
| Log_name       | File_size |
7 @+ `$ D! x1 K3 S$ A; p$ G% `+----------------+-----------+
| log-bin.000001 |     56932 |
% a& L! p- y; O1 ]4 I| log-bin.000002 |    116186 |
| log-bin.000003 |     21390 |
" r- b- m8 P$ q; ?% L| log-bin.000004 |    125912 |
+----------------+-----------+
4 rows in set (0.00 sec)
mysql> purge binary logs to 'log-bin.000001';
Query OK, 0 rows affected (0.00 sec)
* A/ R+ A- L7 w6 [
& M+ t; o; ~0 N6 J' D5 ?6 b% }