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 TABLEwp_categories(
cat_IDbigint( 20 ) NOT NULL auto_increment,
cat_namevarchar( 55 ) NOT NULL default ”,
category_nicenamevarchar( 200 ) NOT NULL default ”,
category_descriptionlongtext NOT NULL ,
category_parentbigint( 20 ) NOT NULL default ‘0’,
category_countbigint( 20 ) NOT NULL default ‘0’,
link_countbigint( 20 ) NOT NULL default ‘0’,
posts_privatetinyint( 1 ) NOT NULL default ‘0’,
links_privatetinyint( 1 ) NOT NULL default ‘0’,
PRIMARY KEY (cat_ID) ,
KEYcategory_nicename(category_nicename)
)ENGINE = MYISAM AUTO_INCREMENT = 20DEFAULTCHARSET = latin1MySQL 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.