mysql databases (only) backup

Vjiadis

Registered
Jan 18, 2018
2
0
1
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,225
463
  • Backup Accounts x DISABLED
  • Backup SQL Databases (Per Account Only) x ENABLED
  • Compress Account Backups x ENABLED
Hello,

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.