差異處

這裏顯示兩個版本的差異處。

--- database:mysql:binlog [2014/05/31 08:22]
ali88 [刪除Bin-log]
+++ database:mysql:binlog [2014/05/31 08:24] (目前版本)
ali88 [刪除Bin-log]
@@ 行 53: / 行 53: @@
 | mysql-bin.000004 |       149 |
 | mysql-bin.000005 |       106 |
-+------------------+-----------+</code>若再用mysql的**purge**<code>mysql> purge binary logs to 'mysql-bin.000005'; Query OK, 0 rows affected, 1 warning (0.03 sec)</code>
++------------------+-----------+</code>若再用mysql的**purge**<code>mysql> purge binary logs to 'mysql-bin.000005';
+Query OK, 0 rows affected, 1 warning (0.03 sec)</code>看warning 訊息<code>mysql> show warnings;</code><code>+---------+------+---------------------------------------------------+
+| Level   | Code | Message                                           |
++---------+------+---------------------------------------------------+
+| Warning | 1612 | Being purged log ./mysql-bin.000001 was not found |
++---------+------+---------------------------------------------------+</code>
 ======參考資料======
   - [[http://blog.longwin.com.tw/2009/04/mysql-binlog-recovery-range-by-date-time-2009/|MySQL 使用 binary log 回覆 某段時間區間 的資料]]

阿里BaBa電腦筆記