Support » Fixing WordPress » Problems importing MYSQL Database

  • I am using Nefirms to host my site. I exported my MYSQL database from my site. I opened a new netfirms account and installed wordpress. I then tried to import my old database, that is a .sql file, into the one that was created when i installed wordpress. I get the same errors everytime:

    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 = 20DEFAULTCHARSET = latin1

    MySQL said:

    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 ‘———————————————————

    I have no idea why it is not importing….any suggestions? Please. Thanks.

  • The topic ‘Problems importing MYSQL Database’ is closed to new replies.