B
blob
Guest
Eine meiner Tabellen des Forums öffnet nicht mehr, Reparatur mit #myisamchk -r war zwar erfolgreich, keine Fehlermeldung mit demselben mehr, aber mit mysql weiterhin Fehlermeldung und Reparatur erfolglos. Was tun ??
myisamchk: warning: 38 clients are using or haven't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check record links
MyISAM-table 'mnet_attachments_desc' is usable but should be fixed
root@werner:/var/lib/mysql/mysql#
root@werner:/var/lib/mysql/mysql# mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 6.0.0-alpha MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> REPAIR TABLE mnet_attachments_desc EXTENDED
-> ;
+-----------------------------+--------+----------+--------------------------------------------------- ---------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------------+--------+----------+--------------------------------------------------- ---------------------+
| mysql.mnet_attachments_desc | repair | error | Incorrect key file for table 'mnet_attachments_des c'; try to repair it |
+-----------------------------+--------+----------+--------------------------------------------------- ---------------------+
1 row in set, 1 warning (0.00 sec)
mysql> grrrr ..
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grrrr ..' at line 1
mysql> quit
Bye
root@werner:/var/lib/mysql/mysql
Last edited by a moderator: