Move database, import problem
-
I’m trying to move my blog. Export seems OK. Unable to import to the new MySQL database. Here is the error :
CREATE TABLEwp_categories
(
cat_ID
bigint(20) NOT NULL auto_increment,
cat_name
varchar(55) collate latin1_general_ci NOT NULL default ”,
category_nicename
varchar(200) collate latin1_general_ci NOT NULL default ”,
category_description
longtext collate latin1_general_ci NOT NULL,
category_parent
int(4) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID
),
KEYcategory_nicename
(category_nicename
)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6MySQL a r??pondu:
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 latin1_general_ci NOT NULL default ”,
`category_nicCan someone help me?Thanks
- The topic ‘Move database, import problem’ is closed to new replies.