直接杀进程导致mysql重启一直报错 ps 删除之前都先备份
查看状态报错
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]
mysql没有启动 用ps查看进程没有残留的mysql进程
查询mysql日志
报错Error: all log files must be created at the same time.
日志文件创建时间不一致 删除ib_logfile0 ib_logfile1 文件
再次重启
Error: space header page consists of zero bytes in data file
应该同步删除ibdata1
再次重启
Failed to open log (file ‘./mysql-bin.000029’, errno 2)
查看mysql-bin.index 里面的文件如果没有存在的mysql-bin.000029 就要删除对应的这一行
再次重启
终于成功了