Syncronising databases
Posted: Tue Dec 24, 2002 6:17 am
I have two MySQL databases, one on my home/development machine, and one with my host.
The db on my home machine has the most up-to-date info, and I would like to update my hosts db when I make changes on my home PC when I connect to the internet (it doesn't need to be automatic). For example, I might add in a stack of data and would like to insert the data into the remote db with the new information, or maybe I found several mistakes and would like to update the remote db.
I don't want to do this for the whole database, just selected tables.
Any ideas?
Thanks.
The db on my home machine has the most up-to-date info, and I would like to update my hosts db when I make changes on my home PC when I connect to the internet (it doesn't need to be automatic). For example, I might add in a stack of data and would like to insert the data into the remote db with the new information, or maybe I found several mistakes and would like to update the remote db.
I don't want to do this for the whole database, just selected tables.
Any ideas?
Thanks.