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

Sync Query Problem?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sync Query Problem?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 23, 2016 at 12:32 pm #35759
      Sibin A S
      Moderator

      Hi Chris,

       

      Can you please tell the total number of columns in the table that you have been trying to sync. Also tell us the SQLyog version and MySQL server version.

       

      Regards,

      Sibin

    • August 23, 2016 at 12:42 pm #35760
      Sweens
      Participant

      Thanks Sibin

       

      There are 79268055 records in the source and 79109275 in the destination.

       

      Using v12.2.4

       

      EDIT – Sorry, misread your post; there are only 10 columns in the table.

       

      (I am thinking I should dump the oldest records and just use that last 2 years!)

       

      Cheers

      Chris

    • August 23, 2016 at 2:43 pm #35761
      Sibin A S
      Moderator

      Hello Chris,

       

      We will try reproducing this with similar number of rows. Also you can dump the oldest records if they aren’t required for you as it also decreases the load on the server as well.

       

      Regards,

      Sibin

    • August 23, 2016 at 3:30 pm #35762
      Sweens
      Participant

      Thanks for investigating, Sibin.

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