What is the handler for Collaborate ?? (What does "show create table Collaborate" display ?) ----- Original Message ----- From: "David Herring" <[EMAIL PROTECTED]> To: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 2:29 AM Subject: Re: ERROR 1030: Got error 124 from table handler
> > > 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 > > > > --------------------------------------------------------------------- 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