Receiving MySQL error #1064 when importing database
-
I have been running a WordPress blog locally for a few days, using XAMPP. I decided to upload it yesterday, but ran into some problems when importing the database in phpMyAdmin. I receive the following error:
CREATE TABLE IF NOT EXISTSwp_comments` (
comment_IDbigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
comment_post_IDbigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,
comment_authortinytext NOT NULL ,
comment_author_emailvarchar( 100 ) NOT NULL DEFAULT ”,
comment_author_urlvarchar( 200 ) NOT NULL DEFAULT ”,
comment_author_IPvarchar( 100 ) NOT NULL DEFAULT ”,
comment_datedatetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
comment_date_gmtdatetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
comment_contenttext NOT NULL ,
comment_karmaint( 11 ) NOT NULL DEFAULT ‘0’,
comment_approvedvarchar( 20 ) NOT NULL DEFAULT ‘1’,
comment_agentvarchar( 255 ) NOT NULL DEFAULT ”,
comment_typevarchar( 20 ) NOT NULL DEFAULT ”,
comment_parentbigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,
user_idbigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (comment_ID) ,
KEYcomment_approved(comment_approved) ,
KEYcomment_post_ID(comment_post_ID) ,
KEYcomment_approved_date_gmt(comment_approved,comment_date_gmt) ,
KEYcomment_date_gmt(comment_date_gmt)
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =11;MySQL sa: Dokumentation
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘——————————————————–—
— Struktur för ta’ at line 1I’m pretty sure that I am messing up something fundamental; I just can’t figure out what.
The topic ‘Receiving MySQL error #1064 when importing database’ is closed to new replies.