How to move cpg database for bridging

[RoarinRow]

When I first set up the Coppermine database, I had originally wanted it as a stand alone and so I set the cpg database separate from my SMF forum database.

I've changed my mind and would like to move or bridge the cpg database to my SMF database, same domain, etc.

Currently my phpMyAdmin panel does not have an import feature, only export. 

My cpg database is one one database called 'dog1' for example and my SMF database is in 'dog2' database.  I can see both database since they're in the same domain.

Do you think I can still bridge the two together?

I'm on cpg v.143 and on SMF 1.1 RC2

Thanks in advance. 

[Tranz]

It might not be straightforward, but the "import" function is available in the SQL tab...

[RoarinRow]

It might not be straightforward, but the "import" function is available in the SQL tab...

Great, thanks I'll check that out.  Hoping I don't have to use that.  I'm alway leary about touching the database manually.  But I guess the bridging of user names and such won't work if they're not on the same 'dog2' database?

Edit - I just checked and my version of myphpAdmin doesn't have the import feature.  This is the version of myphpAdmin - phpMyAdmin 2.6.3-pl1

[Nibbler]

You don't need to have them in the same database to use bridging. You can have them in different databases on different servers in different countries if you like.

[RoarinRow]

You don't need to have them in the same database to use bridging. You can have them in different databases on different servers in different countries if you like.

Thank you.  I enabled the bridging, now I've got a separate issue.  There are some users albums that are now assigned to a different user.  So now Album A belongs to Member B, instead of Member A.  How can fix that?

Edit - I looks like it was grabbing the names from database A instead of database B where my member database is.  Any fixes?

Edit - After I disabled the bridge it looks like I lost some users as well.  Any fixes?  Their albums are still there, but in the memberlist, they're gone.

[Joachim Müller]

1) One issue per thread
2) 5.2.3 Coppermine users, groups and pics uploaded by users are lost when integrating
3) When requesting bridge support - mandatory!