cPanelResources

Tutorial MySQL Backups Storage Location

If MySQL backups have been configured within WHM > Backup > Backup Configuration, then the server may have a recent backup already. First, check to see where backups are being stored and what kind of MySQL backups are being taken:

Code:
grep 'BACKUPDIR\|MYSQL' /var/cpanel/backups/config

The BACKUPDIR is where cPanel will store the backups if they are being retained locally. While having these backups are useful, it may be prudent to generate a more current backup of MySQL.

MYSQLBACKUP can return any of the following:
  • accounts - all databases under each cPanel account are backed up directly into the account's backup
  • dir - the MySQL data directory is backed up only (custom data directories are taken into account)
  • both - each cPanel account will have their databases backed up directly into their backup, and the MySQL data directory is backed up separately


Admin Note:
=======================================================================
This cPanel staff tutorial is no longer being maintained/updated here. For the most recent/up to date version please go here: cPanel Support - MySQL Backups Storage Location
Author
cPanelResources
Views
4,009
First release
Last update
Rating
0.00 star(s) 0 ratings