At 9/9/2002, you wrote: >Dear all, >I have installed mysql 4.0.2 alpha log (actually compiled by me) in a >linux box (Mandrake 8.2) and for 2 months was working perfectly. After >migrating some data from an other installation (Windows 2000 / mysql 4.0.1 >alpha log) my FULL-TEXT indexes stop functioning. I am issuing the >following statement but no FULL-TEXT index is created. >DROP TABLE IF EXISTS e_genlogmatergroup; >CREATE TABLE `e_genlogmatergroup` ( > `genlogmatergroupid` decimal(10,0) NOT NULL default '0', > `genlogmatergrouptitle` text, > `genlogmatergroupcont` text, > `genlogmatergroupparent` decimal(10,0) default '0', > `chapter` varchar(255) default NULL, > `genlogmatergroup` varchar(255) default NULL, > `genlogmaterdateins` date default NULL, > `infopg` tinyint(3) unsigned default '0', > PRIMARY KEY (`genlogmatergroupid`), > FULLTEXT KEY `genlogmatergrouptitle` (`genlogmatergrouptitle`), > FULLTEXT KEY `genlogmatergroupcont` (`genlogmatergroupcont`), > FULLTEXT KEY `compound_e_genlogmatergroup` > (`genlogmatergroupcont`,`genlogmatergrouptitle`) >) TYPE=MyISAM; > >Any Ideas?????? >Thanks in advance
Try OPTIMIZE TABLE `e_genlogmatergroup` This should get indexes running (you need to have a couple of rows of data there first). ------------------------- 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