How to change max_allowed_packet size

by

Change in the my.ini or ~/.my.cnf file by including the single line under [mysqld] or [client] section in your file:

max_allowed_packet=500M

then restart the MySQL service and you are done.

See the documentation for further information.

More Related Contents:

  1. convert mysql query to laravel query builder
  2. How do you use MYSQL in ColdFusion? [closed]
  3. How can I return pivot table output in MySQL?
  4. Using backticks around field names
  5. How to find similar results and sort by similarity?
  6. Join tables from two different server
  7. Insert into multiple tables in one query
  8. generate_series() equivalent in MySQL
  9. MySQL: Can’t create table (errno: 150)
  10. Mysql query to dynamically convert rows to columns
  11. Why does MySQL report a syntax error on FULL OUTER JOIN?
  12. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  13. Mixing ANSI 1992 JOINs and COMMAs in a query
  14. In Apache Spark 2.0.0, is it possible to fetch a query from an external database (rather than grab the whole table)?
  15. Copy/duplicate database without using mysqldump
  16. How to see indexes for a database or table in MySQL?
  17. MySQL variable format for a “NOT IN” list of values
  18. Order by COUNT per value
  19. Exporting a table from Amazon RDS into a CSV file
  20. How to get database structure in MySQL via query
  21. Let MySQL users create databases, but allow access to only their own databases
  22. MySQL JOIN with LIMIT 1 on joined table
  23. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  24. How can I import a database with MySQL from terminal?
  25. Remove DEFINER clause from MySQL Dumps
  26. MySQL Error: #1142 – SELECT command denied to user
  27. Encryption at rest and/or AES_ENCRYPT
  28. For homebrew mysql installs, where’s my.cnf?
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment