I moved hosts and tried to import my WP database into a freshly set up database on the host, but I got the following error:
CREATE TABLE wp_categories (
cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
cat_name varchar( 55 ) COLLATE utf8_unicode_ci NOT NULL default '',
category_nicename varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL default '',
category_description longtext COLLATE utf8_unicode_ci NOT NULL ,
category_parent int( 4 ) NOT NULL default '0',
PRIMARY KEY ( cat_ID ) ,
KEY category_nicename ( category_nicename )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =15;
#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 'collate utf8_unicode_ci NOT NULL default '',category_nicen
Does anyone know what to with this? I’m writing in German on my blog and have had trouble with importing databases before, due to issues with character encoding. Looks like it’s something along those lines again.
Oh, and one more thing: I searched the forum and found another thread dealing with MySQL Error #1064, but the solution offered there doesn’t seem to apply to my case, or at least I wouldn’t know how to and the topic was labelled as resolved. The FAQ doesn’t seem to say anything about posting or not posting in resolved threads. I did see however you can filter search results for resolved/unresolved, so this is merely to make sure I have not posted in the wrong location. Please don’t take this as spamming or bumping, I know how annoying this can be from other forums. Thanks 🙂
- The topic ‘MySQL Error #1064’ is closed to new replies.