Sign InTry Free

SHOW [BACKUPS|RESTORES]

This statement shows a list of all queued and running BACKUP and RESTORE tasks.

Use SHOW BACKUPS to query BACKUP tasks and use SHOW RESTORES to query RESTORE tasks. Both statements require SUPER privilege to run.

Synopsis

ShowBRIEStmt
SHOWBACKUPSRESTORESShowLikeOrWhere
ShowLikeOrWhere
LIKESimpleExprWHEREExpression

Examples

In one connection, execute the following statement:

BACKUP DATABASE `test` TO 's3://example-bucket/backup-01/?region=us-west-1';

Before the backup completes, run SHOW BACKUPS in a new connection:

SHOW BACKUPS;
+--------------------------------+---------+----------+---------------------+---------------------+-------------+------------+ | Destination | State | Progress | Queue_Time | Execution_Time | Finish_Time | Connection | +--------------------------------+---------+----------+---------------------+---------------------+-------------+------------+ | s3://example-bucket/backup-01/ | Backup | 98.38 | 2020-04-12 23:09:03 | 2020-04-12 23:09:25 | NULL | 4 | +--------------------------------+---------+----------+---------------------+---------------------+-------------+------------+ 1 row in set (0.00 sec)

The first row of the result above is described as follows:

ColumnDescription
DestinationThe destination URL (with all parameters stripped to avoid leaking secret keys)
StateState of the task
ProgressEstimated progress in the current state as a percentage
Queue_TimeWhen the task was queued
Execution_TimeWhen the task was started; the value is 0000-00-00 00:00:00 for queueing tasks
Finish_Time(not used for now)
ConnectionConnection ID running this task

The connection ID can be used to cancel a backup/restore task via the KILL TIDB QUERY statement.

KILL TIDB QUERY 4;
Query OK, 0 rows affected (0.00 sec)

Filtering

Use the LIKE clause to filter out tasks by matching the destination URL against a wildcard expression.

SHOW BACKUPS LIKE 's3://%';

Use the WHERE clause to filter by columns.

SHOW BACKUPS WHERE `Progress` < 25.0;

MySQL compatibility

This statement is a TiDB extension to MySQL syntax.

See also

Was this page helpful?

Download PDFRequest docs changesAsk questions on Discord
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.