Home >Database >Mysql Tutorial >mysql无法启动恢复解决_MySQL

mysql无法启动恢复解决_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:30:511159browse

bitsCN.com

mysql无法启动恢复解决

 

mysql无法启动可能原因 

 

1.mysql.ini  可能是由于mysql路径或者数据文件地址错误 

 

会报错   mysql 无法启动,错误1067,进程意外终止 

 

解决办法:修改my.ini 

 

2.mysql bin下面文件随坏,肯那个被病毒破坏 

 

解决办法:找个正常mysql替换bin目录 

 

3.data文件损坏 这个是最麻烦的 

 

配置文件my.ini里加这个innodb_force_recovery=4强制启动 

 

然后导出需要的信息 

 

重装了一个mysql将导出数据还原进去 

 

bitsCN.com
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn