使用版本:3.3.0
近來因為工作需要加上時程關係,沒辦法一個套件一個套件慢慢build,於是使用了XAMPP這個套件包快速的將所需的網路服務架設起來(方便就方便在它一直下一步到完成,未來有需要再去config調整即可)
不過由於Server有設定每週末會自動重開,重開機後mysql 的服務一直無法啟動
查看LOG 訊息如下:
=======================================================
Mutexes and rw_locks use Windows interlocked functions
Uses event mutexes
Compressed tables use zlib 1.2.11
Number of pools: 1
Using SSE2 crc32 instructions
Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
Completed initialization of buffer pool
Starting crash recovery from checkpoint LSN=300306
128 out of 128 rollback segments are active.
Removed temporary tablespace data file: "ibtmp1"
Creating shared tablespace for temporary tables
Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
Waiting for purge to start
10.4.19 started; log sequence number 300315; transaction id 170
Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
'FEEDBACK' is disabled.
socket created on IP: '::'.
=======================================================
雖然一開始初步爬文的結果是說Port被佔用了,但此server根本未安裝多餘的軟體(除了掃描文件自動歸類的軟體)
但為了求證據,還是下了netstat -b查看目前所占用的Port,也沒有關聯。
於是直接將mysql目錄中的backup資料夾中所有檔案覆蓋到data資料夾中,覆蓋前記得先備份data資料夾。