TIDB Drainer无法启动

TIDB Drainer无法启动,报下面日志错误
[“create drainer server failed”] [error="initialize tidb type checkpoint with config &{CheckpointType:tidb Db:0xc00026f840 Schema:tidb-binlog Table:checkpoint ClusterID:6947119091400868786 InitialCommitTS:431609481387311169 CheckPointFile:/data/tidb-data/drainer-8249/savepoint}: exec failed, sql: create schema if not exists tidb-binlog: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 33 near “-binlog” "]

Drainer配置文件schema改成tidb_binlog试试

[syncer.to.checkpoint]
# 当 checkpoint type 是 mysql 或 tidb 时可以开启该选项,以改变保存 checkpoint 的数据库
# schema = "tidb_binlog"
2 个赞

不支持中划线
(mysql@localhost) [test] 03:23:07> create database jian-test;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘-test’ at line 1
(mysql@localhost) [test] 03:23:12> create database jian_test;
Query OK, 1 row affected (0.004 sec)

1 个赞

该主题在最后一个回复创建后60天后自动关闭。不再允许新的回复。