Can BR restore data to a specified database?

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

Original topic: BR可以恢复数据到指定的库里边吗

| username: Running

Can BR restore data to a specified database? I only found how to restore a specific database and specific tables, but not how to restore to a specific database. For example, how to restore data from database a to database b? How should this be handled?

| username: Soysauce520 | Original post link

The official statement is that the database names must be consistent.

| username: Soysauce520 | Original post link

If it’s not large, you can use Dumpling, which exports logical statements.

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

br is not supported

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

No, import it first, and then rename it.

| username: Running | Original post link

This is an online data recovery scenario. I want to restore the backup data to another database and then compare it with the online database. So once the data is imported, it will completely overwrite the previous data, making renaming unnecessary.

| username: Running | Original post link

The original backup file was backed up using BR.

| username: system | Original post link

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