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

Cannot Sync

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Cannot Sync

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • January 19, 2007 at 10:25 pm #10138
      nets
      Member

      Hi, I have 2 Mysql servers, one on WinXPpro and another on linux

      versions 5.0.27-community-nt and 4.1.21-standard on Linux,

      I'm trying to sync from a 3rd PC running XP, using Yog version 4.05

      in the beginning, when I had MySQL v. 5.0.0a on first server, sync was working partially since I had 1 table which did not have a PK,

      and was crashing mysql server, so I was using separate sync jobs for some tables and using drop table then sync for the table without PK…

      but since I upgraded to stable version 5.0.27-community-nt, I cannot sync at all,

      although I can truncate and then insert using command line batch file with success, plus I see no difference in structure, with EXPLAIN on both servers, after the tables are identical.

      this is the result I get with Yog when tring to sync the Identicals.

      Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

      Sync started at Fri Jan 19 15:51:47 2007

      Table SrcRows TgtRows Inserted Updated Deleted

      ========================= ======= ======= ======== ======= =======

      NULL definition mismatch for 'date_created' column in '`members`' table

      Check C:Program FilesSQLyog Enterprisesja.log for complete error details.

      Total time taken – 4 sec(s)

      *********

      my question is:

      is there any limitations in Yog version 4.05?, an if I upgrade to ver 5.22 Am I still going to have same problem?

      any help?

    • January 20, 2007 at 6:20 am #23271
      peterlaursen
      Participant

      “NULL definition mismatch for 'date_created' column in '`members`' table”

      We did fix several issues with Sync of time/type variables across different MySQLversion between your program version and 5.22.  We are not aware of any issue when syncing 4.1.x to/from 5.0.x

      Why don't you try out the TRIAL?

    • January 20, 2007 at 6:22 am #23272
      peterlaursen
      Participant

      Also read: http://webyog.com/faq/11_68_en.html

    • January 20, 2007 at 8:34 pm #23273
      nets
      Member
      peterlaursen wrote on Jan 20 2007, 01:20 AM:
      “NULL definition mismatch for 'date_created' column in '`members`' table”

      We did fix several issues with Sync of time/type variables across different MySQLversion between your program version and 5.22.  We are not aware of any issue when syncing 4.1.x to/from 5.0.x

      Why don't you try out the TRIAL?

      Well, I'm trying to download, but the link kicks me back to the home page….and it's not my browser, tried both with IE and Firefox

    • January 22, 2007 at 5:51 am #23274
      peterlaursen
      Participant

      link is fixed now

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