Tables not stored in the cloud storage (2 posts)

  1. Per Søderlind
    Posted 3 years ago #

    Thank you for the latest release with the warning feature.

    Do you know why a table isn't added to ClouSE ? At my site it was wp_posts`

    I understand that all I have to do to add it to the cloud is running:
    ALTER TABLE wp_posts ENGINE=ClouSE;


  2. Per Søderlind
    Posted 3 years ago #

    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 http://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

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP2Cloud
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.