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.
