Pada Fri, 08 Nov 2002 02:29:49 +0000 David Herring <[EMAIL PROTECTED]> menulis:
> > > 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> on syntax, your forgot to add ... table ... should be like this : mysql> repair table Collaborate; but it's only working if you're using MyISAM table type. -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com --------------------------------------------------------------------- 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