Moving to new server

[heistness]

I have moved to a new server and I need to move my gallery.  How can i move the gallery without losing my users and the thousands of images i have?  Please assist.  The new server uses fantastico and cpanel just like my old one.  please help.  heistness@gmail.com

[OmegaGOD]

On your old web-host, using cPanel, go to "Backup" and download a backup of your CPG database. Then on your new web-host, go to the "Backup" section and using the restore function, upload and restore the CPG database. Next, you just need to use an FTP program to copy all your CPG files from your old web-host to your new web-host. Remember to CHMOD the proper directories on your new web-host.

Instead of downloading and reuploading every file, you may want to ask your old web-host to tar and gzip your coppermine gallery files. This way you would only have to download one large file instead of 100s of little files. ;-)

[Joachim Müller]

after doing as OmegaGOD suggested, remember to go to coppermine's config and change "target address for ecards" in case your URL has changed.

Joachim

[dave650]

Hi, I have the same situation right now and i tried what you guys suggested but it doesn't work for me. I created a backup of the sql file from the old server (copp1), then went to the new server and installed coppermine through the cpanel, then restored copp1. Then in dreamweaver i copied the entire gallery directory from the old site and pasted on top of the new gallery directory i had just created.  the following is the error message i get when browsing to that page :
Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user: 'glickr2_copp1@localhost' (Using password: YES)

Note: glickr2 was my user name for old server.

Thanks,
Dave

[Tranz]

You need to update include/config.inc.php with the new database connection settings.

[Yukino]

hi... i'm almost in the same boat....

alright cool deal. so here's the thing. my LAST server ran using localhost and i used that in the dbhostname in the config. my new server is powweb. when i logged into my phpmyadmin on the old server it said:

MySQL 3.23.37-log running on localhost as web72@localhost

at the top. keyword on the localhost.

when i log into the aex3 (where my cpg data is kept) database using phpmyadmin on my new server it says:

MySQL 4.1.9-log running on mysql08.powweb.com

at the top. keyword mysql03.powweb.com

so now on the new server i can create users that can have access to each individual database. i only have one right now and that is me, the admin

so my cpg is in the db aex3. on my config i'm using aex3 as the dbname and my username for the dbusername and my own password for the dbpassword.

so then for the dbhost for the the new server should i be using: mysql03.powweb.com ??

[Tranz]

You would need to ask your webhost.

[dave650]

You need to update include/config.inc.php with the new database connection settings.

Ok, a little progress but still geting the same error, only now its using the correct user name. Could it be a problem with the password?

[Tranz]

You need to update include/config.inc.php with the new database connection settings.

Ok, a little progress but still geting the same error, only now its using the correct user name. Could it be a problem with the password?

Did you set up proper permissions for the user to access the database? I don't know how your webhost works, but when we add users, we need to add the user to the database in order to grant the user access to the database. Again, your interface could be different. You should check with your webhost on what you need to do.

[dave650]

I'm sorry but i'm not that familiar with all this stuff yet. I don't know how to set up proper access in the database.

[Tranz]

I'm sorry but i'm not that familiar with all this stuff yet. I don't know how to set up proper access in the database.

I don't know how your webhost does things because the same things can be done different ways. I set things up differently on my own server than I do when using my webhost account.

Please ask your webhost. I'm not trying to pass off support. I simply don't know how your webhost does things.

[dave650]

ok thanks for help so far.