At 9/20/2002, you wrote: >Please help me REPAIR TABLE: >___________________________________________________________ >| | > CREATE TABLE `zinutes` ( > `hid` int(10) unsigned NOT NULL default '0', > `tipas` int(10) unsigned NOT NULL default '0', > `msg` text NOT NULL, > `autorius` varchar(60) NOT NULL default '', > `email` varchar(60) NOT NULL default '', > `data` datetime NOT NULL default '0000-00-00 00:00:00', > `host` varchar(60) NOT NULL default '', > `id` int(10) unsigned NOT NULL auto_increment, > PRIMARY KEY (`id`), > KEY `hid` (`hid`) >) TYPE=ISAM PACK_KEYS=1 >|___________________________________________________________| > >mysql> repair table zinutes; >+--------------+--------+----------+--------------------------------------------------------+ >| Table | Op | Msg_type | >Msg_text | >+--------------+--------+----------+--------------------------------------------------------+ >| alio.zinutes | repair | error | The handler for the table doesn't >support check/repair | >+--------------+--------+----------+--------------------------------------------------------+ >1 row in set (0.00 sec)
REPAIR TABLE supports MyISAM only: http://www.mysql.com/doc/en/REPAIR_TABLE.html ------------------------- Pekka Saarinen http://photography-on-the.net ------------------------- --------------------------------------------------------------------- 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