dbreaver从mysql导出后导入greatsql报错，navicat没问题
本帖最后由 yunhai1990 于 2025-7-31 10:25 编辑C:\Users\Administrator\AppData\Roaming\DBeaverData\drivers\clients\mysql_8\win\mysql.exe -u root --host=10.50.12.50 --port=31002 tecs
任务'MySQL 恢复' 开始于 Thu Jul 31 10:17:30 CST 2025
ERROR at line 4667: Unknown command '\n'.
任务'MySQL 恢复' 结束于 Thu Jul 31 10:17:37 CST 2025
2025-07-31 10:17:37.147 - IO error: Process failed (exit code = 1). See error log.
2025-07-31 10:17:37.147 - java.io.IOException: Process failed (exit code = 1). See error log.
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:264)
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:242)
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:285)
at org.jkiss.dbeaver.ext.mysql.tasks.MySQLNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)
at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:88)
at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:123)
dbreaver选择的是转储数据库和恢复数据库navicat选择的是结构和数据一起导出导入同时做的其他十几个库都没问题，最开始甚至是用的dbreaver导入的navicat的都没问题。有两个库用dbreaver从mysql导出再导入greatsql都有上面的错误
dbreaver 25.1.3.202507201530navicat 16.3.9greatsql 8.0.32-27mysql 8.0.21
既然navicat没问题就用它呗
从MySQL迁移到GreatSQL也可参考 https://greatsql.cn/docs/8.0.32-27/7-migrate-and-upgrade/2-migrate-from-mysql-togreatsql.html 哪个能用就用哪个，用数据库自己带的工具更好一些。
页:
[1]