整体思路 参考:https://blog.csdn.net/java_1992/article/details/80498109
https://www.cnblogs.com/glon/p/6728380.html
服务器mysql挂掉之后,无法启动;
解决思路
大体流程就是
- innodb_force_recovery = 4 进入数据库
- 备份数据库
- 删库
- 建库导入sql语句
操作
1. 先添加参数
vim /etc/mysql/mysql.conf.d/mysqld.cnf | grep innodb
#innodb_force_recovery = 4
2. 重启mysql进入mysql
#systemctl start mysql
mysql -uroot -p
3.备份数据
备份参考 https://blog.csdn.net/shengjie87/article/details/108302127