How to restore a local backup

This is a How-To for performing a basic restore (restoring a locally made backup). To restore a backup that was made from the a different cluster, (i.e. cluster migration via restore), please reference the Cluster Migration via Restore How-To:

Prerequisites

• Scale-down to the single MySQL unit (scale it up after the backup is restored).
• Access to S3 storage
• Have configured settings for S3 storage
• Have existing backups in your S3-storage

Summary

• List backups
• Restore backup

List backups

To view the available backups to restore you can enter the command list-backups:

juju run mysql/leader list-backups

This should show your available backups

    backups: |-
      backup-id             | backup-type  | backup-status
      ----------------------------------------------------
      YYYY-MM-DDTHH:MM:SSZ  | physical     | finished

Restore backup

To restore a backup from that list, run the restore command and pass the backup-id to restore:

juju run mysql/leader restore backup-id=YYYY-MM-DDTHH:MM:SSZ

Your restore will then be in progress.