WordPress.org

Ready to get started?Download WordPress

Forums

WP Migrate DB
[resolved] Error While importing DB for WP Migrate DB plugin (2 posts)

  1. FabioQ
    Member
    Posted 1 year ago #

    Hi all,
    I don't know why I'm getting this error, never gave me and migrated already some db on godaddy hosting service.
    By the way, the error is this:
    SQL query:

    #
    # Table structure of table wp_commentmeta
    #
    CREATE TABLE wp_commentmeta (

    meta_id BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
    comment_id BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0',
    meta_key VARCHAR( 255 ) DEFAULT NULL ,
    meta_value LONGTEXT,
    PRIMARY KEY ( meta_id ) ,
    KEY comment_id ( comment_id ) ,
    KEY meta_key ( meta_key )
    ) ENGINE = Aria DEFAULT CHARSET = utf8PAGE_CHECKSUM =1;

    MySQL said:

    #1286 - Unknown table engine 'Aria'
    How can I solve this to import successfully the db?
    Thanks all

    http://wordpress.org/extend/plugins/wp-migrate-db/

  2. Brad Touesnard
    Member
    Plugin Author

    Posted 1 year ago #

    Hi Fabio, looks like you're trying to migrate from MySQL server that supports the Aria storage engine to one that doesn't. You could try update all the "ENGINE = Aria" to "ENGINE = InnoDB" or "ENGINE = MyISAM".

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic