Move coppermine galery to another host - help in MySQL

[phl]

Hello everybody,

I've just finished to upload every files which were on my previous host to my new one.
I also changed my mysql data in include/config.inc.php
And finally I saved my DB

Now I'm trying to upload my DB to my new host and I got trouble :

The begining of my DB is :

Code Select Expand

CREATE TABLE `cpg132_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) COLLATE latin1_german1_ci NOT NULL default '',
`description` text COLLATE latin1_german1_ci NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',

The result of the upload is :

Code Select Expand

MySQL answered:
#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 'collate latin1_german1_ci NOT NULL default '',
  `description`

I found that the phpmyadmin version are different :
the previous host is : 2.6.4-pl3
the new one : 2.5.7-pl1

Could you please help me to end the migration of my coppermine photo galery.
thanks a lot

[Nibbler]

When you dump the db on your old host, make sure to tick the compatibility option for mysql4. Your new server is an older version of Mysql than your old one.

[phl]

thanks it works now

but I got an INTERNAL SERVER ERROR when I try to access index.php :/

Must I keep every CHMOD of every files ?

[Nibbler]

Server setups differ. You may need different permissions on your new host. Please keep to 1 issue per thread.