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

Sync Data On Update

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sync Data On Update

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • September 12, 2007 at 8:42 am #10541
      energylevel
      Member

      Is it possibloe to sync data from two MySQL tables in separate database on when inserting/updating a record ?

      Thanks ………..

    • September 12, 2007 at 9:37 am #24955
      peterlaursen
      Participant

      Not with SQLyog.

      Maybe a TRIGGER can be used (but I cannot figure out exactly how to write it – also depends on what exactly should happen) and maybe MySQL-PROXY can handle it.

      Also the table could be a FEDERATED table.

      TRIGGERS and FEDERATED tables are only possible with MysQL 5.x and 6.x.

      But basically I think that having tables with dublicate data is a bad design!

    • September 12, 2007 at 9:40 am #24956
      peterlaursen
      Participant

      But of course you can schedule SJA data sync to execute on short intervals like 2 mins, 5 mins.

      The job only need to include that single table.

    • September 12, 2007 at 11:06 pm #24957
      energylevel
      Member

      Just to clarify, I've added a PHPBB forum to a site, the site already has a members area so I wanted to sync the existing username and passwords data with the PHPBB forum database. Easy enough to do a sync for existing members but I need some kind of automation to handle new signups or people changing their password

      Thanks …………

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