Moved gallery, problems with restoring .gz files! Moved gallery, problems with restoring .gz files!
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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