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

Synch between 2 database

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Synch between 2 database

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • July 28, 2004 at 10:39 am #8513
      psykomo
      Member

      I've tried sqlyog to synch 2 database, and it works.

      But i need to generate the result of the synch above as SQL script, how?

      FYI, i use the windows version…

      Thanks

    • July 28, 2004 at 11:22 am #16126
      Shadow
      Member

      Do you mean getting all those INSERT, UPDATE, DELETE statements sja uses to sync the dbs? Currently you can't do that. You may try logging the SQL statements issued against a MySql server, though.

    • July 28, 2004 at 11:40 am #16127
      psykomo
      Member

      >Do you mean getting all those INSERT, UPDATE, DELETE statements sja uses to sync the dbs? Currently you can't do that. You may try logging the >SQL statements issued against a MySql server, though.

      Yes, that's exactly what i want.. getting all those insert, update and delete statements.

      You said about logging the sql statements, can you tell me how?

      Regards

    • July 28, 2004 at 4:32 pm #16128
      Ritesh
      Member
      Shadow wrote on Jul 28 2004, 11:22 AM:
      Do you mean getting all those INSERT, UPDATE, DELETE statements sja uses to sync the dbs? Currently you can't do that. You may try logging the SQL statements issued against a MySql server, though.

      This feature is already in the TO-DO list of SJA 😀

    • July 28, 2004 at 5:25 pm #16129
      psykomo
      Member

      When can we enjoy it? 😀

    • July 29, 2004 at 7:52 am #16130
      Shadow
      Member
      Quote:
      You said about logging the sql statements, can you tell me how?

      Turn on logging in mysql before the sync using log, log_bin or log_update options depending on the MySql's version and turn it off afterwards. Or enable logging all the time, track the start and finish of each sync session and get the needed data out of the log.

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