heya, sorry I was on phone :P
we have a test server with a recent db dump of the live server, for testing purpose. so we don't have a full db syncing between those 2 separate db, but we do have the test db's items table synced with the live db (the process is basically the same for 1 table or a full db anyways).
this is to avoid editing items on the live db, which causes the "naked bug".
the syncing is pretty simple. we use Navicat on the live server and have a remote connection from there to the test db. this way, in Navicat, you can provide two separate db as the source of the (one way) sync.
so in our example, we edit items on the test db for days, then before a live server reboot, I simply start an item table syncing between the test and the live db and the changes go live on the live server after reboot.
I might be a bit confusing, because english isn't my mother language so I appologize. Let me know if I can help you with anything else tho.
__________________
|
Threaded Mode
