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.
What version were you using of cpg ?
1.3.3
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!
thanks, I'll try it out & post the result shortly
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
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.
Quote from: Joachim Müller on February 28, 2008, 09:04:48 AM
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.
How could the dump you restored have the table prefix cpg1410_ ?
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.
sorry, here is the link to my gallery http://preityzinta-fanclub.com/gallery1/
are your pictures in the albums folder ?
check the permissions for your albums folder (chmod)
are the pictures meant to be in the "userpics" folder? or in the main "albums" folder
Read the documentation.
To answer your question: the albums folder.
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.
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]
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?
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?
Quote from: aanyah80 on March 03, 2008, 04:11:59 AM
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.
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/
I picked one at random. It didn't work because you didn't upload the 10002/ directory in userpics.
i've added the 10002 folder to the userpics folder, hasn't made a difference. btw how did you figure out that album 10002 was missing?
You didn't upload all the files. Take a look yourself
http://preityzinta-fanclub.com/gallery7/albums/userpics/10002/
There's only a few files there.
those are the only pics i've got in folder 10002 ??? so if the pics are not complete in this folder, the rest of the pics aren't going to show??
That should be fine - if you used http uploads, all your stuff will reside in the userpics folder. Just retore it on the new server in the same location it used to reside on the old server.