Help PLS!!

[koala8832]

I just sign up a new server and try to run my backup mysql data file from old server to this new server. This is the error i got from the new server.

Error

SQL-query :

CREATE TABLE classifieds_listings(

listing_id int( 11 ) NOT NULL default '0',
category_id varchar( 32 ) NOT NULL default '00',
first_name varchar( 128 ) default NULL ,
last_name varchar( 128 ) default NULL ,
company varchar( 128 ) default NULL ,
email varchar( 128 ) default NULL ,
show_email tinyint( 4 ) default '1',
alt_contact text,
title varchar( 128 ) NOT NULL default 'New Listing',
body text,
location varchar( 64 ) default NULL ,
price double( 16, 4 ) default NULL ,
PASSWORD varchar( 64 ) default NULL ,
post_date datetime default NULL ,
exp_date datetime NOT NULL default '2000-01-01 00:00:00',
renewed int( 11 ) default '0',
exp_notice_sent tinyint( 1 ) default '0',
exp_notice_date datetime default NULL ,
STATUS tinyint( 4 ) default '0',
CHECK varchar( 32 ) default NULL ,
PRIMARY KEY ( listing_id ) ,
KEY classifieds_listings_index( listing_id, exp_date, category_id )
) TYPE = MYISAM

MySQL 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 'varchar(32) default NULL,
PRIMARY KEY (listing_id),
KEY

I have attached the backup data file here , please help me to look what is wrong with it! thanks.

[csn]

This is the problem:

CHECK varchar( 32 ) default NULL

'CHECK' is a reserved word . You'll have to use a different field name, or you can escape it with backticks, i.e.:

CHECK varchar( 32 ) default NULL