MySQL错误修复:Table xx is marked as crashed and last (automatic?) repair
数据库坏了,访问网站报错如下:
Error establishing a database connection
看了下
Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed
修复很简单,先停止
进入到
然后执行如下命令:
执行完成后,为了保险起见,我们要将文件的权限改回
启动
最后,执行再次自动修复优化命令即可解决:
1
|
mysqlcheck --auto-repair --optimize --all-databases -p
|
转载请注明:代码学堂>数据库 > MySQL教程 > MySQL错误修复:Table xx is marked as crashed and last (automatic?) repair
随机文章
- 1mysql主从复制配置详细步骤
- 2分布式服务器集群架构的演变
- 3新手mysql数据库开发误区及常犯的10个错误
- 4MySQL错误修复:Table xx is marked as crashed and last (automatic?) repair
- 5MySQL主从报错解决:Failed to initialize the master info structure
- 6MySQL错误修复记录:Table xx is marked as crashed and should be repaired
- 7MySQL主从、字典死锁、连接数的Python监控脚本
- 8MySQL命令行工具:percona-toolkit安装使用初探
排行榜