MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes

by

You probably have to change it for both the client (you are running to do the import) AND the daemon mysqld that is running and accepting the import.

For the client, you can specify it on the command line:

mysql --max_allowed_packet=100M -u root -p database < dump.sql

Also, change the my.cnf or my.ini file (usually found in /etc/mysql/) under the mysqld section and set:

max_allowed_packet=100M

or you could run these commands in a MySQL console connected to that same server:

set global net_buffer_length=1000000; 
set global max_allowed_packet=1000000000;

(Use a very large value for the packet size.)

More Related Contents:

  1. Get top n records for each group of grouped results
  2. Joining three tables using MySQL
  3. Join tables with SUM issue in MYSQL
  4. Troubleshooting “Illegal mix of collations” error in mysql
  5. How to import a CSV file into a MySQL table
  6. How to store arrays in MySQL?
  7. Create new user in MySQL and give it full access to one database
  8. MySQL high CPU usage [closed]
  9. Most efficient way to get table row count
  10. How do I select between the 1st day of the current month and current day in MySQL?
  11. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  12. MySQL Cross Server Select Query
  13. How do I generate nested json objects using mysql native json functions?
  14. Allow all remote connections, MySQL
  15. Import CSV to MySQL
  16. MySQL Install: ERROR: Failed to build gem native extension
  17. MySQL TEXT vs BLOB vs CLOB
  18. MYSQL syntax not evaluating not equal to in presence of NULL
  19. Getting data for histogram plot
  20. How accurately should I store latitude and longitude?
  21. MySQL: LAST_INSERT_ID() returns 0
  22. MySQL loop through tables
  23. What the difference between mysql and mysql2 gem
  24. XAMPP – Error: MySQL shutdown unexpectedly
  25. ERROR 1044 (42000): Access denied for ‘root’ With All Privileges
  26. MySQL LIMIT on DELETE statement
  27. Select all where [first letter starts with B]
  28. CakePHP – get last query run
  29. Why is connecting to MySQL server so slow?
  30. How to search and replace all instances of a string within a database?

Leave a Comment