Synchronizing databases

[Ike]

I have a MySql database which I
need to co-exist with another MySql database in order to get this one job
wherein the fields of the other database can map to fields in my database.

For example, they have a customers table as does mine. There may be some
differences in the fields and such, but, in broad strokes, the tables are
redundant.

I cannot, however, rewrite this application to use their format - both
tables need to coexist. So I am wondering if there is not an accepted means
to monitor changes in one database/table and forward those changes to the
other database/table on an ongoing and real-time basis.

Does such a procedure exist? Thanks, Ike

[Newsgroup Poster]

mysqlhotcopy command

"Ike" <rxv@hotmail.com> wrote in message news:6oJ5d.1204$ls6.518@newsread3.news.atl.earthli nk.net...

> I have a MySql database which I
> need to co-exist with another MySql database in order to get this one job
> wherein the fields of the other database can map to fields in my database.
>
> For example, they have a customers table as does mine. There may be some
> differences in the fields and such, but, in broad strokes, the tables are
> redundant.
>
> I cannot, however, rewrite this application to use their format - both
> tables need to coexist. So I am wondering if there is not an accepted means
> to monitor changes in one database/table and forward those changes to the
> other database/table on an ongoing and real-time basis.
>
> Does such a procedure exist? Thanks, Ike
>
>
>