WordPress.org

Support

Support » Installation » [Resolved] importing database into new server mysql ERROR

[Resolved] importing database into new server mysql ERROR

  • im finally moving my blog from localhost to a more prominent location—online. When attempting to import the database, this problem occured:

    “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=5’ at line 10 “

    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’,
    PRIMARY KEY ( cat_ID ) ,
    KEY category_nicename ( category_nicename )
    ) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =5

    so what should i do? p.s. this might help, to be sure that the file isnt corrupted, i uploaded it to my localhost database and it worked perfectly.

Viewing 2 replies - 1 through 2 (of 2 total)
  • brokenshardz
    Member

    @brokenshardz

    i am also getting the same error. msql version for both sites are the same, 4.1.21-standard.

    I noticed you marked this [Resolved], but, can you let everyone else know what you did to “Resolve” it? This might help others that are having the same problem as you had.. =) 😉

    spencerp

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] importing database into new server mysql ERROR’ is closed to new replies.