Print

[Fab]

I am going to move my Coppermine gallery to a new host.

I guess it's not as easy as copying all the data and moving it to the new host.
What the steps involved for a smooth transition?

[Fab]

Nerermind found the answer 2sec later http://coppermine-gallery.net/demo/cpg14x/docs/faq.htm#moveGallery
 

Please delete this thread

[Nibbler]

Threads are left as a reference to others. Thank you for posting the solution.

[Fab]

Please reopen

I have read the how to but I am struggling with the export part.

How can I backup my coppermine database?

There's no built-in backup solution for coppermine available yet. Meanwhile, backup your directory/file structure via good old ftp and use a tool like phpMyAdmin to backup the database (many webhosts that offer mySQL also offer a pre-installed version of phpMyAdmin - go for that!). PhpMyAdmin is easy to install: just download the distribution, unzip it to your harddrive, edit one config file and upload it to your server.
Here's a small "howto backup a database with phpMyAdmin":

    * get the software, install it (remember to password-protect it)
    * point your browser to the location you installed it on
    * click your database name in the left frame
    * in "View dump (schema) of database" select the table(s) you want to back up (press CTRL to select more than one table)
    * mark "Structure and data"
    * check "Save as file"
    * check "zipped"
    * DON'T check "Add 'drop table'" - your database will be erased, if you do
    * press "go"
    * save the file on your harddisk (depending on the speed of your connection this could take a while)

For reference I am using phpMyAdmin 2.7.0-pl2

* in "View dump (schema) of database" select the table(s) you want to back up (press CTRL to select more than one table)

I assume this mean to click "Check All

* mark "Structure and data"

Where is that? I only see a "structure" tab

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fimg412.imageshack.us%2Fimg412%2F1408%2Fclipboard05gu4.th.jpg&hash=8e4fe581a1ea26b91e09802d17b22f9a62efa6b7)

[Fab]

Okay found "Structure and data" under the Operation tab

On the same tab "CREATE DATABASE before copying" is ticked, should I leave it ticked?

[Nibbler]

Think about it. If you already have the new database created on your new host then don't tick it. If you want the new database to be created as part of restoring the backup and you have permissions to do so then tick it.

[Fab]

Thanks Nibbler

I am still a bit confused just realized this was under the export tab:

in "View dump (schema) of database" select the table(s) you want to back up (press CTRL to select more than one table)

Aside from "Save as file" and selecting the table what else need to be checked/unchecked?

(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fimg245.imageshack.us%2Fimg245%2F4418%2Fclipboard02me0.th.jpg&hash=bdb7b396700abc44869044605bee856e4647cf0e)

Back on the operation tab do I need to enter something under "Copy database to:"?
And from there do I click GO? or just go back the export tab?

And on the export tab

[Fab]

Finaly exported and imported the db

But I when accessing the page I get

Coppermine critical error:
Unable to connect to database !

MySQL said: Access denied for user 'fab_admin'@'localhost' (using password: YES)

I understand this is normal since on the new host the user is now fabre_admin and not fab_admin, database has also chanegd name.

In which file do I update this?

[Joachim Müller]

include/config.inc.php