MySQL backup prerequisites¶
Before creating MySQL backups, make sure to:
Check that Backup Management is enabled and the Backup option is available on the side menu. If Backup Managemt has been disabled on your instance, go to Configuration > PMM Settings > Advanced Settings, re-enable Backup Management then click Apply changes. !!! caution alert alert-warning “Important” If PMM Server runs as a Docker container, enable backup features at container creation time by adding
-e ENABLE_BACKUP_MANAGEMENT=1to your
Check that the PMM Client is installed and running on the node.
To enable Xtrabackup for MySQL 8.0+, check that pmm-agent connects to MySQL with a user that has BACKUP_ADMIN privilege.
Check that there is only one MySQL instance running on the node.
Verify that MySQL is running:
as a service via
with the name
mysqld(to confirm, use
systemctl status mysqlor
systemctl status mysqldrespectively);
mysqlsystem user account.
Make sure that there is a
Check that MySQL is using the
/var/lib/mysqldirectory for database storage.
Make sure that
pmm-agenthas read/write permissions to the
Check that the latest versions of the following packages are installed and included in the
The versions of each must be compatible with the installed version of MySQL.
Get expert help¶
If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.