I am attempting to move a site from a different host to DH and am unable to import my database dump.
I get the following error:
– Table structure for table
pn_cid INT( 10 ) NOT NULL AUTO_INCREMENT ,
pn_name VARCHAR( 32 ) NOT NULL DEFAULT ‘’,
pn_description VARCHAR( 254 ) NOT NULL DEFAULT ‘’,
PRIMARY KEY (
) TYPE = MYISAM ;
#1064 - 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 ‘pn_cid
int(10) NOT NULL auto_increment,pn_name` varchar(32) NOT NULL defaul’ at line 1
I assume it has something to do with a mismatch between the phpMyAdmin settings at the two sites or the MySQL versions.
Any suggestions where I start looking?