Can TiDB use BR for backup and restore a single table during recovery?

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

Original topic: tidb使用br做备份,恢复的时候,可以单独恢复某个表吗?

| username: hacker_77powerful

When using BR for backup in TiDB, can you restore a single table?

| username: 这里介绍不了我 | Original post link

Of course, take a look at this document TiDB Snapshot Backup and Restore Command Line Manual | PingCAP Documentation Center

| username: DBAER | Original post link


| username: hacker_77powerful | Original post link

Okay, got it. Let’s follow the documentation and give it a try.

| username: Jack-li | Original post link

Sure, there is an official documentation introduction.

| username: TiDBer_JUi6UvZm | Original post link

Use tiup br with the --db option to specify the database name to be restored, and the --table option to specify the table name to be restored.

| username: YuchongXU | Original post link


| username: TiDBer_QYr0vohO | Original post link


| username: 呢莫不爱吃鱼 | Original post link

Yes, it can be done by controlling through parameters.