SQL Help

[trev]

When uploading a backup of an SQL database i get the following error!

SQL query:

CREATE TABLE `bookings` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`ph` varchar( 100 ) NOT NULL default '',
`al1` varchar( 100 ) NOT NULL default '',
`al2` varchar( 100 ) NOT NULL default '',
`town` varchar( 100 ) NOT NULL default '',
`county` varchar( 100 ) NOT NULL default '',
`pc` varchar( 100 ) NOT NULL default '',
`hn` varchar( 100 ) NOT NULL default '',
`mn` varchar( 100 ) NOT NULL default '',
`hal1` varchar( 100 ) NOT NULL default '',
`hal2` varchar( 100 ) NOT NULL default '',
`htown` varchar( 100 ) NOT NULL default '',
`hcounty` varchar( 100 ) NOT NULL default '',
`hpc` varchar( 100 ) NOT NULL default '',
`event` varchar( 100 ) NOT NULL default '',
`rdate` varchar( 100 ) NOT NULL default '',
`jt` varchar( 100 ) NOT NULL default '',
`hs` varchar( 100 ) NOT NULL default '',
`bf` varchar( 100 ) NOT NULL default '',
`email` varchar( 100 ) NOT NULL default '',
`comment` varchar( 100 ) NOT NULL default '',
`company` varchar( 100 ) NOT NULL default '',
`ip` varchar( 100 ) NOT NULL default '',
`date` varchar( 100 ) NOT NULL default '',
`eta` varchar( 100 ) NOT NULL default '',
`hf` varchar( 100 ) NOT NULL default '',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1

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 'DEFAULT CHARSET=latin1' at line 29

Can anyone help?

Thanks Trev

[Robert]

Remove ENGINE = MYISAM DEFAULT CHARSET=latin1

Is this from Mambo?

[Canuckkev]

What version of MySQL are you uploading to? Might be an old version, and the CHARSET specification is not needed.

[trev]

Ill check the vertions and its from ipb.