max_allowed_packet Drupal MySQL error

Category: Drupal

Frontline
Asked:
2012-05-07 10:23 pm EST

Hits: 1,936
I'm attempting to migrate a drupal database from GoDaddy. I get the error indicating that max_allowed_packet is too small. Please increase. I do not at this time wish to do this myself with root access.
Error
Error
SQL query:

INSERT INTO `cache_field` (`cid`, `data`, `expire`, `created`, `serialized`) VALUES ('field:node:37', 0x613a313a7b733a343a22626f6479223b613a313a7b733a333a22756e64223b613a313a7b693a303b613a333a7b733a353a2276616c7565223b733a3631343839373a223c21444f43545950452068746d6c205055424c494320222d2f2f5733432f2f445444205848544d4c20312e30205472616e736974696f6e616c2f2f454e222022687474703a2f2f7777772e77332e6f72672f54522f7868746d6c312f4454442f7868746d6c312d7472616e736974696f6e616c2e647464223e0d0a3c68746d6c20786d6c6e733d22687474703a2f2f7777772e77332e6f72672f313939392f7868746d6c22203e0d0a3c686561643e0d0a202020203c7469746c653e556e7469746c656420506167653c2f7469746c653e0d0a202020203c7374796c6520747970653d22746578742f637373223e0d0a0d0a68320d0a097b6d617267696e3a2031322e3070742030696e3b0d0a202020202020202020202020706167652d627265616b2d61667465723a61766f69643b0d0a092020202020202020666f6e742d73697a653a32302e3070743b0d0a092020202020202020666f6e742d66616d696c793a2243616c69627269222c2273616e732d7365726966223b0d0a0[...]

MySQL said:

#1153 - Got a packet bigger than 'max_allowed_packet' bytes

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

BradM
Staff
5,399 Points
2012-05-08 8:24 am EST
Hi Frontline,

I can see based on the notes on your account that our Tier2 department was able to upgrade your max_allowed_packet value. If you don't have root access to your server, you would need to contact our Support Department for assistance with updating this value.

max_allowed_packet is currently set to 5M. If this hasn't resolved the issue at hand, feel free to post a comment at the bottom of this page and we'll be more than happy to assist further.

Thanks!
- Brad

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!