Support » Installing WordPress » importing database into new server mysql ERROR

  • Resolved ore


    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 )

    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)
  • 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.. =) 😉


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