宝塔：MySQL无法启动解决方案
宝塔：MySQL无法启动解决方案
/www/server/mysql/bin/mysqld: Shutdown complete
MySQL版本5.5。
故障现象：
MySQL无法启动，报错信息如下：
190228 9:19:43 [ERROR] Can't init tc log 190228 9:19:43 [ERROR] Aborting 190228 9:19:43 InnoDB: Starting shutdown... 190228 9:19:44 InnoDB: Shutdown completed; log sequence number 1595685 190228 9:19:44 [Note] /www/server/mysqi/bin/mysqld: Shutdown complete 190228 9:27:50 [Note] Plugin FEDERATED" is disabled. 190228 9:27:50 InnoDB: The InnoDB memory heap is disabled 190228 9:27:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins 190228 9:27:50 InnoDB: Compressed tables use zlib 1.2.3 190228 9:27:50 InnoDB: Using Linux native AIO 190228 9:27:50 InnoDB: Initializing buffer pool, size = 128.0M 190228 9:27:50 InnoDB: Completed initialization of buffer pool 190228 9:27:50 InnoDB: highest supported file format is Barracuda. 190228 9:27:51 InnoDB: Waiting for the background threads to start 190228 9:27:52 InnoDB: 5.5.61 started; log sequence number 1595685 /www/server/mysql/bin/mysqld: File './mysql-bin.000012' not found (Errcode: 2) 190228 9:27:52 [ERROR] Failed to open log (file ‘/mysql-ben.000012', ermo 2)190228 9:27:52 [ERROR] Could not open log file190228 9:27:52 [ERROR] Can't init tc log 190228 9:27:52 [ERROR] Aborting 190228 9:27:52 InnoDB: Starting shutdown... 190228 9:27:54 InnoDB: Shutdown completed; log sequence number 1595685 190228 9:27:54 [Note] /www/server/mysqi/bin/mysqld: Shutdown complete
故障原因：
MySQL日志文件找不到或者损坏。
解决方案：
SSH输入：
/etc/init.d/mysqld stop rm -f /www/server/data/ib_logfile*rm -f /www/server/data/mysql-bin.*/etc/init.d/mysqld start