MySQL Server gone away while inserting or deleting


Try to add this line in [mysql] in my.cnf

max_allowed_packet = 16M

Related Posts

  • 59
    90% of the time, this error is due either to the MySQL Server not running, or else firewall configuration on the Windows server blocking access on port 3306 (or whatever port your MySQL instance is configured to use). Error: 2003 (CR_CONN_HOST_ERROR) Message: Can't connect to MySQL server on '%s' (%d)
    Tags: mysql, server, error
  • 43
    Birth Of MySQL MySQL started out with the intention of using the mSQL database system to connect to tables using fast low-level (ISAM) routines. However, after some testing, They conclude that mSQL was not fast enough or flexible enough. This resulted in a new SQL interface to our database but with…
    Tags: mysql, server
  • 42
    MySQL Server has several logs that can help you find out what activity is taking place. By Default , No Logs are enabled in MySQL. By default, the server writes files for all enabled logs in the data directory. Logs can be flush by Issuing FLUSH LOGS statement. Binary log…
    Tags: server, error, mysql
  • 41
    Login to mysql and run the below command: set global net_buffer_length=1000000; set global max_allowed_packet=1000000000;
    Tags: max_allowed_packet, mysql, error
  • 40
    If you get a too many connections error,Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR), when you try to connect to the mysqld server, this means that all available connections are in use by other clients. To increase the concurrent connections what are allowed to connect to the server, change the max_connections system…
    Tags: server, error, mysql

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: