WordPress.org

Ready to get started?Download WordPress

Forums

[closed] Problems importing MYSQL Database (2 posts)

  1. uncblue
    Member
    Posted 6 years ago #

    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.

  2. Trent Adams
    Member
    Posted 6 years ago #

Topic Closed

This topic has been closed to new replies.

About this Topic