Dicky Wahyu Purnomo wrote: > > 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
We are planning to migrate (to be precise). Where can I find the documentation on setting up replication? I could not find any or I may have overlook. -- +-------------------------------------+--------------------------------+ | Adrian Hoe | [EMAIL PROTECTED] | | Procrastination prevents creativity | [EMAIL PROTECTED] | +-------------------------------------+--------------------------------+ --------------------------------------------------------------------- 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