Divi WordPress Theme

MySQL restore problem - MySQL server has gone away error

Topic: MySQL restore problem - MySQL server has gone away error  (Read 1725 times)

Offline Web_news

  • New Member
  • *****
  • Premium Member
  • Posts: 44
  • iTrader: +5/-0
    • View Profile
MySQL restore problem - MySQL server has gone away error
« on: June 15, 2013, 11:00:53 AM »
Hi,

I am restoring one large Joomla database on my Linux VPS. Since it is large database, I migrated sql dump file (.sql) to my Linux VPS and trying to restore it via SSH. During restore it is giving me following error after some time:

ERROR 2006 (HY000) at line 17452: MySQL server has gone away

The sql backup was generated without any error. Am I missing something? Please help!

Thanks in advance!
VPS Hosting - AccuWebHosting

Offline Kailash

  • Web Hosting Master
  • *****
  • Administrator
  • Posts: 603
  • iTrader: +153/-0
    • View Profile
Re: MySQL restore problem - MySQL server has gone away error
« Reply #1 on: June 15, 2013, 11:22:48 AM »
It looks like you are hitting max packet size during restore. You need to edit your MySQL configuration file (my.cnf) to increase packet size. Add the following line in [mysqld] section and restart MySQL service:

max_allowed_packet = 32M

After restarting MySQL try again to restore your MySQL database.

- Kailash

Offline Web_news

  • New Member
  • *****
  • Premium Member
  • Posts: 44
  • iTrader: +5/-0
    • View Profile
Re: MySQL restore problem - MySQL server has gone away error
« Reply #2 on: June 15, 2013, 11:26:37 AM »
Thanks Kailash!
Divi WordPress Theme
Tags: