What is the purpose of the newly generated __TiDB_BR_Temporary_mysql database after completing the BR restore? Can it be deleted?

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

Original topic: 做完br恢复后新生成的__TiDB_BR_Temporary_mysql数据库有什么用?可以删掉吗?

| username: 滴滴嗒嘀嗒

As shown in the image:

| username: TiDBer_QYr0vohO | Original post link

Temporary tables can be deleted.

| username: 滴滴嗒嘀嗒 | Original post link

What are these tables used for? I couldn’t find any related documentation on the official website.

| username: 小龙虾爱大龙虾 | Original post link

What command did you use for the recovery?

| username: TiDBer_QYr0vohO | Original post link

| username: 滴滴嗒嘀嗒 | Original post link

Ah! Here :grinning:

| username: 滴滴嗒嘀嗒 | Original post link

It’s a point-in-time recovery: /home/tidb/.tiup/components/br/v6.5.2/br restore point --pd 192.168.21.4:30001 --storage /home/tidb/mountpoint --start-ts 2024-05-23 18:50:23 +0800 --restored-ts 2024-05-24 00:11:21 +0800

| username: 小龙虾爱大龙虾 | Original post link

Adding --with-sys-table=false will prevent the system table from being automatically restored.

| username: 滴滴嗒嘀嗒 | Original post link

Sure, thank you!

| username: 濱崎悟空 | Original post link

It can be deleted.