max_allowed_packet

[Barakat]

hi ,

i was trying to restore my database but i found this error

ERROR 1153 (08S01) at line 11649: Got a packet bigger than 'max_allowed_packet' bytes


in my server i dont have my.cnf .....

i just have php.ini

how can i increase the value or where can i find the max_allowed_packet ?

 

[chatwizrd]

It is a mysql setting.

I suggest you follow this and create a my.cnf

http://help.directadmin.com/item.php?id=44

You can raise and lower the setting as needed then.

 

[Barakat]

thanks a lot it works

but there are two allow_max_packet

i add them and works fine ...................................

thanks again for ur help

 

[ukrppf]

I do have my.cnf

It is a mysql setting.

I suggest you follow this and create a my.cnf

http://help.directadmin.com/item.php?id=44

You can raise and lower the setting as needed then.

I do have my.cnf and I did add the setting for max_allowed_packet, trying 16 and 32. According to mysql's site - if I read correctly - this is now being ignored in the current version of mysql, even if you have it set in my.cnf.

I have a drupal module that wants more than 1 MB. In fact, it recommends at least 11 MB. Is there a place that can be changed that will actually force mysql to recognize 11 MB?

Here's the text from the module:

Warning: This server has the database max_allowed_packet limited to 1 MB . Due to a limitation of the batch process, this is likely to cause problems on huge imports (several thousands of pages at once).
If you can, please increase it in your database config (my.cnf). At least 11 MB is recommmended. See MySQL docs, If you can't, then set the advanced option 'Recursion behaviour' to 'recurse after' and try to import your site only a few thousand pages at a time.

 

[nobaloney]

I'm neither a Drupal expert nor a MySQL expert, but just from reading your post it appears you've found the answer in the Drupal module text.

Jeff