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?

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”?

| username: 哈喽沃德 | Original post link

DELETE FROM checkpoint WHERE task_id = ‘your_task_id’;

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

What is the point of deleting this thing?

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

Solved, the table needs to be enclosed in backticks.

| username: wangccsy | Original post link

A newbie following along to learn.

| username: dba远航 | Original post link

Glad it’s resolved.

| username: system | Original post link

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