你先在MySQL-Front或Navicat for MySQL上执行 check table qsex; repair table qsex;然后再去访问表看是否好了
从你的client进入 C:\Documents and Settings\Administrator>mysql -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.1.36-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> 或者在client用 shell>myisamchk -r -q /path/*.MYI
repair table qsex;看看
check table qsex;
repair table qsex;然后再去访问表看是否好了
C:\Documents and Settings\Administrator>mysql -u root -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.36-community-log MySQL Community Server (GPL)Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
或者在client用
shell>myisamchk -r -q /path/*.MYI