Skip to content

Listing MySQL backups

List all the MySQL backups that you've created to keep a track of when they are done.

Usage

$ skpr mysql backup list stg
 ─────────── ─────────────────── ──────────── ─────────────────────── ─────────────────────── ────────── ────────────────────
  BACKUP ID   NAME                PHASE        START TIME              COMPLETION TIME         DURATION   DATABASE
 ─────────── ─────────────────── ──────────── ─────────────────────── ─────────────────────── ────────── ────────────────────
  stg-jq7wc   stg-jq7wc-default   Completed    20 Apr 24 08:42 +0000   20 Apr 24 08:45 +0000   3m 0s      drupal-stg-default
 ─────────── ─────────────────── ──────────── ─────────────────────── ─────────────────────── ────────── ────────────────────

These MySQL backups can also be seen using the general backups command although with limited information.

$ skpr backup list stg
 ─────────── ──────────── ─────────────────────────────── ────────── ─────────── ─────────────────
  NAME        PHASE        START TIME                      DURATION   DATABASES   VOLUMES
 ─────────── ──────────── ─────────────────────────────── ────────── ─────────── ─────────────────
  stg-jq7wc   Completed    2024-04-20 08:42:22 +0000 UTC   3m 0s      default     n/a
  stg-26d7j   Completed    2024-04-20 07:49:29 +0000 UTC   3s         n/a         public
  stg-8slgf   Completed    2024-04-20 07:11:08 +0000 UTC   13s        n/a         private
 ─────────── ──────────── ─────────────────────────────── ────────── ─────────── ─────────────────
 ```

## More information

```bash
$  skpr mysql backup list --help
usage: skpr mysql backup list [<flags>] <environment>

List all mysql backups which have been created.

Flags:
  --help  Show context-sensitive help (also try --help-long and --help-man).
  --json  Show output as JSON.

Args:
  <environment>  Environment to list backups

What's next?

After listing a MySQL backup, consider one of the following: