Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Moving Database from Stand-alone Domain to Add-on Domain

Discussion in 'General Discussion' started by Lamar, May 12, 2005.

  1. Lamar

    Lamar Well-Known Member

    Joined:
    Jan 9, 2002
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    306
    A client wants to change a domain from its own account to being an add-on domain of another domain. Funny, it's usually the other way around. No problem, mostly, as I have done this before. However, he just told me that he needs to move a database associated with the domain. What is the most painless method to move the database so that it serves the add-on? Databases are my most profound weakness.
     
  2. myusername

    myusername Well-Known Member
    PartnerNOC

    Joined:
    Mar 6, 2003
    Messages:
    693
    Likes Received:
    1
    Trophy Points:
    168
    Location:
    chown -R us.*yourbase*
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    You should be able to just go into phpmyadmin and use the export option. keep all the defaults, then select the option to "ave as a file" then just go to the new accounts phpmyadmin and upload the file.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. RAIS2

    RAIS2 Well-Known Member

    Joined:
    Jul 16, 2004
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    166
    Additionally, as the move is from a different username, the script using the DB will need the new login info. Besure that the db user has permissions to the db.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice