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!

mysql databases (only) backup

Discussion in 'Data Protection' started by VJIADIS, Jan 18, 2018.

  1. Vjiadis

    Vjiadis Registered

    Jan 18, 2018
    Likes Received:
    Trophy Points:
    London, UK
    cPanel Access Level:
    Website Owner
    Hi guys!

    On an account basis cPanel is fantastic for backups - but this is manual - you need to login and select the options etc.

    Is there an automated way to get regular backups of the mysql databases (only) on an account basis.
    I know I can get the whole database will all accounts easily but I need a way to get a regular copy of the individual account databases - preferably just like the type you would get if you logged into an account and used the account backup tools

    is it possible to backup the mysql databases only on an (BULK / ALL) account basis and dump them to a directory or FTP them out.

    in the configure backups interface I have these options:

    Backup SQL Databases (Per Account Only)
    Compress Account Backups
    Backup Accounts


    Im wondering if I can set the options as follows:

    • Backup Accounts x DISABLED
    • Backup SQL Databases (Per Account Only) x ENABLED
    • Compress Account Backups x ENABLED

    I might get the databases only?

    I use rysnc to get the webfiles daily and take regular snapshots with a rdiff type tool to manage content but I cant find a solution for mysql files. (I know I can get whole of database - but that does not suit my need)

    any help would be appreciated.
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    When "Per Account" SQL databases are enabled, it includes the databases as part of the account backups. Thus, this won't work if "Backup Accounts" is disabled. That said, you could enable "Backup Accounts" and then exclude data that you don't want backed up:

    How to Exclude Files From Backups - cPanel Knowledge Base - cPanel Documentation

    Thank you.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

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