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

Problem with sync.

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Problem with sync.

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • April 20, 2005 at 12:33 pm #8925
      neavilag
      Member

      Hi all, made some test wit sync. with a small database and worked fine, now that what it to use it with a large database, this problem arises,

      Quote:
      Error No. 2013

      Lost connection to MySQL server during query

      Could not get FIELD information for '`problema`' in the TARGET database

      Sync started at Tue Apr 19 22:26:50 2005

      The target database was copied 3 days ago as a binary (copy the db directory from 1 server to the other, one server source is linux, target is windows) is just with 1 table the problem but is the big one (8 million records)

      I look both structures for that table are identical in source and target, the table pk is a autonumber…

      thanks

      Norman

    • April 20, 2005 at 2:35 pm #17470
      peterlaursen
      Participant

      Is the server configuration under your control ?

      It could be a problem with the value of the MAX-ALLOWED_PACKET variable in the MySQL server configuration file (my.cnf/my.ini) being too small.

    • April 20, 2005 at 11:19 pm #17471
      neavilag
      Member

      Thanks for your answer peter..

      I have access, are you refering to the source or target server ?

      Regards

      Norman

    • April 20, 2005 at 11:28 pm #17472
      neavilag
      Member

      Peter:

      The row is not that big, but the difference from source to target was about 50K records. could this be the prob???

      Regards

    • April 21, 2005 at 1:19 am #17473
      Ritesh
      Member

      Probably this will help http://dev.mysql.com/doc/mysql/en/gone-away.html

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