MySQL import error
-
I’m migrating from one hosting service (Dreamhost) to another (1and1 Internet). Every time I try to import my database using phpMyAdmin, I receive the following error. Anyone know what I need to fix in order to get the database properly imported? Thanks!
ERROR:
SQL query:
CREATE TABLE
wp_categories(
cat_IDbigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_namevarchar( 55 ) NOT NULL default ”,
category_nicenamevarchar( 200 ) NOT NULL default ”,
category_descriptionlongtext NOT NULL ,
category_parentbigint( 20 ) NOT NULL default ‘0’,
category_countbigint( 20 ) NOT NULL default ‘0’,
link_countbigint( 20 ) NOT NULL default ‘0’,
posts_privatetinyint( 1 ) NOT NULL default ‘0’,
links_privatetinyint( 1 ) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID) ,
KEYcategory_nicename(category_nicename)
) ENGINE = MYISAM AUTO_INCREMENT =24DEFAULT CHARSET = latin1 AUTO_INCREMENT =24MySQL 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=24’ at line 13
The topic ‘MySQL import error’ is closed to new replies.