Getting error in DBeaver mysql when try to import large sql database file
12,171
Solution 1
Just change connection setting from --host=localhost
to --host=127.0.0.1
.
It works for me.
Solution 2
Via right click DB > SQL editor > New SQL script
Execute following queries:
set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;
https://stackoverflow.com/a/18979736
Author by
Amira Elsayed Ismail
God put me on earth to accomplish a certain number of things, right now I am so far behind, I will never die.
Updated on December 21, 2022Comments
-
Amira Elsayed Ismail 11 months
C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe --host=localhost --port=3306 -u root nd7b265_rahetbally Task 'MySQL script' started at Sun May 31 09:53:09 MST 2020 ERROR 2013 (HY000) at line 118827: Lost connection to MySQL server during query Task 'MySQL script' finished at Sun May 31 09:53:13 MST 2020 2020-05-31 09:53:13.363 - IO error: Process failed (exit code = 1). See error log. 2020-05-31 09:53:13.363 - java.io.IOException: Process failed (exit code = 1). See error log. at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.executeProcess(AbstractNativeToolHandler.java:182) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.doExecute(AbstractNativeToolHandler.java:237) at org.jkiss.dbeaver.tasks.nativetool.AbstractNativeToolHandler.lambda$0(AbstractNativeToolHandler.java:52) at org.jkiss.dbeaver.runtime.RunnableContextDelegate.lambda$0(RunnableContextDelegate.java:39) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)
-
Dave over 3 yearsWhat does the MySQL error log show (if anything)?
-
-
Ivan Pirus almost 3 yearsYou helped me. But similar bug. In case exit code=2. I had. Thanks.
-
Alvaro about 2 yearswhere is the
[mysql]
section? thanks in advance :) -
Waleed Al Harthi almost 2 yearswhere is this section?
-
Ele almost 2 yearsThis worked for me.