Viewing 1 replies (of 1 total)
  • Thread Starter Per S?derlind

    (@pers)

    so, I ran ALTER TABLE wp_posts ENGINE=ClouSE; and got the following error:

    ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

    The reason is that some plugins have added full text indexes to wp_posts. To fix this, do the following (adapted from https://stackoverflow.com/a/1228723/1434155):

    SHOW CREATE TABLE wp_posts;

    It will show you all your fulltext indexes like this:

    …,
    FULLTEXT KEY key_name (column_list),
    …

    Drop all these keys:

    ALTER TABLE wp_posts DROP INDEX key_name;

    , then convert:

    ALTER TABLE wp_posts ENGINE= ClouSE;

    Before you do this, take a backup

Viewing 1 replies (of 1 total)
  • The topic ‘Tables not stored in the cloud storage’ is closed to new replies.