Hello,

I am moving my blog to another hoster. When I try to import the database dump through phpMyAdmin i permanently get this error:

CREATE TABLE pm_mailinglist(
id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
email varchar( 100 ) NOT NULL default ‘’,
weblog char( 3 ) NOT NULL default ‘no’,
defaultchar( 3 ) NOT NULL default ‘yes’,
PRIMARY KEY ( id )
) TYPE = MYISAM

MySQL meldet:

#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 ‘default char(3) NOT NULL default ‘yes’,
PRIMARY KEY (id)
)

As I am no SQL_expert, i am totally out of ideas? Anyone any advice?

Thanks a lot in advance for your help!
Mario