Posts

Showing posts from January, 2014

'.\mysql-bin.000078' not found (Errcode: 2 - No such file or directory)

如果你的 mysql 有開啟 log-bin 那麼在 data 資料夾下就會有一堆的 mysql-bin.00001 等依序產生的檔案 這個檔案超過 1G 或是重開就會繼續產生下一個 (在 production mode 這些是很重要的) 但在測試的環境下還蠻占空間的 上次無意識的把他刪除了 今天要開啟 mysql 才發現無法啟動 會出現下面錯誤訊息: 2014-01-26 19:47:57 8844 [Note] Plugin 'FEDERATED' is disabled. 2014-01-26 19:47:57 8844 [Note] InnoDB: The InnoDB memory heap is disabled 2014-01-26 19:47:57 8844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2014-01-26 19:47:57 8844 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-01-26 19:47:57 8844 [Note] InnoDB: Not using CPU crc32 instructions 2014-01-26 19:47:57 8844 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2014-01-26 19:47:57 8844 [Note] InnoDB: Completed initialization of buffer pool 2014-01-26 19:47:57 8844 [Note] InnoDB: Highest supported file format is Barracuda. 2014-01-26 19:47:57 8844 [Note] InnoDB: 128 rollback segment(s) are active. 2014-01-26 19:47:58 8844 [Note] InnoDB: Waiting for purge to start 2014-01-26 19:47:58 8844 [Note] InnoD