At 11:48 -0500 3/11/03, Daniel Negron/KBE wrote:
I have set up replication and have it working properly for the most part.
If I update the master the slave follows suit. But my slave is a laptop,
that I use for testing but would like that data to stay up to date withthe
master. Overnight if 'live changes take place on the Master, while the
slave is not connected,
How to I sync up the slave ? (without dumping the db or creating a
snapshot)
mysql - master = 3.23.33
mysql - slave = 3.23.52
It shouldn't matter. Slave servers retry occasionally when the connection
breaks. There are startup options you can use to set the number of retries
and the interval between them.
Thank you,
-----------------------------------------------------------
--------- Daniel Negron
// \\ *****************
/ _ __ ___ \ Lotus Notes Admin / Developer
| | |/ /| _ ) | KB Electronic, Inc.
| | ' < | _ \ | 12095 NW 39th Street
| |_|\ \|___/ | Coral Springs, FL. 33065
\ \_\ / 954.346.4900 x 122
\\ // email: [EMAIL PROTECTED]
--------- http://www.kbelectronics.com
-----------------------------------------------------------
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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
