On Wed, 03 Apr 2002 18:53:00 +0800
Adrian Hoe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My department is migrating our application from MySQL-3.22.x to 3.23.49.
> I am
> interested in the new replication function and I have question about
> using this replication facility.
>
> Let say I have Database_A at Site A and Database_B at Site B. I wish to
> replicate both Database_A and Database_B to a server at Site C. Site A
> is not connected to Site B and are separate network and Site A and B are
> connected to Site C on a dial-up (dial on demand basis) line. Can I do
> the replication? The replication is on scheduled basis, say daily.
>
You can do the replication, but from what you said, it's not replication that you need.
because usually replication is used for "real-time" sync data.
If you want to do it daily, you can :
1. set the my.cnf with Master and Slave setting properly
2. just do "load table XXX from master" for each table
or also you can do "hard way", just use :
--> rsync or ftp or scp ... and after that do mysql repair table action ...
--
Let's call it an accidental feature.
-- Larry Wall
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
