|
|
mysql> show binary logs;
' n5 t% M6 I8 ?! y; LERROR 1381 (HY000): You are not using binary logging" }6 k+ |0 w) x4 [! w
( {1 e( j/ V0 L/ w* h, X. D8 O
解决办法：( `) T5 v( U, y6 _
修改my.cnf文件：
! l+ ?- g3 E9 M/ ~在[mysqld]中添加
+ i% _" b9 S/ s: q! C7 }log-bin=log-bin.log binlog日志：/ [( `3 S5 B9 e
并设置3天清理一次bin.log日志! {7 {! a% Q! e6 a
expire_logs_days=3
5 j) O& h* K+ e4 d重启数据：! C4 n I! ^* V4 m/ N3 X
service mysqld restart" x% `; k/ w* _
Shutting down MySQL. SUCCESS! 4 H/ q4 U9 e$ V: ?8 A" h- {& u
Starting MySQL. SUCCESS!
3 ?; a, o5 f* f1 u! L% H6 o9 \: u) [, }
2 J8 A e/ x9 Z6 A删除binlog日志& s8 |5 {; S8 L \3 w7 C/ p# ]' k
mysql> show binary logs;' A' ~* ?- _. d- V5 {
+----------------+-----------+
4 \* Q8 S+ j, z* s' x( i& Y% k; y| Log_name | File_size |
/ u. a Y% B$ P, }8 Z$ g. h( C* Q+----------------+-----------+! {1 S% a( ?! B
| log-bin.000001 | 56932 |1 ]$ m ]8 S' V& Q q: y7 Z
| log-bin.000002 | 116186 |0 B2 i) p% o7 r5 o. ~8 ~
| log-bin.000003 | 21390 |& S# L+ S+ Q8 \# c9 q
| log-bin.000004 | 125912 |+ B% Q* P! U$ N5 U0 ~. O+ u
+----------------+-----------+
4 |5 C9 s7 S; M% S$ b7 ]4 rows in set (0.00 sec)
# n7 ^2 A- f# E8 Nmysql> purge binary logs to 'log-bin.000001';$ Q5 ?, p1 h% B6 K6 x, a! F! u
Query OK, 0 rows affected (0.00 sec)
; ]7 k/ T& i( ]& d
4 R# a- K/ U; A9 \1 M6 P# E( w5 r l/ t" D: T3 N) a/ o% D
|
|
发表于 2020-2-20 15:50:53