For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > September 2004 > Synchronizing databases









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Synchronizing databases
Ike

2004-09-26, 8:55 pm

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

2004-09-27, 8:55 am

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
>

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com