Can BR backup filter data from a specific table and retain only the structure?

Translated
1

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

Original topic: br备份能否过滤某张表数据只保留结构啊？

| username: JOJO_DB

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed that led to the issue
[Encountered Issue: Problem Symptoms and Impact]
[Resource Configuration]
[Attachments: Screenshots / Logs / Monitoring]
The topic is as above, how should I write it? Thanks!

2
| username: 我是咖啡哥 | Original post link

No.
To back up only the table structure, use dumping -d or --no-data.

3
| username: JOJO_DB | Original post link

What should be used to filter a specific table?

4
| username: h5n1 | Original post link

Exclude this table, then export the table structure separately.

5
| username: 裤衩儿飞上天 | Original post link

Reference: TiDB Snapshot Backup and Restore Guide | PingCAP Documentation Center

6
| username: 裤衩儿飞上天 | Original post link

The previous one is v6.5
This one is v5.4 Using BR Command Line for Backup and Restore | PingCAP Documentation Center

7
| username: Kongdom | Original post link

BR is a physical backup, it should not be supported. It is recommended to use logical backup.

8
| username: 胡杨树旁 | Original post link

When backing up, both the table structure and data should be backed up together and cannot be separated. If it’s just the table structure of a single table, you can create it manually.