Print

[n2ueg]

I am moving to a new host. YAY!

I have backups of my phpbb 2.0.6 and cpg 1.3.2 data via
mysqldump -u oldhostadmin -p oldhost_com >oldhost_com.sql
mysqldump -u oldhostadmin-p oldhost_comphpbb >oldhost_comphpbb.sql
tar -cvzfp cpg.tgz cpg/
tar -cvzfp phpbb.tgz phpbb/

I ftp'd the .sql and .tgz to the new host.  When the old host was setup, phpbb was already running on it.  CPG was integrated to it.  phpbb uses oldhost_comphpbb as the db and cpg uses oldhost_com as the db name.  The user/pass info is the same for both.  The DB is running on localhost.

So the new host, 1and1, has a slightly different setup so I upload the .sql and .tgz files and do some of this...
>mysql -u db40 -p dbo40 -h 172.31.5.140< geneseorxe_comphpbb.sql
>mysql -u db54 -p dbo54 -h 172.31.5.194< geneseorxe_com.sql
tar -xvzf cpg.tgz
tar -xvzf phpbb.tgz
nano cpg/include/config.inc.php
nano phpbb/config.php
chmod 755 cpg/albums/

and update the db hostname, username, password, and dbname in both configs for the new databases.  Which now have two different usernames, passwords and hosts.  phpBB now works correctly but not CPG.  I assume that it needs to connect to the other DB but how do I get it to connect to the other DB using a different user/pass/server/dbname to get the phpbb info than I have for the cpg info?  At least that is what I think is wrong...

[Nibbler]

What error messages do you get ? The phpbb db info neds to be specified in the phpbb bridge file. You really should update your gallery once this is resolved.

[n2ueg]

oh...and now all that is done, this is the error:

Coppermine critical error:
Unable to connect to phpBB Board database !

MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[n2ueg]

updating phpbb and cpg is next...unless it is easier to put new phpbb and cpg on the server...bridge file...looking fer it now

[n2ueg]

looks like I was forgetting the bridge file.  YAY it is working!   I can move tonight!  Thank you so much for your help.  After banging my head I figured it was something easy I was missing.