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

Restore From Sql Dump Problem

forums › forums › SQLyog › Using SQLyog › Restore From Sql Dump Problem

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • April 12, 2010 at 3:38 am #30734
      peterlaursen
      Participant

      This is because the 'max_allowed_packet' stting on the two servers are different.  There are BULK INSERTs too large for the server where you restore.  I have writen a bout the problem in our Blog:

      http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet/

      Os raise the setting by entering the line

      Code:
      max_allowed_packet = 16M 

      .. for instance in the server configuration file (my.ini/my.cnf) and restart the server for the change to take effect.  Or define a BULK size not too large when exporting.

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