Sql error - moving from local to remote.

[reyn]

I get this error message from phpMyAdmin on my remote host when trying to import the locally exported phpMyAdmin file.
Anyone have any idea what to do now? please.

Code Select Expand

Error

SQL-query :

CREATE TABLE `cpg140_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
)ENGINE = MYISAM DEFAULT CHARSET = latin1

MySQL said:
#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 17

Frank

[Nibbler]

You made the export using a higher version of mysql than you are attempting to import into. Remove the bit it complains about and you'll be fine.

This is in no way a bug with Coppermine, so marking as invalid.