Local database and Remote Database

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
winsonlee
Forum Commoner
Posts: 76
Joined: Thu Dec 11, 2003 8:49 pm

Local database and Remote Database

Post by winsonlee »

Remote database is connected through odbc connection and the local database i am currently using is mysql.
For the time being all the data is stored in the remote database.

1) i would want to copy only data that is not found in local database from the remote database. Is there anyway i can do that ??
For example the remote database contain table A and the local database contain table A as well.
Currently both table contain 100 records.
If 3 new record is added to table A at the remote database, i would want this record to be updated in table A on the local database as well.
how can i make a query to compare table A in remote database with table A on the local database and copy those records that are not found in the local database ??
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

You can use a 3rd party application to do this.

SQLyog i know for a fact will do what you are asking
Post Reply