DM Migration Error

Translated
1

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

Original topic: DM迁移报错

| username: 烂番薯0

The first image is not visible, so I cannot provide a translation for it. Here is the translation for the second image:

“TiDB is a distributed SQL database that features horizontal scalability, strong consistency, and high availability. It is compatible with the MySQL protocol and can be used as a drop-in replacement for MySQL. TiDB is designed to handle large-scale data and high-concurrency scenarios, making it suitable for various applications such as online transaction processing (OLTP), online analytical processing (OLAP), and hybrid transactional/analytical processing (HTAP).”

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

There is an issue with your configuration:
In do-dbs: account
In ignore db-name: accout

image
image1030×896 141 KB

3
| username: 烂番薯0 | Original post link

What I want to ignore are those tables in the account. The error reported above is that these tables do not exist.

4
| username: 裤衩儿飞上天 | Original post link
  1. The db-name is incorrect, it should be account.
  2. You can refer to the documentation: TiDB Data Migration Black and White List Filtering | PingCAP Docs
5
| username: 烂番薯0 | Original post link

Still not working, the same error is reported. I changed the configuration a bit.

1673424703812
1673424703812749×398 8.06 KB

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

You can refer to the configuration of this complete migration process: Migrate Data Using DM | PingCAP Docs

7
| username: 烂番薯0 | Original post link

Okay, thank you.

8
| username: okenJiang | Original post link
  1. You need to include both do-dbs and do-tables in the whitelist for it to take effect; you can’t just fill in do-dbs.
  2. Similarly, you need to include both ignore-dbs and ignore-tables in the blacklist for it to take effect; you can’t just fill in ignore-tables.
9
| username: system | Original post link

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