Upgrading & restoring step by step??

[aanyah80]

hi guys,

here is my situation. I have a sql backup of my gallery & i copied all the folders from the userpics folder. this is the only files i've got from my old gallery.

now how exactly do i restore my gallery back online?? & can i do this directly on version 1.4?? i've searched & found no step by step guide to restore the gallery, some help would be muchly appreciated. I'm a newbie at all this.

[Hein Traag]

What version were you using of cpg ?

[aanyah80]

1.3.3

[Joachim Müller]

Restore the db on the new server, upload the cpg1.4.x core files to the new server (don't install yet), upload the content of the albums folder, then create the file include/config.inc.php on your server (take a look at the sample file to get an idea how it is supposed to look like). Then run the index page. If this works to some extent (i.e. if the mysql stuff works as expected), run update.php.
If this sounds too complicated for you, do this in two steps: get cpg1.3.x running on the new server, then perform the upgrade. Only backing up the minimum has not been wise, you should have made a full backup. Anyway, you can get the cpg1.3.x still - they are just hidden on the downloads page. Go to http://downloads.sourceforge.net/coppermine/cpg1.3.5.zip, but don't run it permanently, but only to get on your feet again. Then upgrade!

[aanyah80]

thanks, I'll try it out & post the result shortly

[aanyah80]

this is the error i keep getting

While executing query "SELECT * FROM cpg1410_config" on 0

mySQL error: Table 'aanyahgallery.cpg1410_config' doesn't exist

[Joachim Müller]

So what? How is cpg1.4.10 related? You obviously made a mistake. I can hardly help you without an explanation of what you actually did.

[aanyah80]

Restore the db on the new server, upload the cpg1.4.x core files to the new server (don't install yet), upload the content of the albums folder, then create the file include/config.inc.php on your server (take a look at the sample file to get an idea how it is supposed to look like). Then run the index page. If this works to some extent (i.e. if the mysql stuff works as expected), run update.php.

i got that error following the above instructions. just wanted to know what i did wrong.

[Joachim Müller]

How could the dump you restored have the table prefix cpg1410_ ?

[aanyah80]

ok looks like i have figured it out, my index page is now showing but no pics are showing. i can just see the names of the pics like a link but no pictures showing.

[aanyah80]

sorry, here is the link to my gallery http://preityzinta-fanclub.com/gallery1/

[François Keller]

are your pictures in the albums folder ?
check the permissions for your albums folder (chmod)

[aanyah80]

are the pictures meant to be in the "userpics" folder? or in the main "albums" folder

[Hein Traag]

Read the documentation.

To answer your question: the albums folder.

[Joachim Müller]

They need to reside in the same place they were on your old gallery. Coppermine stores the position of a pic you uploaded in the database as a relative path, seen from the albums folder.

[François Keller]

it depends how the pitures has been uploaded.
in case uploading by html they are stored in the userpics folder, by ftp uplad, in the albums folder (and there subdirectories)
[edit] hein and joachim where faster[/edit]

[aanyah80]

having no luck whatsoever, put the files in the "albums" folder or the userpics folder but still same result. i used to upload pics via html, never used ftp.

if i had a small gallery i would have just reuploaded them again but we are looking at over 9000 pics 

any other way to get around this?

[aanyah80]

i've just tried to upload a pic to my gallery via http & the image is not showing. the image is uploading but i dont see a thumbnail or pic. what could be causing this?

[Joachim Müller]

i used to upload pics via html, never used ftp.

You better get familiar with FTP then... How did you backup the pics on your old server if you have no idea how FTP works? How did you install coppermine on the new server. If you don't have a backup (taken with your FTP app) of the folder structure of your old server, you're stuck. You simply have failed to make a valid backup then. You should have read the docs or asked how to move a gallery from one server to the other before the old server went down. As far as I can tell, you're stuck if you don't have a valid backup.

[aanyah80]

i think my earlier reply wasnt worded correctly, I do know how to use FTP. what i meant was when i had my gallery running i always used to upload pics via http, never tried batch adding via ftp. either way i am very familiar with ftp.

i do have a valid backup, the only mistake i made was not copying all my folders/files from my old gallery. I only downloaded the backup sql file & the userpics folder.

i've just got to figure out why my pics are not showing http://preityzinta-fanclub.com/gallery7/