Changing hosting providers

[dubie]

I plan to change hosting providers. Is there an easy way to transfer to new hosting provider? Has anyone done this and what is involved in transferring coppermine to new server. Thanks for the help.

-dubie

[Joachim Müller]

• Backup your files: FTP-download your complete coppermine-folder to your hard drive
  
• use a tool like phpMyAdmin to get a dump (backup) of your mySQL database entries (see http://coppermine.sourceforge.net/faq.php?q=BackupDatabase#BackupDatabase )
  
• verify your backup is working: check if the mySQL-dump contains all data (open the zipped dump file and use a text editor to view it)
  
• on the new server: FTP-upload your coppermine-folder to the new server
  
• CHMOD the folder /albums to 755 or 777 (depending on your server config]
  
• install phpMyAdmin onto your new server
  
• restore the mySQL table by running the queries of the dump files you created in step 2
  
• test-drive your coppermine gallery - you should be done

GauGau

[dubie]

Thanks for your time and help. I will give it a whirl.

-Andrew

[Tranz]

This should be a sticky but I am unsure where...

[Joachim Müller]

let's put this into the FAQ - could you write a comprehensive article, commit it and let me know - I'll update the faq on the website accordingly. Another option might even be a tutorial video *hint* ...

Joachim

[Rory]

• Backup your files: FTP-download your complete coppermine-folder to your hard drive
  
• use a tool like phpMyAdmin to get a dump (backup) of your mySQL database entries (see http://coppermine.sourceforge.net/faq.php?q=BackupDatabase#BackupDatabase )
  
• verify your backup is working: check if the mySQL-dump contains all data (open the zipped dump file and use a text editor to view it)
  
• on the new server: FTP-upload your coppermine-folder to the new server
  
• CHMOD the folder /albums to 755 or 777 (depending on your server config]
  
• install phpMyAdmin onto your new server
  
• restore the mySQL table by running the queries of the dump files you created in step 2
  
• test-drive your coppermine gallery - you should be done

GauGau

hello, i am also trying to do this but don't quite understand how to get my exported database onto my new provider using phpmyadmin. also do i not need to tell coppermine where my new mysql server is?

[Joachim Müller]

download the dump your created using phpMyAdmin to your pc. Then install phpMyAdmin (if it doesn't already exist) on the new server and upload the dump file to it (using the "SQL" button in phpMyAdmin's user interface), or copy'n paste the contents into the text field.
To "tell" coppermine on your new server what mySQL tables to use, edit the file include/config.inc.php and enter the new mySQL connection data there.

Joachim

[Tarique Sani]

Lets Wiki this

[LMalnati]

Thanks everyone who contributed above.  I'm switching my host and this well-documented transfer process will be quite handy.

[LMalnati]

People should also be aware they can load MySQL Admin to do a backup of there databases.  If you do not already have phpmyadmin and you need to backup up your dbs this may be a good option since installing phpMyadmin is a little more involved. 

In any event its another choice for backup