1、问题出现原因 Task execution failed 原因: Error executing process; ERROR at line 1264: Unknown command '\\'.Task 'Mysql resto
Task execution failed 原因: Error executing process;
ERROR at line 1264: Unknown command '\\'.Task 'Mysql restore' finished at Tue Feb 21 16:18:20 CST 20232023-02-21 16:18:20.906 - IO error: Process failed (exit code = 1). See error log.2023-02-21 16:18:20.907 - java.io.IOException: Process failed (exit code = 1). See error log.at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.validateErrorCode(AbstractNativeToolHandler.java:230)at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:210)at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:270)at org.jkiss.dbeaver.ext.mysql.tasks.MysqlNativeToolHandler.doExecute(MySQLNativeToolHandler.java:47)at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:76)at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39)at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
mysql 默认以 gbk 编码连接数据库,之前导出备份文件是 utf8 编码,编码不一致导致错误。
在执行脚本之前配置一下,加上指定编码执行即可。
--default-character-set=utf8mb4
来源地址:https://blog.csdn.net/liming1016/article/details/129144957
--结束END--
本文标题: 通过工具 DBeaver操作 MySQL导入备份的 sql 报错
本文链接: https://www.lsjlt.com/news/384247.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-06-06
2024-06-06
2024-06-05
2024-06-04
2024-06-04
2024-06-03
2024-06-03
2024-06-03
2024-06-04
2024-06-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0