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

Share:
12,171
Amira Elsayed Ismail
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, 2022

Comments

  • Amira Elsayed Ismail
    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
      Dave over 3 years
      What does the MySQL error log show (if anything)?
  • Ivan Pirus
    Ivan Pirus almost 3 years
    You helped me. But similar bug. In case exit code=2. I had. Thanks.
  • Alvaro
    Alvaro about 2 years
    where is the [mysql] section? thanks in advance :)
  • Waleed Al Harthi
    Waleed Al Harthi almost 2 years
    where is this section?
  • Ele
    Ele almost 2 years
    This worked for me.