How to fix The used table type doesn’t support FULLTEXT indexes without loosing data?

Today I try to convert my wordpress blog MySQL database table (only wordpress system table) engines from MyISAM to InnoDB. I can convert all the wordpress system tables, except _posts table. When I run this command,

ALTER TABLE table_prefix_here_posts ENGINE=InnoDB;

Read More

I get following error.

#1214 – The used table type doesn’t support FULLTEXT indexes

I search on Google and found that I can fix it by doping the table. But in my situation, as far as I know, if I drop the _posts table, I lose all my blog posts. Therefore are there anyway to convert my _posts table to InnoDB without loosing my posts (data)?

Related posts

Leave a Reply

1 comment