Hi All, I have a local MySQL db (4.0.12) which I use for developing content for my web site, and my remote website MySQL db (3.23.56) which powers my site.
I spend a fair amount of time synching individual records from my local db to my remote db (i.e. either inserting them into the remote db or updating them if they already exist and I have released changes to the record(s) in question) and I have written a fairly complex (for me) PHP script that handles this. But I'm wondering if I'm overlooking something simpler? I'm not really looking for replication, because I don't want all of the local content to be replicated to the remote db, only those records I release for actual publication. I'm wondering more along the lines of if there's a way to feed an insert statement run against my remote db in a window in SQLYog (3.11, the GUI I currently use) using data returned from a select statement run against my local db? Something conceptually like: INSERT INTO `remotedb`.`tbldata` SELECT * FROM `localdb`.`tbldata` WHERE recid=9999 Any help appreciated! Much warmth, Murray http://www.planetthoughtful.org Building a thoughtful planet, one snide comment at a time... * Worried that you might have missed something amazingly amazing on PlanetThoughtful? * Join the newsletter and then you'll know for certain you haven't! * http://www.planetthoughtful.org/html/ptnewsletter.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
