Topic: Upgrading & restoring step by step?? (Read 17022 times)

aanyah80 · « **on:** February 28, 2008, 08:29:51 am »

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 · « **Reply #1 on:** February 28, 2008, 08:35:11 am »

What version were you using of cpg ?

aanyah80 · « **Reply #2 on:** February 28, 2008, 08:58:33 am »

1.3.3

Joachim Müller · « **Reply #3 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.
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 · « **Reply #4 on:** March 02, 2008, 09:47:39 am »

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

aanyah80 · « **Reply #5 on:** March 02, 2008, 10:17:54 am »

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 · « **Reply #6 on:** March 02, 2008, 10:20:15 am »

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 · « **Reply #7 on:** March 02, 2008, 10:23:12 am »

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.

Joachim Müller · « **Reply #8 on:** March 02, 2008, 10:26:08 am »

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

aanyah80 · « **Reply #9 on:** March 02, 2008, 10:33:21 am »

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 · « **Reply #10 on:** March 02, 2008, 10:34:55 am »

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

François Keller · « **Reply #11 on:** March 02, 2008, 11:00:05 am »

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

aanyah80 · « **Reply #12 on:** March 02, 2008, 11:06:15 am »

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

Hein Traag · « **Reply #13 on:** March 02, 2008, 11:18:36 am »

Read the documentation.

To answer your question: the albums folder.

Joachim Müller · « **Reply #14 on:** March 02, 2008, 11:22:34 am »

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 · « **Reply #15 on:** March 02, 2008, 11:42:54 am »

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 · « **Reply #16 on:** March 03, 2008, 04:11:59 am »

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 · « **Reply #17 on:** March 03, 2008, 05:47:53 am »

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 · « **Reply #18 on:** March 03, 2008, 08:29:29 am »

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.

aanyah80 · « **Reply #19 on:** March 03, 2008, 11:09:17 am »

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/

News:

Author Topic: Upgrading & restoring step by step?? (Read 17022 times)