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

🪐 TiDB 技术问题 备份&数据迁移
1

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

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

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

2

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

image

3

测试过，报错，不支持

4

您好： 麻烦发一下报错，我再确认下，多谢

5

[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”]

6

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