devinemke
4-18-02, 01:48 PM
Like many here, I adminstrate my MySQL db's with phpMyAdmin. I am running a webserver and PHP on my home machine for development. Whenever my online db is updated by users (I sell magazine subscriptions) I dump the online db into a text file (*.sql), blow out my local tables on my machine and then import the .sql into my local MySQL. This works fine but as the db grows the whole process gets slower and slower. Is there any program that can examine 2 db's, figure out which records have changed most recently and sync the 2 db's up without having to overwrite everything? What I'm really looking for is a "HotSync" type of program for MySQL (all you Palm Pilot users will know what I mean by HotSync).