How to get MYSQL to support FULLTEXT indexes
Posted by:
intosoul
(---.vc.shawcable.net)
Date: November 04, 2006 08:08PM
I am using
Wamp5 - 1.6.5v
phpMyAdmin - 2.8.2.4v
MySQL - 5.0.24a-community-nt
I am having trouble with getting MYSQL to support FULLTEXT indexes.
I've tried adding the code: "TYPE=MyISAM" but no dice.
HERE is what I did:
ALTER TABLE `wp_posts` ADD FULLTEXT `post_related` (
`post_name` ,
`post_content`
) TYPE=MyISAM
So then I tried editing the my.ini file by changing
from
default-storage-engine=InnoDB
to
default-storage-engine=MyISAM
And then I restart MYSQL engine. Did not work.
I am lost. Any help would be appreciated.