On Mon, Jun 04, 2001 at 06:51:39PM +0200, Warren van der Merwe wrote:
> database,sql
>
> Hi again
>
> I have some questions re: Replication
>
> My sites are all connected via a dial-up modem, so I have a program
> what once a day will dialup and connect Site A to Site B,
>
> 1. how do I get the slave to start updating right there on the spot without
> having to wait
Issue a "SLAVE START" command.
> 2. how do I know when the slave is finished, so that I can disconnect the
> dial-up line?
Compare the output of "SHOW MASTER STATUS" on the master with "SHOW
SLAVE STATUS" on the slave.
Have a look here for more fun replication stuff:
http://www.mysql.com/doc/R/e/Replication_SQL.html
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 11 days, processed 68,745,280 queries (71/sec. avg)
---------------------------------------------------------------------
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