bin-log in 'needed' for a server to act as a master. This will make the server log all it's queries for the slave to follow. Don't know of a faster way.
Regards, Bhavin. ----- Original Message ----- From: "Vicky Gonzalez" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 03, 2002 4:54 PM Subject: changing a slave to a master in mysql replication Currently to make a slave a master, the docs say you need to set the bin-log option in my.cnf on the slave, and that will make the transition to master quicker. I know I can manually change a slave to a master by stopping the slave process, stop mysql, take a snapshot of the databases, copy over a new master my.cnf, make sure I have granted rights to a user for the "old" master to return as a slave, and restart. My question is how does having the bin-log option on the slave actually help this process? Or is there an easier way to convert a slave to master using the log position that I missed? Thanks in advance for any help. ~Vicky --------------------------------------------------------------------- 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