Server move: Error in SQL syntax when restoring database

[isajade]

Hi everyone,

Can you please help me, I followed the FAQ to move to another server and got an error in SQL syntax when I restored the database.

#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 36
The full line 36 is:

Code Select Expand

) ENGINE = MYISAM AUTO_INCREMENT =633 DEFAULT CHARSET = latin1


More infos:

• I don't have any mod nor hack installed.
  
• SQL file size 257 Ko.
  
• Coppermine version 1.4.10 (I started the move process before the new version was released and I'd prefer, if possible, to upgrade as soon as the move is successful, rather than starting something new before the first one is done.)
• Former server at Lycos.fr http://gallery.angel-us.com
  Version PHP:  4.3.9
• New server at 1and1.fr http://gallery.juliebenz.net
  Version PHP: MySQL4.0
• I CHMOD the folder to 755 (as I don't know what means "depending on your server config") and moved to next step. Got the same error when I CHMOD to 777
• Themes: DFire (modified version (I) posted on this board) and Foliage

Please let me know if you need more informations and thank you for taking the time to help me.

[Nibbler]

The new server is running an older version of MySQL than your old server but you failed to use the compatibility options when exporting the database. Either export again with MySQL 4.0 compatibility or edit the sql file, removing references to 'DEFAULT CHARSET = latin1'

[isajade]

Thank you, I removed the 'DEFAULT CHARSET = latin1' and it worked.

I run the gallery at http://gallery.juliebenz.net and got:
MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[Nibbler]

You'll need to talk to your host, that is not a Coppermine issue.

[isajade]

Thank you again, I just did it.

[isajade]

I just solved the last issue, here it is, it might help other users.

You need to update your include/config.inc.php file with the new database name, password etc.

Thanks again guys