• Hi.
    I moved my WordPress blog to a new server. I followed the instructions for importing the database, but I get this error from PhpMyadmin:

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

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

    What do I do? Help please, MySQL guru’s.

  • The topic ‘MySQL Syntax Error while restoring Database.’ is closed to new replies.