发布时间：2013-10-21
点击量：2791
一般由于数据库受损导致，可以手动修复数据库
1) 进入cmd界面，进入mysql的bin目录,例如：
cd C:\Program Files\MySQL\MySQL Server 5.1\bin
2) 执行命令 mysqlcheck -h 127.0.0.1 -uroot -padmin -P 3307 --databases emp >>a.txt
3) 查看a.txt文本，找出损坏的表，例如，显示ok的就是正常的，显示error的为损坏的表，请记录下error的表名.
emp.t_batch_job_execution OK
emp.t_batch_job_execution_seq
warning : Table is marked as crashed
warning : 12 clients are using or haven't closed the table properly
error : Checksum for key: 1 doesn't match checksum for records
error : Checksum for key: 2 doesn't match checksum for records
error : Corrupt
4) 登录mysql，修复损坏的表，将所有故障的表修复后就可以正常启动了。
mysql -u root -padmin -P3307;(回车)
use emp;(回车)
repair table 表名;(回车)
例如:
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -uroot -padmin -P 3307
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 58
Server version: 5.1.30-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use emp
Database changed
mysql> repair table emp.t_batch_job_execution_seq; --注意加分号
+-------------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------------+--------+----------+----------+
| emp.t_batch_job_execution_seq | repair | status | OK |
+-------------------------------+--------+----------+----------+
1 row in set (0.03 sec)
