OT SQL

I am trying to set up my MySQL Database on an older version than it is
currently setup on...

Current MySQL Version = 4.1.11-standard
the older version I am trying to set up on = 4.0.24_Debian-10-log

I dumped my SQL and it is...

CREATE TABLE `tbl_address` (
`ADD_ID` bigint(20) NOT NULL auto_increment,
`ADD_ProfileID` bigint(20) NOT NULL default '0',
`ADD_Line1` varchar(150) NOT NULL default '',
`ADD_Line2` varchar(150) NOT NULL default '',
`ADD_Town` varchar(50) NOT NULL default '',
`ADD_AreaID` bigint(6) NOT NULL default '0',
`ADD_Postcode` varchar(15) NOT NULL default '',
`ADD_CountryID` bigint(6) NOT NULL default '0',
`ADD_Default` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ADD_ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;


I removed the line ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;

to leave....

CREATE TABLE `tbl_address` (
`ADD_ID` bigint(20) NOT NULL auto_increment,
`ADD_ProfileID` bigint(20) NOT NULL default '0',
`ADD_Line1` varchar(150) NOT NULL default '',
`ADD_Line2` varchar(150) NOT NULL default '',
`ADD_Town` varchar(50) NOT NULL default '',
`ADD_AreaID` bigint(6) NOT NULL default '0',
`ADD_Postcode` varchar(15) NOT NULL default '',
`ADD_CountryID` bigint(6) NOT NULL default '0',
`ADD_Default` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ADD_ID`)
)

but when i try and run this sql in PHPMyAdmin I get the error message
#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
'CREATE TABLE `tbl_album` (
`A_ID` bigint(20) NOT NULL auto_in....I have looked at the page
http://dev.mysql.com/doc/mysql/en/create-table.html but all seems ok,
although it is obviously not.Any hints or tips or answers would be well
received.ThnksAW


.

Relevant Pages