Error when trying import backed up DB
-
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 lengthThe 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.