WordPress.org

Support

Support » How-To and Troubleshooting » Move database, import problem

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

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Move database, import problem’ is closed to new replies.