tidb-lightning导入数据报错：[error=“missing {schema}-schema-create.sql”]

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

image

现在我已经有备份的文件，一共200G的sql文件，需要导入tidb。

[2020/08/11 11:54:58.273 +08:00] [INFO] [lightning.go:208] [“load data source start”]
[2020/08/11 11:54:58.273 +08:00] [ERROR] [lightning.go:211] [“load data source failed”] [takeTime=81.402µs] [error=“missing {schema}-schema-create.sql”]
[2020/08/11 11:54:58.273 +08:00] [ERROR] [main.go:82] [“tidb lightning encountered error stack info”] [error=“missing {schema}-schema-create.sql”] [errorVerbose=“missing {schema}-schema-create.sql
github.com/pingcap/tidb-lightning/lightning/mydump.(*mdLoaderSetup).setup
\t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.4/go/src/github.com/pingcap/tidb-lightning/lightning/mydump/loader.go:190
github.com/pingcap/tidb-lightning/lightning/mydump.NewMyDumpLoader
\t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.4/go/src/github.com/pingcap/tidb-lightning/lightning/mydump/loader.go:119
github.com/pingcap/tidb-lightning/lightning.(*Lightning).run
\t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.4/go/src/github.com/pingcap/tidb-lightning/lightning/lightning.go:210
github.com/pingcap/tidb-lightning/lightning.(*Lightning).RunOnce
\t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.4/go/src/github.com/pingcap/tidb-lightning/lightning/lightning.go:150
main.main
\t/home/jenkins/agent/workspace/ld_lightning_multi_branch_v4.0.4/go/src/github.com/pingcap/tidb-lightning/cmd/tidb-lightning/main.go:79
runtime.main
\t/usr/local/go/src/runtime/proc.go:203
runtime.goexit
\t/usr/local/go/src/runtime/asm_amd64.s:1357”]
[2020/08/11 11:54:58.273 +08:00] [ERROR] [main.go:83] [“tidb lightning encountered error”] [error=“missing {schema}-schema-create.sql”]

2

这里有报错说明 missing {schema}-schema-create.sql ，请参考此贴导出schema文件或者手工创建，多谢。 Start_lightning.sh启动报错“schema-create.sql”文件找不到

3

我是通过mysqldump备份的sql文件，是可以通过Local-backend模式导入的不是，
schema-create.sql这个文件我创建后放在data-source-dir配置的目录下，还是同样的报错。

4
  1. 建议使用mydumper，不是mysqldumper来导出
  2. 如果没有，可以手工创建，多谢。
5

因为我这边是从阿里云drds导出来的数据，然后导入tidb，现在最快的方案是什么

6

如果不是特别多，那么就手工创建这些schema