WordPress.org

Ready to get started?Download WordPress

Forums

WP2Cloud
Tables not stored in the cloud storage (2 posts)

  1. Per Soderlind
    Member
    Posted 1 year 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;

    http://wordpress.org/extend/plugins/wp2cloud-wordpress-to-cloud/

  2. Per Soderlind
    Member
    Posted 1 year 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

About this Topic

Tags

No tags yet.