ServerTune Logo Control Panel Licenses Server Management VPS Dedicated Servers Colocation ServerTune.com
 
ServerTune HomeAbout usContact usHelp DeskKnowledgebaseSpecialLIVE Chat ServerTune
DirectAdmin VPS Server Management

Our most popular service:

Dedicated Server Hosting

Dedicated Servers: starting $89 /month

 

Issues, Tips, and Solutions

Click here to tour ServerTune's Data Center and view photos from the conferences we attended.

*** Follow ServerTune on: ServerTune is on Facebook ServerTune is on Twitter

 
 
Browse by category   Search
 


Got a packet bigger than 'max_allowed_packet' bytes
Printer Friendly
email to a friend
Email to friend
Add comment Add comment
Views: 2340
Votes: 0
Comments: 0
Posted: 19 Jan, 2008
by: Customer Service :: S.
* * * * *
Updated: 19 Jan, 2008
by: Customer Service :: S.
If you get this error when trying to dump a MySQL DB, this is due to the packet limit of MySQL server (more details from MySQL documentation at: http://dev.mysql.com/doc/mysql/en/packet -too-large.html . To solve this issue, add an extra entry into /etc/my.cnf file under [mysqld] group:
    max_allowed_packet = 100M

This will reset the limitation to 100Mb for file insertion into blob type (or longblob) column. Then restart mysql server:

  • /sbin/service mysql restart
Other articles in this Category
document I see hundreds of mysql-bin.00xxxxxxx files in /var/lib/mysql directory. What are these files?
document Starting MySQLCouldn't find MySQL manager or server
document How can I check if query cache is working on my MySQL server?
document HowTo :: commands, statements, and clauses
document HowTo :: change MySQL root password
document MySQL :: HowTo fix Access-Denied Errors
document Warning: MySQL server has gone away
document Error :: Can't connect to [local] MySQL server



RSS

Control Panel Licensing
cPanel Plesk Miva Merchant