How to enable MySQL database backups in WHM

Introduction

This article provides the procedure to backup MySQL databases when backups run.

Procedure

1. Log into WHM as the ‘root’ user.
2. Navigate to "Home / Backup / Backup Configuration."
3. Ensure that "Enable Backups" is checked.
4. Scroll down to the "Databases" section.
5. Under "Back up SQL Databases," select the desired option.
   Please exercise caution when selecting the "Entire MySQL Directory" or "Per Account and Entire MySQL Directory" options. These options will back up databases without stopping the MySQL service, which can lead to InnoDB issues in the backup file. The system can not restore backup files with InnoDB issues.
6. Click the "Save Configuration" button.

Additional resources

Backup Configuration