How to move MySQL databases between accounts

[appcomm]

Here's the situation. All this is taking place on the same server.


Let's say we have an account setup for: ALPHA.domainname.com. We install vBulletin and a couple of other programs for the site which require SQL databases.

Ok, now it's 6 months later and we setup another account on the same server for: DELTA.domainname.com. This is going to be the "makeover" site for ALPHA. We install the SAME programs here (like vBulletin) and point them to the existing MySQL databases (on ALPHA). Naturally we are doing this as it will allow us to work on changing the themes, skins etc for these programs and evaluate them during development. When the makeover is done, we would just switch the DNS and point to the "new" site.


That leads to this question. Is there a way to move these SQL databases (like the one for vBulletin) over from ALPHA to DELTA, or will we have to continue to leave ALPHA active in WHM so we can access the databases through cPanel? What we are looking for is the process to "clean up" this situation and get all the databases in one spot, on the active domain account when we are finished.


Hope that makes sense - will appreciate any words of wisdom on this!

 

[freedman]

Here's the situation. All this is taking place on the same server.


Let's say we have an account setup for: ALPHA.domainname.com. We install vBulletin and a couple of other programs for the site which require SQL databases.

Ok, now it's 6 months later and we setup another account on the same server for: DELTA.domainname.com. This is going to be the "makeover" site for ALPHA. We install the SAME programs here (like vBulletin) and point them to the existing MySQL databases (on ALPHA). Naturally we are doing this as it will allow us to work on changing the themes, skins etc for these programs and evaluate them during development. When the makeover is done, we would just switch the DNS and point to the "new" site.


That leads to this question. Is there a way to move these SQL databases (like the one for vBulletin) over from ALPHA to DELTA, or will we have to continue to leave ALPHA active in WHM so we can access the databases through cPanel? What we are looking for is the process to "clean up" this situation and get all the databases in one spot, on the active domain account when we are finished.

assuming I understand correctly...
cpanel will have created the vbulletin database as ACCOUNT_vbdbname
ALPHA.domainname.com & DELTA.domainname.com are subdomains, and both controlled via domainname.com/cpanel as such, the ACCOUNT_vbdbname is accessible via that control panel's phpmyadmin

as it is now, as long as you reference the db name, with the right dbuser and pass, then it doesn't really matter.
what I'd suggest is to create a new database for production:
ACCOUNT_vbdbprod
use phpmyadmin or mysqldump to dump the entire ACCOUNT_vbdbname database.. import it into ACCOUNT_vbdbprod

then make sure the config files on DELTA know the right user/pass and db name.

if these are different servers, then the process is still the same.

hope I understood you correctly.