Here's the situation. All this is taking place on the same server, using WHM and cPanel.


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!

Download a backup from ALPHA and restore it to DELTA.

You could also do it from a terminal in case the files are large and you don't want to spend the time or bandwidth moving them across the net for no reason.

If you want help PM or IM me.

CPanel has a backup and restore facility to do this on the Backup page. Try what lyzer said and you can test this as well on the DELTA domain to see if all are in order by pointing the script to the copied database. You can easily switch to the ALPHA database if restore is not good.

Hope this helps.