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 1 reply thread
  • Author
    Posts
    • April 12, 2010 at 2:26 am #11940
      AlanT
      Member

      SQLyog Community Edition v8.05

      MySQL 5.1

      I got the backup SQL file from another SQLyog machine at home.

      Now tried to restore from this file to another machine at work, both are MySQl 5.1.

      When I started the restore, processed in the middle (some tables are completed), got an error and then opened the sqlyog.err file, the error is:

      Error occured at:2010-04-12 09:28:31

      Line no.:826

      Error Code: 2006 – MySQL server has gone away

      I am confused what this error is about?

      I tried few times laters and got the same error.

      Any idea?

    • 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 1 reply thread
  • You must be logged in to reply to this topic.