I've tried the plugin available for 1.5, as well as phpMyAdmin to get this working, and I get the same error everytime. I follow the instructions on the wiki, and do the dump from my old database to move it to the new database (I'm switching hosts very soon), and the new host won't take the database information from the SQL statement of the old dbase.
I get this in response:
the comment lines for ID
id int( 11 ) NOT NULL AUTO_INCREMENT ,
regex varchar( 200 ) NOT NULL default '',
regex_type enum( 'ip', 'url', 'rbl', 'option', 'auto-url', 'auto-ip', 'regex-url', 'regex-ip' ) NOT NULL default 'url',
PRIMARY KEY (
id ) ,
id ) ,
) TYPE = MYISAM AUTO_INCREMENT =3279
#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 'id
int(11) NOT NULL auto_increment,regex` varchar(200) NOT
I don't fully understand what's going on here, as I am *not* a mySQL guru by any stretch of the imagination. The new host is using 4.0.23, and the old host is using 4.0.18. I can't imagine there would be a serious syntax change from one version to the other.
Does anyone know if there's something specific I'm doing wrong here? I would really appreciate the help, since I'd like to get moved to the new host ASAP in order to get rolling and stop getting billed for my old hosting.