Hi Try
create table tmp_zinutes select * from zinutes; alter table tmp_zinutes add primary key (id), key hid(hid)); if tmp_zinutes has all rows, then drop table zinutes; rename table tmp_zinutes to zinutes; Be carefull, DO NOT DROP TABLE zinutes unless all data has successfully copied to tmp_zinutes. I hope this helps Simon On Friday 20 Sep 2002 9:34 am, tl 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) > > mysql> check table zinutes; > +--------------+-------+----------+---------------------------------------- >----------------+ > > | Table | Op | Msg_type | Msg_text > | | > > +--------------+-------+----------+---------------------------------------- >----------------+ > > | alio.zinutes | check | error | The handler for the table doesn't > | support check/repair | > > +--------------+-------+----------+---------------------------------------- >----------------+ 1 row in set (0.01 sec) > > Thanks very much. > > > > > --------------------------------------------------------------------- > 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
