Moving database to new domain: “SQL syntax error”?
-
When trying to move my Blog (and with that, my database) I get the following error message:
MySQL returnerede: Dokumentation
#1064 – You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ‘ at line 28
My database code looks like this:
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’,
PRIMARY KEY (cat_ID) ,
KEYcategory_nicename(category_nicename)
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =16Any ideas? From previous postings I get that posting one table at a time i maybe a possibility, but when I do this, I get the same error message.
Ole
By the way: WordPress is great!
The topic ‘Moving database to new domain: “SQL syntax error”?’ is closed to new replies.