MySQL Purge Binary Logs - Revision history

Michael Kohler: Michael Kohler moved page MYSQL Purge Binary Logs to MySQL Purge Binary Logs without leaving a redirect

2013-09-30T16:23:50Z

Michael Kohler moved page MYSQL Purge Binary Logs to MySQL Purge Binary Logs without leaving a redirect

← Older revision	Revision as of 16:23, 30 September 2013
(No difference)

2013-02-21T17:05:35Z

← Older revision		Revision as of 17:05, 21 February 2013
Line 18:		Line 18:
	# [http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html MySQL Reference Guide - PURGE BINARY LOGS Syntax]		# [http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html MySQL Reference Guide - PURGE BINARY LOGS Syntax]

			[[Category:Software]]
	[[Category:MySQL]]		[[Category:MySQL]]

2012-07-26T12:02:35Z

← Older revision		Revision as of 12:02, 26 July 2012
Line 1:		Line 1:
	# Change to the directory containing the binary log files.		# Change to the directory containing the binary log files.
	## ~~Note the last time on the first to newest~~ mysql-~~bin~~.######, ~~use that time for~~ the ~~purge binary logs before command~~.		# Login to the all slave servers.
	# ~~Flush~~ the logs.		## <tt>'''# mysql -p -uroot'''</tt>
			### Check which log file it is reading.
			#### <tt>'''mysql> SHOW SLAVE STATUS;'''</tt>
			### Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
			# On the master server, flush the logs.
	## <tt>'''# mysqladmin flush-logs -p -uroot'''</tt>		## <tt>'''# mysqladmin flush-logs -p -uroot'''</tt>
	# Login to ~~MySQL~~.		# Login to the master server.
	## <tt>'''mysql -p -uroot'''</tt>		## <tt>'''# mysql -p -uroot'''</tt>
			### Obtain a listing of the binary log files.
			#### <tt>'''mysql> SHOW BINARY LOGS;'''</tt>
			# Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
	# Purge the binary logs.		# Purge the binary logs.
	## <tt>'''mysql> ~~purge binary logs before~~ 'yyyy-mm-dd hh:mm:ss''''</tt> (note: the seconds is optional)		## <tt>'''mysql> PURGE BINARY LOGS BEFORE 'yyyy-mm-dd hh:mm:ss';'''</tt> (note: the seconds is optional)

	== Further Reading ==		== Further Reading ==

2012-07-26T11:53:22Z

← Older revision		Revision as of 11:53, 26 July 2012
Line 8:		Line 8:
	## <tt>'''mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss''''</tt> (note: the seconds is optional)		## <tt>'''mysql> purge binary logs before 'yyyy-mm-dd hh:mm:ss''''</tt> (note: the seconds is optional)

			== Further Reading ==
			# [http://dev.mysql.com/doc/refman/5.5/en/purge-binary-logs.html MySQL Reference Guide - PURGE BINARY LOGS Syntax]

	[[Category:MySQL]]		[[Category:MySQL]]

2012-07-26T11:51:16Z

@@ Line 1: / Line 1: @@
 # Change to the directory containing the binary log files.
-# Flush the logs
+## Note the last time on the first to newest mysql-bin.######, use that time for the purge binary logs before command.
 ## <tt>'''# mysqladmin flush-logs -p -uroot'''</tt>

2012-07-26T11:47:53Z

Created page with "# Change to the directory containing the binary log files. # Flush the logs ## <tt>'''# mysqladmin flush-logs -p -uroot'''</tt>"

New page

# Change to the directory containing the binary log files.
# Flush the logs
## <tt>'''# mysqladmin flush-logs -p -uroot'''</tt>