Will restoring a cPanel account delete irrelevant mysql databases?
        Posted  
        
            by 
                user54625
            
        on Server Fault
        
        See other posts from Server Fault
        
            or by user54625
        
        
        
        Published on 2012-07-10T01:21:18Z
        Indexed on 
            2012/07/10
            3:17 UTC
        
        
        Read the original article
        Hit count: 472
        
Long story short: I have many accounts in WHM, many domains. However, most of the MySQL databases for all the sites were created under one user, "admin" (let's say it's admin.com). I recently moved the admin.com account to another web server , and now I need to move it back. I would like to restore this account from a backup made by that web server. However, it only has 3 databases attached to that domain, while the server I'm moving it to has those 3 databases (old DBs that need to be replaced), PLUS all the other databases which are used by other accounts on the server.
My question: if I restore the admin.com account, will it delete all the other databases on the account, or will it only replace the 3 DBs it has? I can't take any chances here to delete all those other DBs...
If it WOULD delete all those other accounts, how would I go about restoring this account without losing the other data? An easy to way to resolve this situation would be to move the mysql owners to the proper accounts, but alas it doesn't seem that there is a way to do that via WHM.
© Server Fault or respective owner