宝塔:MySQL无法启动解决方案

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 file  190228 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

 

常见问题
资源支持商用吗?
不支持商用,仅供学习,请下载后24H内删除!
资源采用什么网盘下载?
小于100M使用蓝奏云,大于100M使用阿里云和123云盘!
资源为什么不能使用?
资源有时效性及各种方面的兼容性,不保证一直都能用!
有其他问题如何联系?
1、评论留言 2、用户中心提交工单 3、联系小编QQ:429413218(09:00 -21:00)
免责声明
0

评论0

请先
Scrapes 文章内容可视化采集WP插件汉化版(v3.2)
Scrapes 文章内容可视化采集WP插件汉化版(v3.2)
6分钟前 有人购买 去瞅瞅看

站点公告

自由发电 - 资源订阅下载平台

防丢:必应搜索小小资源铺

显示验证码
没有账号?注册  忘记密码?