“RawCause”: “[Lightning:Restore:ErrCreateSchema]create schema failed, table: db_target
., stmt: restore database schema: run create schema job failed: Error 1273 (HY000): Unsupported collation when new collation is enabled: 'utf8mb4_0900_ai_ci'", "Workaround": "" } ], "detail": null }, "unresolvedDDLLockID": "", "load": { "finishedBytes": "0", "totalBytes": "0", "progress": "0.00 %", "metaBinlog": "(mysql-bin-changelog.031508, 26970784)", "metaBinlogGTID": "21e02bb3-48b6-38d2-9839-148a6cd05851:1-8290975", "bps": "0" }, "validation": null } ] }, { "result": true, "msg": "", "sourceStatus": { "source": "mysql-replica-02", "worker": "dm-10.8.0.149-8262", "result": null, "relayStatus": null },
表的字符集不一样。手动处理,或是忽略掉检查就可以
https://docs.pingcap.com/zh/tidb/stable/dm-precheck#可忽略检查项