Synchronizing databases

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

mysqlhotcopy command=20

"Ike" <rxv@hotmail.com> wrote in message =
news:6oJ5d.1204$ls6.518@newsread3.news.atl.earthlink.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.
>=20
> 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.
>=20
> 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.
>=20
> Does such a procedure exist? Thanks, Ike
>=20
>=20
>