Can the checkpoint table in the dm_meta metadata database be deleted when the DM data synchronization task is stopped, and how to delete it?

Translated
1

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

Original topic: DM数据同步， 元数据库dm_meta里的checkpoint表任务停掉可以删么，怎么删？

| username: 超7成网友

As the title suggests, under the dm_meta database, executing “show tables;” shows many checkpoint tables. If a task is stopped, can the checkpoint be manually deleted? How to delete it? Is it like using “drop table”?

2
| username: 哈喽沃德 | Original post link

DELETE FROM checkpoint WHERE task_id = ‘your_task_id’;

3
| username: 这里介绍不了我 | Original post link

What is the point of deleting this thing?

4
| username: 超7成网友 | Original post link

Solved, the table needs to be enclosed in backticks.

5
| username: wangccsy | Original post link

A newbie following along to learn.

6
| username: dba远航 | Original post link

Glad it’s resolved.

7
| username: system | Original post link

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