DUMP problem 1

[skiflyer]

I used mysqldump to create a dump of my DB, and am trying to load this into another server.

The original server is 4.0.12-max-nt (production)
and the new one is 4.0.16-max-debug (testing)

The script is erroring out with the following message...

ERROR 1064 at line 1428: 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(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (

which refers to

DROP TABLE IF EXISTS links;
CREATE TABLE links (
  link_id int(10) unsigned NOT NULL auto_increment,
  description text NOT NULL,
  link text NOT NULL,
  page varchar(100) NOT NULL default '',
  show tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (link_id)
) TYPE=MyISAM;

And for the life of me I don't see anything wrong with the SQL code there. I tried removing the single quotes around the 1 just in case, but no luck.

 

[TonyGroves]

SHOW is a reserved word.