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_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
) ,
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.