Dicky,
Thank you for the quick response - but it appears tables created as unions do not support these repair commands:-
# bin/mysqlcheck -r -p test Collaborate
Enter password:
test.Collaborate
error : The handler for the table doesn't support check/repair
# mysql -uroot test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 43 to server version: 3.23.52-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> repair Collaborate;
ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1
mysql>
Any other ideas ? Would trying an older version of MySQL be useful ?
thx dave
Dicky Wahyu Purnomo wrote:
Pada Fri, 08 Nov 2002 01:59:20 +0000
David Herring <[EMAIL PROTECTED]> menulis:
What does "ERROR 1030: Got error 124 from table handler" mean when trying to select a single value from a table created as a UNIOn of another table ?root@slimmer:~# perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Table corrupt ... do mysql> repair table <tablename>;
or
shell# mysqlcheck -r -p <db> <table>
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php