WordPress.org

Ready to get started?Download WordPress

Forums

Move database, import problem (4 posts)

  1. MilleSabords
    Member
    Posted 8 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 8 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 8 years ago #

    I get exactly the same error

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

    collate latin1_general_ci

    Check that line is nowhere ?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags