错误信息提示:Table 'my_information' is marked as crashed and should be repaired
来源:互联网 发布:mac os x 10.10虚拟机 编辑:程序博客网 时间:2024/06/05 11:02
今天遇到的数据库覆盖之后出现的问题
解决办法:首先需要定位到你的mysql的bin目录,里面包含myisamchk.exe文件的目录
./myisamchk -c -r 数据库表MYI文件的路径(例如:/home/mysql/var/crawlerfeedsky/aaaa.MYI)
如果还不行,就-f 强制修复
详细出处参考:http://www.jb51.net/article/17704.htm
windows服务器下mysql的修复方法:
F:\sqldata\mysql\bin>cd .. 返回上级目录
F:\sqldata\mysql>cd data 进入数据库所在目录(mysql的数据库文件都是放在data这个目录里面的)
F:\sqldata\mysql\data>cd jb51 进入数据库,windows服务器中数据库就是一个文件夹(这里以jb51为例子)
F:\sqldata\mysql\data\jb51>myisamchk -r jb51_soft
- recovering (with sort) MyISAM-table 'jb51_soft'
Data records: 7216
- Fixing index 1
- Fixing index 2
- Fixing index 3
F:\sqldata\mysql\data\jb51>
洛阳吃喝玩乐就去http://www.91htx.net
- 错误信息提示:Table 'my_information' is marked as crashed and should be repaired
- Table 'table_name' is marked as crashed and should be repaired
- Table 'xxxxxxx' is marked as crashed and should be repaired
- Table ‘xxx’ is marked as crashed and should be repaired ...
- linux Table is marked as crashed and should be repaired
- Table '.\tablename' is marked as crashed and should be repaired
- Table 'user_xxxxx' is marked as crashed and should be repaired
- Table is marked as crashed and should be repaired
- 修复 Table marked as crashed and should be repaired
- Table xxxis marked as crashed and should be repaired
- 表 is marked as crashed and should be repaired
- mysql错误:is marked as crashed and should be repaired
- is marked as crashed and should be repaired
- mysql错误is marked as crashed and should be repaired
- 解决“is marked as crashed and should be repaired”
- repair table `site_user`,#1194 – Table is marked as crashed and should be repaired错误修复
- Table 'this_' is marked as crashed and should be repaired (MYSQL数据错误解决)
- mysql:Table 'xxxxx' is marked as crashed and should be repaired
- A shallow understanding on deep learning
- 如何处理被拦截的键盘消息事件
- android195--force Close
- php查看运行时间、内存消耗
- Zencar配置文件修改详解
- 错误信息提示:Table 'my_information' is marked as crashed and should be repaired
- fork与vfork
- Mac OS环境下流媒体分割工具mediastreamsegmenter的简单使用
- iOS客户端的APNS服务简介与实现
- MyElipse8.5在线安装Aptana插件用于js自动提示及检查
- 在C++程序中如何调用C程序
- 如何在windows下提取某个文件夹下面所有文件的文件名
- ios6下使用CLGeocoder替换MKReverseGeocoder
- 使用PowerPoint2013组合形状以创建自定义形状