Problem: Error: 2006 - MySQL server has gone away

[Guest_imported]

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=&quot;100%&quot;bgcolor=&quot;#FFFFFF&quot; class=&quot;rand&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot;>\r\n<tr>\r\n<td>\r\n<table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;0&quot; cellpadding=&quot;2&quot;>\r\n <tr>\r\n <td colspan=&quot;3&quot; valign=&quot;top&quot; bgcolor=&quot;#E1DDC9&quot; class=&quot;rand_onder&quot;><b>Kantoor Brugge</b></td>\r\n </tr>\r\n <tr class=&quot;rand&quot;>\r\n <td valign=&quot;top&quot;><b>Onthaal:</b></td>\r\n <td colspan=&quot;2&quot;>Lynda Casteleyn<br>\r\n Zilverstraat 43<br>\r\n \r\n \r\n 8000 Brugge<br>\r\n \r\n Tel. 050/44.10.10<br>\r\n \r\n Fax. 050/34.21.60<br>\r\n \r\n \r\n E-mail: <a href=mailto:brugge.ont@abvv-wvl.be>brugge.ont@abvv-wvl.be</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?

 

[piti]

this, as i remember, could be caused by a large query - large means exceeding the value in a variable that has something to do with the packet size (don't know the name :-(), the dafault is 1mb

 

[piti]

so there is a special page on the mysql site dedicated to this error

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