• I’m in the process of changing hosts. I exported my data from my existing host using phpMyAdmin, and now I’m trying to import at the new host (again with phpMyAdmin). I’m getting the following error.

    SQL-query:

    CREATE TABLE wp_comments(
    comment_ID bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
    comment_post_ID int( 11 ) DEFAULT '0' NOT NULL ,
    comment_author tinytext NOT NULL ,
    comment_author_email varchar( 100 ) NOT NULL ,
    comment_author_url varchar( 200 ) NOT NULL ,
    comment_author_IP varchar( 100 ) NOT NULL ,
    comment_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL ,
    comment_date_gmt datetime DEFAULT '0000-00-00 00:00:00' NOT NULL ,
    comment_content BLOB NOT NULL ,
    comment_karma int( 11 ) DEFAULT '0' NOT NULL ,
    comment_approved enum( '0', '1', 'spam' ) DEFAULT '1' NOT NULL ,
    comment_agent varchar( 255 ) NOT NULL ,
    comment_type varchar( 20 ) NOT NULL ,
    comment_parent int( 11 ) DEFAULT '0' NOT NULL ,
    user_id int( 11 ) DEFAULT '0' NOT NULL ,
    PRIMARY KEY ( comment_ID ) ,
    KEY comment_approved( comment_approved ) ,
    KEY comment_post_ID( comment_post_ID ) ,
    KEY spamk_fulltext( comment_content )
    )

    MySQL said: Documentation
    #1170 - BLOB column 'comment_content' used in key specification without a key length

    The MySQL version at the old host was 3.23.53. The version at the new host is 3.23.58. Any ideas in what I need to change in the dump/query to help this along? Thanks.

  • The topic ‘Error when trying import backed up DB’ is closed to new replies.