MYSQL:Got error 175 from storage engine 数据库提示错误,需要修复
今天老板说新注册的用户怎么都没有了啊.我也感到有问题了.不可能这几天一个都没有啊.以前一天都几百;
我赶紧查,原来.是:MYSQL: Got error 134 from storage engine .一开始就慌了!拿着myisamchk -r member去修复!以前修过一次成功了!本以为这次很简单,没想到不成功!换myisamchk -o member 还不行.换myisamchk -q member也不行.晕.搞了一大堆错误又;开始有点急了.毕竟数据库坏了.那都没法办啊!丢失数据如丢钱啊!
没办法,还是慢慢找,在网站又找了个: repair table tablename; 我突然想起来上次用的是这个,我就试了一下.成功了!终于放下一口气.MYSQL学了这么久了水平还是!在这里和大家分享:
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> REPAIR TABLE member;
ERROR 1046 (3D000): No database selected
mysql> use flea
Database changed
mysql> REPAIR TABLE member;
+-------------+--------+----------+--------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-------------+--------+----------+--------------------------------------------+
| flea.member | repair | warning | Number of rows changed from 89588 to 89587 |
| flea.member | repair | status | OK |
+-------------+--------+----------+--------------------------------------------+
2 rows in set (1.95 sec)
mysql>
欢迎大家评论.不知道这个方法有什么好和坏?反正是解决问题了!
上一篇:mysql免安装版安装简要
下一篇:忘记MYSQL的ROOT密码,可以强制修改ROOT方法
讨论数量:0