Syncronising databases

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
f1nutter
Forum Contributor
Posts: 125
Joined: Wed Jun 05, 2002 12:08 pm
Location: London

Syncronising databases

Post 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.
evilcoder
Forum Contributor
Posts: 345
Joined: Tue Dec 17, 2002 5:37 am
Location: Sydney, Australia

Post by evilcoder »

Do you have phpMyAdmin installed?

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