Skip to content

Listing MySQL restores

Keep track of all the MySQL restores that are running on a particular MySQL.

Usage

MySQL backups can be restored directly from the Skpr CLI to any environment.

$ skpr mysql restore list stg
 ──────────── ─────────────────── ─────────── ─────────── ─────────────────────── ─────────────────────── ────────── ────────────────────
  RESTORE ID   NAME                BACKUP ID   PHASE       START TIME              COMPLETION TIME         DURATION   DATABASE
 ──────────── ─────────────────── ─────────── ─────────── ─────────────────────── ─────────────────────── ────────── ────────────────────
  stg-mkrbp    stg-mkrbp-private   stg-jq7wc   Completed   20 Apr 24 09:53 +0000   20 Apr 24 09:53 +0000   3s         default
 ──────────── ─────────────────── ─────────── ─────────── ─────────────────────── ─────────────────────── ────────── ────────────────────

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

$ skpr restore list stg
 ─────────── ─────────── ─────────── ─────────────────────────────── ────────── ─────────── ─────────
  NAME        BACKUP      PHASE       START TIME                      DURATION   DATABASES   VOLUMES
 ─────────── ─────────── ─────────── ─────────────────────────────── ────────── ─────────── ─────────
  stg-mkrbp   stg-jq7wc   Completed   2024-04-20 07:53:46 +0000 UTC   3s         default     n/a    
 ─────────── ─────────── ─────────── ─────────────────────────────── ────────── ─────────── ─────────
 ```

## More Information

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

List all mysql restores 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 restores

What's next?

After listing restored MySQL backups, consider one of the following: