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!

Backup database on server and restore?

Discussion in 'Database Discussion' started by Gojko, Feb 26, 2019.

  1. Gojko

    Gojko Well-Known Member

    Joined:
    Nov 24, 2014
    Messages:
    94
    Likes Received:
    7
    Trophy Points:
    8
    Location:
    Macedonia
    cPanel Access Level:
    Root Administrator
    Hello, i installed CL and i want to set options, but i want to backup completely database so i can upgrade/update.
    I can't find to backup whole server database and restoration documentation.

    So thinks what i wont:
    1.backup database (system,user...)
    2.update database
    3. if fail, restore database (system,user...)

    how i can do this?
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,734
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hello @Gojko

    If you'd like to backup all the databases for all your users on the system you'd need to do a full server automated backup. This can be setup but going to WHM>>Backup>>Backup Configuration. This will not just backup databases but the full accounts which will also include the database backups.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Gojko

    Gojko Well-Known Member

    Joined:
    Nov 24, 2014
    Messages:
    94
    Likes Received:
    7
    Trophy Points:
    8
    Location:
    Macedonia
    cPanel Access Level:
    Root Administrator
    Right so there is no way to backup only databases.
    I have another question, i know how to restore accounts and databases for users, how i can restore system database?
    When i go to WHM > phpmyadmin i see all databases for users, but if something is broken and because of database i can't login to WHM how i can restore database for system trough terminal?
    Of course database which is prevision created trough backup options in WHM.
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,734
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Well there is, just not through WHM. You can back up databases on a per account basis in cPanel or by using mysqldump's --all-databases flag such as discussed here: Export and Import all MySQL databases at one time

    There is no "system database" most of our internal databases use sqlite and shouldn't ever need to be restored, in what circumstance have you experienced something like this or do you have an example of behavior you're trying to rectify?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelLauren, Feb 27, 2019
    Last edited: Feb 27, 2019
  5. Gojko

    Gojko Well-Known Member

    Joined:
    Nov 24, 2014
    Messages:
    94
    Likes Received:
    7
    Trophy Points:
    8
    Location:
    Macedonia
    cPanel Access Level:
    Root Administrator
    Thank you for a link it didn't show on my google search when i google it.

    No, i want to be prepared for anything because i want to upgrade mysql to MariaDB after that install CL Mysql Governor. And if something goes wrong so i can restore. Or any other disaster recovery scenario.
     
  6. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,734
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    The best thing to have in that instance is account backups for all accounts on the server, the rest is just a matter of reinstalling cPanel in the event of an emergency. Also we're happy to help with cPanel specific issues if you ever need assistance identifying a problem or resolving something cPanel specific we'd be happy to work with you on it, feel free to open a ticket in those circumstances.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    1,206
    Likes Received:
    74
    Trophy Points:
    28
    cPanel Access Level:
    Root Administrator
    cPanelLauren likes this.
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