Jump to content

Innodb to Myisam - full text search index

Recommended Posts

If you have a database that was installed as innodb or was perhaps converted to innodb, it won't have the full text index on the tables after converting it back to Myisam. 


After converting, run the following queries to add back the stock full text indexs

ALTER TABLE posts ADD FULLTEXT KEY post (post);ALTER TABLE topics ADD FULLTEXT KEY title (title);ALTER TABLE forums_archive_posts ADD FULLTEXT KEY archive_content (archive_content);ALTER TABLE message_posts ADD FULLTEXT KEY msg_post (msg_post);ALTER TABLE message_topics ADD FULLTEXT KEY mt_title (mt_title);ALTER TABLE blog_entries ADD FULLTEXT KEY entry_name (entry_name);ALTER TABLE cal_events ADD FULLTEXT (event_content);ALTER TABLE cal_events ADD FULLTEXT (event_title);ALTER TABLE downloads_files ADD FULLTEXT(file_desc);ALTER TABLE downloads_files ADD FULLTEXT(file_name);ALTER TABLE nexus_packages ADD FULLTEXT KEY p_name (p_name);ALTER TABLE nexus_packages ADD FULLTEXT KEY p_desc (p_desc);ALTER TABLE nexus_support_requests ADD FULLTEXT KEY r_title (r_title);ALTER TABLE nexus_support_replies ADD FULLTEXT KEY reply_post (reply_post);
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...