Mysql error when trying to import backup

apps

#1

Hi everyone.

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:

SQL query:

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!


#2

Hi,

The column name ‘SHOW’ is confusing MySQL since it is a reserved word. If you edit the SQL to surround it with backticks, it will probably work.
ie., SHOW tinyint (4) NOT NULL default ‘1’,

Hope this helps…