Geek asks and answers

How to fix The used table type does not support FULLTEXT indexes without data loss?

Today I am trying to convert my MySQL WordPress database table (only in wordpress system table) from MyISAMto InnoDB. I can convert all wordpress system tables except the table _posts. When I ran this command,

ALTER TABLE table_prefix_here_posts ENGINE = InnoDB;

I get the following error.

# 1214 - The table type used does not support FULLTEXT indexes

I search on Google and find that I can fix this, dope table. But in my situation, as far as I know, if I drop the _posts table, I will lose all my blog posts. Therefore, anyway, to convert my _posts table to InnoDB without losing my messages (data)?

+3
source share
1 answer

FULLTEXT indexes are only supported in InnoDB tables since MYSQL 5.6, so try updating MYSQL and then change the table engine

+3
source

More articles:


All Articles