Can tiup br backup table specify multiple tables at once?

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

Original topic: tiup br backup table 是否能一次性指定多张表?

| username: yulei7633

Can tiup br backup table specify multiple tables at once?
Online sources say:


But the execution results in an error. If I switch to a single table, the execution result is normal.

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

You can export multiple tables using --filter ‘db*.tbl*’, while --table can only specify a single table.

| username: yulei7633 | Original post link

I’ve tried this kind, but the matching mechanism may not quite align with actual needs, potentially matching too much or too little.
It would be best if it could be similar to mysqldump -B table1 table2. Unfortunately, it seems like this feature is not available.

| username: DBAER | Original post link

How about using a for loop? :slight_smile:

| username: 啦啦啦啦啦 | Original post link

You can use multiple --filter, such as -f ‘test.yulei’ -f ‘test.jj’

| username: yulei7633 | Original post link

Is it possible to write multiple of these? If only one is allowed, that would be best. I’ll test it later.

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

You can use multiple filters. Actually, for backing up tables, wouldn’t Dumpling be better…

| username: yulei7633 | Original post link

I have considered using Dumpling, but the data volume of a single table is too large, some have already reached terabytes.

| username: TIDB-Learner | Original post link

Add -f.

| username: system | Original post link

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