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

Restore From Sql Dump Error

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

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 27, 2009 at 8:21 am #11694
      AlanT
      Member

      I am using SQLyog Community Edition – v8.05

      Recently I used

      “Backup Database as SQL Dump” to backup my MySQL database 5.1 to a sql file.

      Now I want to restore from this sql file using “Restore from SQL dump”

      but got an error found in the sqlyog.err file:

      Error occured at:2009-09-27 18:02:30

      Line no.:777

      Error Code: 1153 – Got a packet bigger than 'max_allowed_packet' bytes

      These lines right after an insert statement of one of the tables has ~100,000 records.

      Any idea was this table caused the problem?

      I cannot opent the sql file inside SQLyog since SQLyog complained the file is too big to be opened inside SQLyog.

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