Charmed MySQL How to | Create a backup

Note: All commands are written for juju >= v.3.0

If you are using an earlier version, check the Juju 3.0 Release Notes.

How to create and list backups

This guide contains recommended steps and useful commands for creating and managing backups to ensure smooth restores.

Prerequisites


Create a backup

Once juju status shows Charmed MySQL as active and idle, you can create your first backup with the create-backup command:

juju run mysql/leader create-backup

If you have a cluster of one unit, you can run the create-backup action on mysql-k8s/leader (which will also be the primary unit).

Otherwise, you must run the create-backup action on a non-primary unit. To find the primary, see juju status or run juju run mysql-k8s/leader get-cluster-status to find the primary unit).

List backups

You can list your available, failed, and in progress backups by running the list-backups command:

juju run mysql/leader list-backups