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

Data sync wipes data out!

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Data sync wipes data out!

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • December 12, 2003 at 5:09 pm #8274
      jdobbs
      Member

      Hi,

      I've notced if I do a data sync from db1 to db2. Any data in db2 which is not in db1 is deleted. Is there a way to append data to a db when doing a data sync?

      Thanks,

      Jason

    • December 13, 2003 at 7:55 am #15349
      Shadow
      Member

      As far as I'm concerned, no. DB1 is the 'master', therefore DB2 is completely synced with it. Ritesh has already promised a two-way sync to be implemented in the future.

      You may want to check MySql's built-in replication function! The user commented version of MySql manual contains an example of setting up a db as master and slave in the same time.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.