Mysql Server Has Gone Away

[Sami]

Dear SQLyog developers & forum members!

I have used SQLyog to backup my database, it worked, and did an sql dump, but when I wanted to restore that, I had this error:

Quote:

Line no.:2810

Error Code: 2006 – MySQL server has gone away

I opened the sql dump, and I aparted the long INSERT lines, to new queryes, and it works, but i have done it to 40%, there are a LOTS OF DATA;

What can I config in mysql config files ? I googled this problem, so I find this thing:

Quote:

Increase your max_allowed_packet value

I have did it in files:

Quote:

my-huge.ini

my-innodb-heavy-4G.ini

my-large.ini

my-medium.ini

my-small.ini

my-template.ini

So, you see I have installed mysql to windows;

in my.ini I have no max_allowed_packet line, in other files I setted to 64MB (max_allowed_packet = 64M);

Some errorous lines in the atachment (don't see what is it, it is a locales file, especially those lines are russian)

So what can I do for restore my old data ? What config values must I rewrite ? Please help me, i hate breaking queryes, because it is toooooooooooo long procedure :S

[peterlaursen]

In your MySQL server configuration file enter in the [mysqld] section

Code:

max_allowed_packet = 16 M

.. for example and restart MySQL

links:

1) http://www.webyog.com/blog/2009/12/05/sqlyog-mysql-gui-8-2-introduces-data-type-optmizer-and-licensing-changes/

“A calculation error could cause export tools to create BULK INSERT statements larger than specified by user.”

2) http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/

“The situation is that if a client sends a SQL-statement longer than the server max_allowed_packet setting, the server will simply disconnect the client. Next query from the same client instance will find that the ‘MySQL server has gone away’.”

[Sami]

Ohh…. I must use this theory: “If it isn't there, add there!”

Thanks the support, it is done 🙂

[Author]

Posts