• I’m migrating from one hosting service (Dreamhost) to another (1and1 Internet). Every time I try to import my database using phpMyAdmin, I receive the following error. Anyone know what I need to fix in order to get the database properly imported? Thanks!

    ERROR:

    SQL query:

    CREATE TABLE wp_categories (
    cat_ID bigint( 20 ) NOT NULL AUTO_INCREMENT ,
    cat_name varchar( 55 ) NOT NULL default ”,
    category_nicename varchar( 200 ) NOT NULL default ”,
    category_description longtext NOT NULL ,
    category_parent bigint( 20 ) NOT NULL default ‘0’,
    category_count bigint( 20 ) NOT NULL default ‘0’,
    link_count bigint( 20 ) NOT NULL default ‘0’,
    posts_private tinyint( 1 ) NOT NULL default ‘0’,
    links_private tinyint( 1 ) NOT NULL default ‘0’,
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM AUTO_INCREMENT =24DEFAULT CHARSET = latin1 AUTO_INCREMENT =24

    MySQL said: Documentation
    #1064 – 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 ‘DEFAULT CHARSET=latin1 AUTO_INCREMENT=24’ at line 13

Viewing 3 replies - 1 through 3 (of 3 total)
  • What versions of MySQL are you coming from and going to? I know I’ve had issues with the default characterset in the past. I’m wondering if this is another case of it.

    I need help with this too. Some brave soul please solve this before I rip someones head off at 1and1.

    Been there. It’s a downgrading problem. Your new host has an older version of mysql, charset handling changed from V3, V4, and V5 and are not downgradable. While it is possible to fix the syntax after a lot of mysql RTFM and get it to load, it’s going to have broken characters and can’t really be undone if you do that. Trust me.Just don’t do it.

    Ask your new host to updgrade their mysql version or find a different host.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL import error’ is closed to new replies.