Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error Code: 2006 – Mysql Server Has Gone Away

forums forums SQLyog Using SQLyog Error Code: 2006 – Mysql Server Has Gone Away

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #23988
      peterlaursen
      Participant

      “Error Code: 2006 – MySQL server has gone away”

      I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.

      Old server versions dispaly only that in this situation.  5.0.41 say “got a package too big” or something like that!

    • #23989
      jack111
      Member
      peterlaursen wrote on May 11 2007, 03:20 PM:
      “Error Code: 2006 – MySQL server has gone away”

      I think the most likely reason is that the (server) max_allowed_packet setting is too low compared to the size of BULK inserts in the file.

      Old server versions dispaly only that in this situation. 5.0.41 say “got a package too big” or something like that!

      Thanks that was exactly the problem. Followed the instructions below

      http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

      In Linux:

      Copy the my-xxx.cnf file from /usr/share/mysql to /etc as my.cnf

      xxx can be small, medium, large, huge … depending on the requirement.

      $ cp /usr/share/mysql/my-xxx.cnf /etc/my.cnf

      In the my.cnf file, change the default

      max_allowed_packet = 1M

      to

      max_allowed_packet = 16M

      Save the file and restart MySQL server.

      In Windows:

      In the MySQL server installation directory,

      in my.ini file, add the following line under [mysqld] in SERVER SECTION.

      max_allowed_packet = 16M

      Save the file and restart MySQL server.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.