WordPress.org

1. MilleSabords
   Member
   Posted 7 years ago #
   

   I'm trying to move my blog. Export seems OK. Unable to import to the new MySQL database. Here is the error :
   CREATE TABLE wp_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),
   KEY category_nicename (category_nicename)
   ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=6

   MySQL 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_nic

   Can someone help me?Thanks

2. Mark (podz)
   Support Maven
   Posted 7 years ago #
   

   DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci

   Do a search/replace on the whole sql file and replace the above with nothing. Just delete that line and all will be good.

3. MilleSabords
   Member
   Posted 7 years ago #
   

   I get exactly the same error

4. Mark (podz)
   Support Maven
   Posted 7 years ago #
   

   collate latin1_general_ci

   Check that line is nowhere ?

Topic Closed

This topic has been closed to new replies.