I've recently installed the FSRS script on my domain freezens.com. This was previously on another host which ran cpanel. Before moving over to DH I took a mysql database backup.
I've tried importing the backup on the DH servers but am getting this error:
CREATE TABLE offers(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
name text NOT NULL ,
image text NOT NULL ,
url text NOT NULL ,
description text NOT NULL ,
SHOW tinyint( 4 ) NOT NULL default '1',
PRIMARY KEY ( id )
) TYPE = MYISAM ;
MySQL said: Documentation
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 'show tinyint(4) NOT NULL default '1',
PRIMARY KEY (id)
) TYPE=MyISAM' at line 7
I don't have much experience with mysql stuff, so am a bit confused. Am I doing something wrong? Any help would be greatly appreciated!