The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to move MySQL databases between accounts

Discussion in 'General Discussion' started by appcomm, Feb 6, 2007.

  1. appcomm

    appcomm Active Member

    Joined:
    Jan 12, 2004
    Messages:
    35
    Likes Received:
    0
    Trophy Points:
    6
    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!
     
  2. freedman

    freedman Well-Known Member

    Joined:
    Feb 13, 2005
    Messages:
    312
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
Loading...

Share This Page