SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru bronze trophy
    Join Date
    Dec 2003
    Location
    Poland
    Posts
    925
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Simple tool for synchronizing tables?

    I'm looking for a simple tool to synchronize mysql tables. I simply want to keep my local db more or less (!) in sync with the remote db. I can't use replication because in many cases the databases are on shared hosting. I don't need to have an exact local copy of the remote db, I just need this tool to do the following:

    1. Check for primary keys on both the local and remote server and download (insert) only the missing rows. And delete the rows that are not present on the remote db.

    2. Even simpler: get the MAX() auto-increment value for both the local and remote tables, and download only the new rows that don't exist locally.

    I need this mainly for tables which store archival data (logs, history, reports, etc.) - they are the ones that grow the most and it is often not practical to make and recreate the whole dump every time a few more records have been added.

    I know there is SqlYog which can synchronize tables but I'm looking for something cheaper or free. My needs are simple so I could easily write my own script (in php) to do this but maybe someone has already made a tool like this? I need it to run in Windows.

  2. #2
    SitePoint Zealot
    Join Date
    Dec 2010
    Posts
    187
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was in need of similar tool, however all the ones that satisfied my needs are priced thousands of dollars so I ended up making my own. I suggest you do that too.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •