Hello,
As per your suggestions I tried to get some correct solution for the
problem, but there is a big problem for replication and it is network
connection. Though Internet is available to the Mfg. Site, it is not having
good speed and continuous. So that replication may not be a good choice. As
Sorry maybe this is completly out of topic, but why do you need it to
synchronise in two locations, can't you just get both servers to connect
to the same database?
And then if you need you can set a cron to backup your database hourly
or daily to the other server using mysql dump and scp.
I
immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: Richard [EMAIL PROTECTED]
To: C K [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, August 05, 2007 4:01 AM
Subject: Re: MySQL database synchronizing from 2
Hello,
My client has a mfg. unit at 65 Km from a city in India. He wants to connect
to his corporate office in the city. Both offices will use same data and
same ERP system. He is using Win 2K3 server and MySQL 5.0.17. Is it possible
to make them synchronized at a particular or regular intervals?
MySQLDumps each night (depending on the volume).
It all depends on the degree and need for whatever level of
synchronicity.
Tim...
-Original Message-
From: C K [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 2:08 PM
To: mysql@lists.mysql.com
Subject: MySQL database synchronizing
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 2:08 PM
To: mysql@lists.mysql.com
Subject: MySQL database synchronizing from 2 locations
Hello,
My client has a mfg. unit at 65 Km from a city in India. He wants to
connect to his corporate office in the city. Both offices will use same
data