Search code examples
mysqlsqldatabasesqldatatypes

MySQL longblob error "packet bigger than max..."

I'm trying to import a Wordpress Plugin database that stores files in the table using the longblob datatype. The database is on one server, so I exported it to import on another server, but have received various errors, the latest of which is "Got a packet bigger than 'max_allowed_packet' bytes".

Previously, these commands were run on the server: set global max_allowed_packet=10000000; and set global net_buffer_length=1000000; The server has been restarted since then.

Any ideas as to what would cause this? I'm fairly new to all of this, so I may not be providing all of the necessary information. Let me know if I need to clarify.

Thanks in advance for your time!

Solution

  • Set the variable in your my.cnf file. On linux you can find this at /etc/my.cnf and add the following line:

    max_allowed_packet = 64M

    Don't forget to restart mysql after you've made this change.