logo
Founded on 2005 by thought leaders in technology & IT solutions, with a mission is to build new internet driven new India scale data driven security & web solutions and enable businesses and consumers to interact safely.

Web Site Security

Cloud Management

Email Solutions

Payment Options
You can deposit direct fund to our ICICI Bank account by Cheque or Cash through any ICICI Bank Branch or ATM in India :
Account Name: Abit India Group
Account No.: 018205002680
Bank Name: ICICI Bank Ltd.
NEFT IFSC Code: ICIC0000182
Swift Code: ICICINBBCTS
Branch: Nashik Road

More Option

22-65350500

204, Nagpal House off Link Road, Bandra, Mumbai

Top

simple 4 steps to solve Mysql server has gone away while importing large sql file

Netspaceindia / mysql  / simple 4 steps to solve Mysql server has gone away while importing large sql file

simple 4 steps to solve Mysql server has gone away while importing large sql file

Mysql server has gone away is a very common error which is simply mean the server (mysql) went offline while it was working on something.

This is most commonly noted on executing large sql dump file or running a complex query, in the article we will case one.

  1. Download SQLYog :
    SQLYog is a client side tool which I am using personally from long time. This help me to run query on my desktop directly in place of using famous phpmyadmin.
  2. locate my.cnf :
    The MySQL default configuration is not very great for production use. Some of the default values in my.cnf should be changed when you need it for business critical applications
    Location of my.cnf :

    • [su_code]sudo nano /etc/mysql/my.cnf[/su_code]
    • [su_code]/etc/my.cnf[/su_code]
    • [su_code]/etc/mysql/my.cnf[/su_code]
    • [su_code]SYSCONFDIR/my.cnf[/su_code]
    • [su_code]$MYSQL_HOME/my.cnf[/su_code]
    • [su_code]defaults-extra-file (the file specified with –defaults-extra-file=path, if any)[/su_code]
    • [su_code]~/.my.cnf[/su_code]
  3. edit my.cnf :
    find / add
    [su_code]wait_timeout = 600
    max_allowed_packet = 64M
    [/su_code]
  4. Restart MYSQL :
    now simply restart mysql using : [su_code]sudo /etc/init.d/mysql restart[/su_code]
Comments