【已回应】MySQL启动不了

求大神帮忙，昨晚上不小心点了MySQL工具的更新，今天这个工具就启动不了，求发大神帮忙

您好，贴一下MySQL错误日志看看，错误日志路径:/www/server/data/机器名.err

谢花郎 发表于 2019-12-2 09:07
您好，贴一下MySQL错误日志看看，错误日志路径:/www/server/data/机器名.err

文件有24M，打不开 ，可以帮我进面板里面看一下吗
谢谢

谢花郎 发表于 2019-12-2 09:07
您好，贴一下MySQL错误日志看看，错误日志路径:/www/server/data/机器名.err

2019-12-02T01:05:47.515815Z 0 [Note] Binlog end
2019-12-02T01:05:47.515900Z 0 [Note] Shutting down plugin 'ngram'
2019-12-02T01:05:47.515909Z 0 [Note] Shutting down plugin 'ARCHIVE'
2019-12-02T01:05:47.515912Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2019-12-02T01:05:47.515916Z 0 [Note] Shutting down plugin 'partition'
2019-12-02T01:05:47.515920Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2019-12-02T01:05:47.515923Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2019-12-02T01:05:47.515927Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2019-12-02T01:05:47.515930Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2019-12-02T01:05:47.515933Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2019-12-02T01:05:47.515936Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2019-12-02T01:05:47.515940Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2019-12-02T01:05:47.515943Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2019-12-02T01:05:47.515946Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2019-12-02T01:05:47.515949Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2019-12-02T01:05:47.515953Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2019-12-02T01:05:47.515956Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2019-12-02T01:05:47.515959Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2019-12-02T01:05:47.515962Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2019-12-02T01:05:47.515965Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2019-12-02T01:05:47.515969Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2019-12-02T01:05:47.515972Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2019-12-02T01:05:47.515975Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2019-12-02T01:05:47.515978Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2019-12-02T01:05:47.515982Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2019-12-02T01:05:47.515985Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2019-12-02T01:05:47.515988Z

谢花郎 发表于 2019-12-2 09:07
您好，贴一下MySQL错误日志看看，错误日志路径:/www/server/data/机器名.err

是这个吗  日志很多 我贴的最新的

宝塔用户_fqbqgs 发表于 2019-12-2 09:16
文件有24M，打不开 ，可以帮我进面板里面看一下吗
谢谢

已经可以了，报错提示找不到binlog日志，你应该是有做清理日志的操作。将mysql-bin.index索引文件内容清空后重新启动数据库就可以了。

谢花郎 发表于 2019-12-2 10:01
已经可以了，报错提示找不到binlog日志，你应该是有做清理日志的操作。将mysql-bin.index索引文件内容清 ...

谢谢，恢复了