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

Sync Query Problem?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #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

    • #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

    • #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

    • #35762
      Sweens
      Participant

      Thanks for investigating, Sibin.

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