Hi all, I have a uge table data about 700mb pii 333 200mb ram. mysql 4.02. I try to add a full text index alter table listing add fulltext (about,title,description);
but it seems to do noit effect the ib files in the datadir seems to keep the same length no grow. when querying it say no full text index for that columns ERROR 1191: Can't find FULLTEXT index matching the column list the mysql client seems to consume when asking for idexin via a alter table listing add fulltext (about,title,description); query. so I kill him what can i do ? thanks. _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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
