【待反馈】mysql启动不了

卸载重装也不好使

旧服务器硬盘出问题，服务商换了个新盘，新系统，重新装了宝塔，挂载上旧盘准备迁移数据，但是mysql死活启动不起来，也没有log，打开宝塔的性能调整全部为0，重装过n遍mysql，也换过版本，都不行，宝塔也重装过

您好，你有试过不挂载旧盘能正常启动MySQL嘛？

谢花郎 发表于 2021-5-7 15:17
您好，你有试过不挂载旧盘能正常启动MySQL嘛？

2021-05-07T07:28:26.537276Z 0 [Note] Binlog end
2021-05-07T07:28:26.549492Z 0 [Note] Shutting down plugin 'ngram'
2021-05-07T07:28:26.549521Z 0 [Note] Shutting down plugin 'partition'
2021-05-07T07:28:26.549531Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-05-07T07:28:26.549541Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-05-07T07:28:26.549549Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-05-07T07:28:26.549682Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-05-07T07:28:26.549693Z 0 [Note] Shutting down plugin 'MyISAM'
2021-05-07T07:28:26.549801Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2021-05-07T07:28:26.549818Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2021-05-07T07:28:26.549827Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2021-05-07T07:28:26.549835Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2021-05-07T07:28:26.549842Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2021-05-07T07:28:26.549850Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2021-05-07T07:28:26.549858Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2021-05-07T07:28:26.549865Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2021-05-07T07:28:26.549873Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2021-05-07T07:28:26.549881Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2021-05-07T07:28:26.549888Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2021-05-07T07:28:26.549896Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2021-05-07T07:28:26.549903Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2021-05-07T07:28:26.549911Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2021-05-07T07:28:26.549919Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2021-05-07T07:28:26.549926Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2021-05-07T07:28:26.549934Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2021-05-07T07:28:26.549941Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2021-05-07T07:28:26.549956Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2021-05-07T07:28:26.549964Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2021-05-07T07:28:26.549972Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2021-05-07T07:28:26.549979Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2021-05-07T07:28:26.549987Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2021-05-07T07:28:26.549995Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2021-05-07T07:28:26.550002Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2021-05-07T07:28:26.550010Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2021-05-07T07:28:26.550017Z 0 [Note] Shutting down plugin 'INNODB_CMP'

2021-05-07T07:28:28.135888Z 0 [Note] Shutting down plugin 'MEMORY'
2021-05-07T07:28:28.135902Z 0 [Note] Shutting down plugin 'CSV'
2021-05-07T07:28:28.135911Z 0 [Note] Shutting down plugin 'sha256_password'
2021-05-07T07:28:28.135918Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-05-07T07:28:28.136108Z 0 [Note] Shutting down plugin 'binlog'
2021-05-07T07:28:28.148044Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

宝塔用户_xngues 发表于 2021-5-7 15:28
2021-05-07T07:28:26.537276Z 0 [Note] Binlog end
2021-05-07T07:28:26.549492Z 0 [Note] Shutting down ...

没有具体的error级别日志，执行下面查找一下MySQL的日志有无error级别日志

1. cat /www/server/data/*.err  | grep -i -C 10 error

复制代码

谢花郎 发表于 2021-5-7 15:32
没有具体的error级别日志，执行下面查找一下MySQL的日志有无error级别日志

...

2021-05-07T07:35:22.327114Z 0 [Note] Binlog end
2021-05-07T07:35:22.339304Z 0 [Note] Shutting down plugin 'ngram'
2021-05-07T07:35:22.339331Z 0 [Note] Shutting down plugin 'partition'
2021-05-07T07:35:22.339342Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2021-05-07T07:35:22.339351Z 0 [Note] Shutting down plugin 'ARCHIVE'
2021-05-07T07:35:22.339360Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2021-05-07T07:35:22.339491Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2021-05-07T07:35:22.339502Z 0 [Note] Shutting down plugin 'MyISAM'
2021-05-07T07:35:22.339527Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'

附件附件附件附件附件

第二个err

宝塔用户_xngues 发表于 2021-5-7 15:42
第二个err

找到这个/tmp/mysql.sock文件后，把它删除重新启动MySQL看看。
提示/tmp/mysql.sock这个文件被占用了。

谢花郎 发表于 2021-5-7 15:44
找到这个/tmp/mysql.sock文件后，把它删除重新启动MySQL看看。
提示/tmp/mysql.sock这个文件被占用了。 ...

我把以前的数据库文件复制到新的mysql数据库文件下访问不了mysql #1146 - Table 'aolibo2.fa_active_record' doesn't exi

宝塔用户_xngues 发表于 2021-5-7 16:23
我把以前的数据库文件复制到新的mysql数据库文件下访问不了mysql #1146 - Table 'aolibo2.fa_active_reco ...

已经提示这个表不存在，通过MySQL物理文件恢复概率比较。
而且也不能确定你出问题前是否表存在

谢花郎 发表于 2021-5-7 16:27
已经提示这个表不存在，通过MySQL物理文件恢复概率比较。
而且也不能确定你出问题前是否表存在 ...

之前都可以正常访问

宝塔用户_xngues 发表于 2021-5-7 16:35
之前都可以正常访问

这个不清楚你之前的环境，要么尝试找一下DBA给你看看能不能恢复。

谢花郎 发表于 2021-5-7 16:39
这个不清楚你之前的环境，要么尝试找一下DBA给你看看能不能恢复。

怎么找dba