drumltd

Anybody know of an easy way to sync to MySQL tables, preferably using PHP.

The 2 Tables are on 2 different servers hundreds of miles apart, I don't have access to the MySQL ini files on one of the servers so can't set up master\slave etc. And the DB changes by about 10,000 records an hour do doing a record by record comparison in code could be very time consuming.

DaWei

Have you considered a professionally built tool? I would think it would be the economical approach. Here's one example Google turned up, about a hundred bucks (500 for a 'studio'):SQL Manager.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

drumltd

I had considered it, but if I can find a method of doing it that is economical with bandwith, then I would prefer to write a script so that I can run it on a regular basis.

DaWei

I don't know what the bandwidth skinny is, but they talk of it producing a script for future use....

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers