News:

CPG Release 1.6.31
Minor maintenance release
Clean up remaining remnants of the .net CPG website
Improved installer_stub compatibility with various server configurations

Main Menu

Moved gallery, problems with restoring .gz files!

Started by Malevolentia, July 05, 2006, 04:27:26 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Malevolentia

Hey,
I recently moved several coppermine galleries and my new host can't seem to be able to restore my .qz files (mysql databases) and he gets this error:

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 8

and if he deletes line 8 he just gets another error.
i even deleted line 8 and it came up with another error.. so I am thinking that the dump file is a diffrent version then what I am running
He has tried with different .gz files and none of them works, he's using phpMyAdmin - 2.8.2

Would appreciate help a lot!

Sami

This is NOT coppermine issue!
it's a db backup/restore

what is the 2nd error (after removing Default charset=latin1)?
‍I don't answer to PM with support question
Please post your issue to related board