forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Malevolentia on July 05, 2006, 04:27:26 pm

Title: Moved gallery, problems with restoring .gz files!
Post by: Malevolentia on July 05, 2006, 04:27:26 pm
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!
Title: Re: Moved gallery, problems with restoring .gz files!
Post by: Sami on July 05, 2006, 04:43:02 pm
This is NOT coppermine issue!
it's a db backup/restore

what is the 2nd error (after removing Default charset=latin1)?