How to Configure TiDB Backup CR to Backup System Databases

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

Original topic: tidb备份cr如何配置可以备份系统库

| username: ks_ops_ms

【TiDB Usage Environment】Production Environment / Testing / PoC
【TiDB Version】7.1.0
【Reproduction Path】What operations were performed that led to the issue
【Encountered Issue: Issue Phenomenon and Impact】Found this parameter in the documentation, but not sure how to reflect it in the backup YAML
【Resource Configuration】
【Attachment: Screenshot/Logs/Monitoring】

| username: ks_ops_ms | Original post link

During a recent test of TiDB backup migration, it was found that the user information in the migrated TiDB database was empty. It seems that if you want to perform a backup through BR’s CRD, certain parameters need to be set.

| username: Fly-bird | Original post link

It’s written in the document you screenshotted.

| username: ks_ops_ms | Original post link

I’m not very clear about the specific type of this parameter configuration in the YAML file.

| username: ks_ops_ms | Original post link

It’s not clear how this parameter is specified in the YAML file. Is it tableFilter: “.”?

| username: Soysauce520 | Original post link

Dumpling does not back up user information, while BR does. However, when restoring with BR, if you need to restore user information, you must keep an empty database and add the parameter --with-sys-table.

| username: ks_ops_ms | Original post link

This is done using the br command, but it seems that there is no such parameter in the scheduled backup of crd. It seems that tablefilter needs to be configured. I will test it to see if it works.

| username: ks_ops_ms | Original post link

Adopted another backup user solution

Tested and feasible

| username: system | Original post link

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