MySQL Syntax Error while restoring Database.
-
Hi.
I moved my WordPress blog to a new server. I followed the instructions for importing the database, but I get this error from PhpMyadmin:Error
SQL query:
CREATE TABLE
wp_categories
(
cat_ID
bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name
varchar( 55 ) NOT NULL default ”,
category_nicename
varchar( 200 ) NOT NULL default ”,
category_description
longtext NOT NULL ,
category_parent
bigint( 20 ) NOT NULL default ‘0’,
category_count
bigint( 20 ) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID
) ,
KEYcategory_nicename
(category_nicename
)
) ENGINE = MYISAM AUTO_INCREMENT =7DEFAULT CHARSET = latin1 AUTO_INCREMENT =7;MySQL said: Documentation
#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 ‘DEFAULT CHARSET=latin1 AUTO_INCREMENT=7’ at line 10What do I do? Help please, MySQL guru’s.
- The topic ‘MySQL Syntax Error while restoring Database.’ is closed to new replies.