When uploading *.sql backup getting error #2006 Mysql gone away

[joshirahul84]

Please help me....

When uploading *.sql backup getting error #2006 Mysql gone away

[MRatWork]

Upload using panel or application?.  How big this sql file?.

[joshirahul84]

Its 18mb file. When uploading directly from kloxo panel restore option in database its uploading but not completing.

So i have tried with phpmyadmin, With this when i have uploaded again i received message #2006 mysql gone away and stop with that table in which big data is there.

check attached image.

[MRatWork]

Upload this file in /tmp directory (go to 'admin > servers > localhost > file manager'). Better in zip format.

And then open phpmyadmin (go to 'admin > sgl manager') and click export and select file from '/tmp' dir.

[joshirahul84]

I have already done that with using ur older post.

But still same error coming #2006 Mysql gone away.

Please help me...

[MRatWork]

Try add 'max_allowed_packet=128M' under '[mysqld]' in '/etc/my.cnf.d/server.cnf'. After that, restart mysql with 'sh /script/restart-mysql'.

[joshirahul84]

Its Work.... Thanks for the Help......