Yet another question on moving to new host...

[Colliope]

Original Host - free account at 1 & 1.  I have both a Coppermine Gallery and a phpBB2 forum there. They share the same database,  but I have not bridged/integrated the forum & gallery. They are both stand-alone.

New Host - paid account. I successfully created a database here and successfully moved my phpBB2 forum. Alll is working fine.

Now, I want to move my Coppermine gallery. I have already copied all the files, but don't know how to go about the database part. I have read here that if I want to be able to bridge the gallery & forum in the future, they need to share the same database. I have asked my webhost how to go about moving my Coppermine Gallery into the same database I created for my phpBB2 forum, but that's not something he's had any experience doing.

So, any ideas on how i do this? I don't think I will ever want to bridge the forum & gallery, so if I have to make a seperate database at new host for Coppermine, I'm open to doing that if it will be easier than moving it into the one I created for the forum.

Col

(Using Coppermine 1.3.2, with lots of customizations to my theme.)

[kegobeer]

They shared the same database before, so just move all the tables to the new database.  If the MySQL settings are different from your previous setup, just make the appropriate changes to config.inc.php.

[Colliope]

Well, that makes sense! What I did was, I used the backup option built into the phpBB board and imported that to a newly created database at my new host, but that of course, only contained the forum data.

So using myAdmin I've made a backup of the entire database at old host that contains both forum & gallery data and am working on importing that to new host.
I am just wondering if I checked all the correct options when backing it up. This is a screenshot of the backup page with default settings:

http://colliope.com/screenshots/backup_db_01.jpg

I UNchecked "Add auto_increment value", "enclose table and field names with backquotes", and "use hexadecimal for binary fields", left eveything else the way it was and saved it. Was that the correct choice of options?

Thanks,

Col

[Nibbler]

You probably want to keep the auto_increment value, not 100% sure though.

[Colliope]

Had some problems but eventually got the database imported to new host. Now I have more questions. Will ask seperately. Thanks,

Col