Error: 2006 - MySQL server has gone away

[semtex]

Does anyone know what causes this problem?
I have a .sql backup file of a database. That database was deleted and now I want to set it up again. However it gives this strange error:
Error: 2006 - MySQL server has gone away

I don't know what causes it.

As you can see I have html code in my fields.

INSERT INTO structuur (s_ID, s_postnummer, s_gemeente, s_dichtste, s_werkloosheid, s_ledenbeheer, s_juridische, s_werkingen, s_algemenec, s_bediendenc, s_boekc, s_diamantc, s_kledingc, s_metaalc, s_openbarec, s_textielc, s_transportc, s_voedingc) VALUES (1, '8000', 'brugge', '<table width="100%"bgcolor="#FFFFFF" class="rand" cellspacing="0" cellpadding="0">\r\n<tr>\r\n<td>\r\n<table width="100%" border="0" cellspacing="0" cellpadding="2">\r\n <tr>\r\n <td colspan="3" valign="top" bgcolor="#E1DDC9" class="rand_onder"><b>Kantoor Brugge</b></td>\r\n </tr>\r\n <tr class="rand">\r\n <td valign="top"><b>Onthaal:</b></td>\r\n <td colspan="2">Lynda Casteleyn<br>\r\n Zilverstraat 43<br>\r\n \r\n \r\n 8000 Brugge<br>\r\n \r\n Tel. [phone]<br>\r\n \r\n Fax. [phone]<br>\r\n \r\n \r\n E-mail: <a href=mailto:[e-mail]>[e-mail]</a></td>\r\n </tr>\r\n <tr>\r\n <
Error: 2006 - MySQL server has gone away

Does anyone know how i can resolve this error?

[semtex]

Please does anyone have any idea? This is very urgent and any help would be deeply appreciated!

[[deleted]]

If you type that in a search engine you'll see hunderds of solutions.

Most likely your query is too large for mysql's settings. How are you trying to restore this backup?

[semtex]

I'm using a .sql (text) file to restore the database. I use the program called MYSQL-FRONT.
I load the text file into the query field and I just hit the GO button.

Is there any way to change the mysql settings so that the file will be accepted?

[[deleted]]

read this:
http://www.mysql.com/doc/en/Gone_away.html

[semtex]

You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M). The extra memory is allocated on demand, so mysqld will use more memory only when you issue a big query or when mysqld must return a big result row!

How do I do this? I looked through it yesterday but found no way to increase the max_allowed_packet. How e.g. do I start mysqld?

Thanks for the help so far.

[[deleted]]

Ugh... You have a database but you don't know how to start it?

That suggests that the database is not under your control. Maybe you should leave this to the sysadmin?

[semtex]

I know how to start it and I know how to work with phpmyadmin and mysql-front (basics). But i just don't know how to start with the -O max_allowed_packet=# option

[[deleted]]

How do you start it normally?

[semtex]

I just double click the icon on my desktop and hit connect to connect to my database. Then it opens the database. If i click on variables i can see all of them but I cannot change anything there.

[Ph0eniX]

Originally posted by semtex
I just double click the icon on my desktop and hit connect to connect to my database. Then it opens the database. If i click on variables i can see all of them but I cannot change anything there.

All I can say is: haha

[piersk]

Why "haha"?

[semtex]

mmm... thought a forum was for everyone that needed help. even people that have less experience with mysql.
i suppose you're not interested in helping me?

[Ph0eniX]

Originally posted by semtex
mmm... thought a forum was for everyone that needed help. even people that have less experience with mysql.
i suppose you're not interested in helping me?

Not that I can help you figure out why your server is crashing based on the little info you've provided in your post but I found the way you described how you start MySQL funny. That's all. I dind't mean to be disrespectful.

[[deleted]]

Nevermind, there's always some idiot who likes to thing he's cool by making stupid posts like that.

It's his own pathetic little way of making himself look good. Don't be angry at him, have pity.

Semtex: double-clicking the icon probably launches the binary that runs the actual mysql server. Most likely you can rightclick the icon and see the command it executes. If you're lucky you can just add the parameters right there in the 'shortcut'.

[Ph0eniX]

Originally posted by vincente
Nevermind, there's always some idiot who likes to thing he's cool by making stupid posts like that.

It's his own pathetic little way of making himself look good. Don't be angry at him, have pity.


Semtex: double-clicking the icon probably launches the binary that runs the actual mysql server. Most likely you can rightclick the icon and see the command it executes. If you're lucky you can just add the parameters right there in the 'shortcut'.

umm, okay ...who's the idiot now? ...just read my reply to semtex

why bring drama to a drama-free board?