MySQL-backups storage location

Question

How can I identify where MySQL backups are stored?

Answer

The backup configuration can tell you where the backup storage directory is as well as what kinds of backups are generated for MySQL:

1. Access the server via WHM as the root user
2. Navigate to "Home / Backups / Backup Configuration"
3. Ensure the backups are enabled through the "Enable Backups" checkbox. If backups are not enabled, there will be no MySQL backups to review
4. The setting for "Back up SQL Databases" will indicate where you will find the databases backed up:
   Per Account Only: The backups are stored within the account backup archives.
   Entire Data Directory: The entire MySQL data directory is backed up in a single archive.
   Per Account and Entire Data Directory: Both of the above operations are performed separately.
5. The "Default Backup Directory" will show what directory holds the backups locally, and the option to "Retain Backups in the Default Backup Directory" will confirm that a local copy is retained when backups are run.