Issues with TiDB Data Backup

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb数据备份问题

| username: emerson_cai

[TiDB Usage Environment] Production Environment / Testing / Poc
[TiDB Version]
[Reproduction Path] What operations were performed that caused the issue
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

b9d41d150358b4a79e2964d0f760d63
b9d41d150358b4a79e2964d0f760d63975×256 25.4 KB

b2652379386c616c868b6302ed5327c
b2652379386c616c868b6302ed5327c1380×400 67.6 KB

Is there a contradiction here? Does it support partial database/table backup and restore or not?

  • You can restore a full backup, or partial databases/tables from a full backup, to restore the target cluster to the data state corresponding to that full backup.
  • Based on backup data (full and log), you can specify any point in time to restore the target cluster to the data state of the backup cluster corresponding to that point in time (Point-in-time recovery, PITR).

What does the second sentence mean?

Documentation link: TiDB 备份与恢复概述 | PingCAP 文档中心

2
| username: TiDBer_jYQINSnf | Original post link

Full backup can specify tables and databases, but incremental backup cannot specify databases or tables. That should be the meaning.

3
| username: emerson_cai | Original post link

What are the prerequisites for using snapshot data backup to restore data? If the original file has been deleted, can it still be restored?

4
| username: TiDBer_QYr0vohO | Original post link

Full backup recovery can specify databases/tables, but log backups cannot.

5
| username: Daniel-W | Original post link

Full backup is possible, but PITR (Point-in-Time Recovery) is not. Someone has raised this requirement:
Regarding PITR not being able to restore data by table or database - TiDB Q&A Community (asktug.com)

6
| username: Kamner | Original post link

This mentions two dimensions:
One is time-based recovery.
The other is recovery of full or partial databases/tables, without considering time.

7
| username: 随缘天空 | Original post link

It is indeed a bit confusing.

8
| username: wangkk2024 | Original post link

Same question

9
| username: DBAER | Original post link

Mark, make a note.

10
| username: xiaoqiao | Original post link

Question, please confirm with the official submission.

11
| username: 友利奈绪 | Original post link

Use BR to restore a specified table or database.

12
| username: 小于同学 | Original post link

Full backup can specify tables and databases, but incremental backup cannot specify databases or tables. That should be the meaning.

13
| username: dba远航 | Original post link

Full backup is possible, but PITR (Point-in-Time Recovery) is not. This is a basic fact in distributed databases, and none have implemented it (except OB).

14
| username: stephanie | Original post link

br supports specifying tables, pitr does not.

15
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.