Hi, Just wanted to check something from the documentation. The recommended procedure for removing the bin logs on the master is
On each slave server, use SHOW SLAVE STATUS to check which log it is reading. Obtain a listing of the logs on the master server with SHOW MASTER LOGS. Determine the earliest log among all the slaves. This is the target log. If all the slaves are up to date, this will be the last log on the list. Make a backup of all the logs you are about to delete. (The step is optional, but a good idea.) Purge all logs up to but not including the target log. When I do a show slave status, I should be looking at the Master_Log_File field ? Thanks. Marvin Wright Flights Developer Lastminute.com [EMAIL PROTECTED] +44 (0) 207 802 4543 ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ********************************************************************** ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
