XAMPP的MYSQL無法啟動

標籤：style   blog   http   io   ar   color   os   使用   sp   

昨天用各種方式實驗MYSQL的Database Backup與恢複操作，恢複過程中，MYSQL就無法啟動了。

提示如下：

22:59:43  [mysql]     Attempting to start MySQL app...22:59:43  [mysql]     Status change detected: running22:59:44  [mysql]     Status change detected: stopped22:59:44  [mysql]     Error: MySQL shutdown unexpectedly.22:59:44  [mysql]     This may be due to a blocked port, missing dependencies, 22:59:44  [mysql]     improper privileges, a crash, or a shutdown by another method.22:59:44  [mysql]     Press the Logs button to view error logs and check22:59:44  [mysql]     the Windows Event Viewer for more clues22:59:44  [mysql]     If you need more help, copy and post this22:59:44  [mysql]     entire log window on the forums

This may be due to a blocked port, missing dependencies, 首先我看了連接埠，3306連接埠並沒有被佔用。

網上看到一個運行批次檔的解決辦法，但是需要重啟：

http://wenku.baidu.com/link?url=fqqupfW1yxGYGtw3tGZe9HvzQxrSb2zQ3wiOJAi01ncikuFJAE1LJqQv0J97AocA-trfWz_wpaJQfjDTxWTC4mSahput3mJMchK3BgFWlGa

 我就X了，剛剛寫了一大堆，結果提交後顯示找不到伺服器，，，，然後草稿箱裡也沒有，真是各種背

 

總之就是各種方法都試了，都無法解決，最後只能重新卸載重裝解決的。

 

剛才將E:\xampp_new\mysql\data 資料庫的檔案替換了一下，替換後，mysql就無法啟動了，終於找到了mysql無法啟動的原因，就是因為替換data資料庫檔案造成的。

 

多次刪除ibdata1、ib_logfile1、ib_logfile0 後，mysql才可以啟動，第一次刪除後，確實依然無法啟動。

 

通過操作發現，使用直接複製、粘貼資料庫檔案的方法，對資料庫進行恢複，是不可行的，會造成資料庫無法啟動，就算後面刪除記錄檔，資料庫可以啟動了，也是無法瀏覽資料庫內的表檔案的。

錯誤記錄檔：

2014-11-25 23:57:55 4336 [Note] Plugin ‘FEDERATED‘ is disabled.2014-11-25 23:57:55 2720 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB‘s internal memory allocator.2014-11-25 23:57:55 4336 [Note] InnoDB: Using atomics to ref count buffer pool pages2014-11-25 23:57:55 4336 [Note] InnoDB: The InnoDB memory heap is disabled2014-11-25 23:57:55 4336 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions2014-11-25 23:57:55 4336 [Note] InnoDB: Compressed tables use zlib 1.2.32014-11-25 23:57:55 4336 [Note] InnoDB: Not using CPU crc32 instructions2014-11-25 23:57:55 4336 [Note] InnoDB: Initializing buffer pool, size = 16.0M2014-11-25 23:57:55 4336 [Note] InnoDB: Completed initialization of buffer pool2014-11-25 23:57:55 4336 [Note] InnoDB: Highest supported file format is Barracuda.2014-11-25 23:57:55 4336 [Warning] InnoDB: Resizing redo log from 2*3072 to 2*320 pages, LSN=16259872014-11-25 23:57:55 4336 [Warning] InnoDB: Starting to delete and rewrite log files.2014-11-25 23:57:55 4336 [Note] InnoDB: Setting log file E:\xampp_new\mysql\data\ib_logfile101 size to 5 MB2014-11-25 23:57:55 4336 [Note] InnoDB: Setting log file E:\xampp_new\mysql\data\ib_logfile1 size to 5 MB2014-11-25 23:57:56 4336 [Note] InnoDB: Renaming log file E:\xampp_new\mysql\data\ib_logfile101 to E:\xampp_new\mysql\data\ib_logfile02014-11-25 23:57:56 4336 [Warning] InnoDB: New log files created, LSN=16259872014-11-25 23:57:56 4336 [Note] InnoDB: 128 rollback segment(s) are active.2014-11-25 23:57:56 4336 [Note] InnoDB: Waiting for purge to start2014-11-25 23:57:56 4336 [Note] InnoDB: 5.6.16 started; log sequence number 16259872014-11-25 23:57:56 4336 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: d2275b21-74bb-11e4-8165-74d435fb4eb2.2014-11-25 23:57:56 4336 [Note] Server hostname (bind-address): ‘*‘; port: 33062014-11-25 23:57:56 4336 [Note] IPv6 is available.2014-11-25 23:57:56 4336 [Note]   - ‘::‘ resolves to ‘::‘;2014-11-25 23:57:56 4336 [Note] Server socket created on IP: ‘::‘.

 

XAMPP的MYSQL無法啟動