How to Specify Different Database Names When Importing Data with Lightning

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

Original topic: lightning 导入数据时,如何指定不同库名

| username: TiDBer_Z93z8JhD

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] 6.5.2
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Problem Phenomenon and Impact]

First, use dumpling to export the db1.test table
Command:
tiup dumpling -u *** -p *** -P 3306 --filetype sql -B db1 -T db1.test -m -t 4 -o /data/mysql/date -r 300000 -F512MiB**

How to use lightning to import db2.test

| username: zhanggame1 | Original post link

[[routes]]
schema-pattern = “source_database_name”
table-pattern = “table1”
target-schema = “target_database_name”
target-table = “table1_0826”

Reference: tidb-lightning配置数据还原路由_tidb lightning route-CSDN博客

| username: linnana | Original post link

Is it possible to import multiple different databases and tables at once?

| username: TiDBer_Z93z8JhD | Original post link

There is no need for multiple, one db2 is enough.