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

What is 'max_allowed_packet' ?

forums › forums › SQLyog › Using SQLyog › What is 'max_allowed_packet' ?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 15, 2004 at 2:29 pm #8464
      GluedToTheScreen
      Member

      I exported a database as batch scripts… and then tried to execute it on a backup (development) database. It throws this error:

      Error : Got a packet bigger than 'max_allowed_packet'

      What does this mean? How do I correct it?

    • June 15, 2004 at 3:06 pm #15937
      Ritesh
      Member

      Information on “max_allowed_packet” can be found at http://dev.mysql.com/doc/mysql/en/Packet_t…_too_large.html

      If you have lot of data in a table, uncheck the option – Create bulk insert statements

    • June 16, 2004 at 2:39 pm #15938
      Shadow
      Member

      This parameter restricts the size of data affected by a single insert or update statement. If you try to upload a 1MB jpg picture to your db, but your max_allowed_packet is set to 512KB then the attempt will fail. Set this parameter to the largest possible insert/update size (or to the largest WANTED insert/update size).

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.