How to Use BR to Restore Incremental Data of a Specified Database at a Specified Point in Time (PITR)

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

Original topic: 怎么使用br恢复指定时间点pitr的指定数据库的增量数据

| username: 末日温度

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] v6.5
[Reproduction Path] There are full backups and LOG backups, and the full and log backups are for all instances a, b, c.
[Problem Encountered: The business is running normally now. The aa table in the full backup of instance a has been restored, and the log backup of the aa table in instance a also needs to be restored. How should this be done?]
[Resource Configuration]
[Attachment: Screenshot / Log / Monitoring]

| username: tidb菜鸟一只 | Original post link

Look here, TiDB 日志备份与 PITR 使用指南 | PingCAP 文档中心

| username: 末日温度 | Original post link

br restore point --db --table Missing the last two parameters
br restore point This directly restores the log increment of all tables in all instances, right?

br restore point --pd “${PD_IP}:2379”
–storage=‘s3://backup-101/logbackup?access-key=${access-key}&secret-access-key=${secret-access-key}"’
–full-backup-storage=‘s3://backup-101/snapshot-${date}?access-key=${access-key}&secret-access-key=${secret-access-key}"’
–restored-ts ‘2022-05-15 18:00:00+0800’

| username: tidb菜鸟一只 | Original post link

Yes, PITR can only restore the entire database.

| username: 末日温度 | Original post link

:upside_down_face: I wonder if there will be any optimizations later on.