Page 1 of 1

Syncronising databases

Posted: Tue Dec 24, 2002 6:17 am
by f1nutter
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.

Posted: Tue Dec 24, 2002 6:48 am
by evilcoder
Do you have phpMyAdmin installed?

If so, you can make dump files. Then just add the sql commands to your remote server.