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

Executing Batch Scripts

forums forums SQLyog SQLyog: Bugs / Feature Requests Executing Batch Scripts

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #8133
      Salk
      Member

      Hi Guys,

      Please can you assist with this error I am getting.

      Error : Got a packet bigger than 'max_allowed_packet'

      While trying to execute a batch file.

      I tried to look for a option to change the 'max_allowed_packet' – but not sure if it is MySQL directive or SQLyog.

      Cheers

      Steven

    • #14787
      Shadow
      Member

      It is a MySql parameter.

      Quote:
      A communication packet is a single SQL statement sent to the MySQL server or a single row that is sent to the client. When a MySQL client or the mysqld server gets a packet bigger than max_allowed_packet bytes, it issues a Packet too large error and closes the connection.

      Try setting max-allowed-packet parameter in the my.ini or my.cnf file to a larger value. In 3.23 the max allowed value is 16MB, while from 4.* on the physical memory of your machine limits its size.

    • #14788
      Salk
      Member

      Thanks a stax shadow 🙂

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