使用sync_diff_inspector 如何对比所有数据库

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【TiDB 版本】:3.0.5
  • 【问题描述】:
    使用sync_diff_inspector 如何对比所有数据库

目前看文档里的参数,是支持库下所有的表的对比。表支持正则表达式匹配。但是库不支持,如何配置对比所有数据库?

您好:
参考设置为全表试试 https://pingcap.com/docs-cn/v3.0/reference/tools/sync-diff-inspector/overview/#sync-diff-inspector-用户文档

image

测试过,报错,不支持

您好: 麻烦发一下报错,我再确认下,多谢

[tidb@localhost bin]$ ./sync_diff_inspector --config=./config.toml [2020/04/16 19:52:02.744 +08:00] [FATAL] [main.go:76] [“fail to initialize diff process”] [error=“schema target.~^h3.* not found”] [errorVerbose=“schema target.~^h3.* not found\ngithub.com/pingcap/errors.NotFoundf\ \t/home/jenkins/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/errors@v0.11.1/juju_adaptor.go:75\ main.(*Diff).AdjustTableConfig\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:174\ main.(*Diff).init\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:86\ main.NewDiff\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/diff.go:72\ main.checkSyncState\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:74\ main.main\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\ runtime.main\ \t/usr/local/go/src/runtime/proc.go:200\ runtime.goexit\ \t/usr/local/go/src/runtime/asm_amd64.s:1337”] [stack=“github.com/pingcap/log.Fatal\ \t/home/jenkins/workspace/build_tidb_tools_master/go/pkg/mod/github.com/pingcap/log@v0.0.0-20190307075452-bd41d9273596/global.go:59\ main.checkSyncState\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:76\ main.main\ \t/home/jenkins/workspace/build_tidb_tools_master/go/src/github.com/pingcap/tidb-tools/sync_diff_inspector/main.go:62\ runtime.main\ \t/usr/local/go/src/runtime/proc.go:200”]

您好: schema target.~^h3.* not found 请问要对比的两个库都有这些吗?