Kenneth: Created page with "== Purge Master Logs == PURGE MASTER LOGS Syntax [http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html] : Deletes all the binary logs listed in the log index prior to..."

2016-03-08T20:31:33Z

Created page with "== Purge Master Logs == PURGE MASTER LOGS Syntax [http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html] : Deletes all the binary logs listed in the log index prior to..."

New page

== Purge Master Logs ==
PURGE MASTER LOGS Syntax [http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html]
: Deletes all the binary logs listed in the log index prior to the specified log or date. The logs also are removed from the list recorded in the log index file, so that the given log becomes the first.

Syntax:
: PURGE {MASTER | BINARY} LOGS TO 'log_name'
: PURGE {MASTER | BINARY} LOGS BEFORE 'date'

Examples:
: PURGE MASTER LOGS TO 'mysql-bin.010';
: PURGE MASTER LOGS BEFORE '2003-04-02 22:46:26';

== Reset Master ==
RESET MASTER Syntax [http://dev.mysql.com/doc/refman/5.0/en/reset-master.html]
:Deletes all binary logs listed in the index file, resets the binary log index file to be empty, and creates a new binary log file (staring at 1).

Syntax:
: RESET MASTER

== Show Logs ==
SHOW BINARY LOGS Syntax [http://dev.mysql.com/doc/refman/5.0/en/show-binary-logs.html]
: Lists the binary log files on the server.

Syntax:
: SHOW BINARY LOGS
: SHOW MASTER LOGS

== Show Master Status ==
SHOW MASTER STATUS Syntax [http://dev.mysql.com/doc/refman/5.0/en/show-master-status.html]
:Provides status information about the binary log files of the master.

Syntax:
: SHOW MASTER STATUS

MySQL/Binary Logs - Revision history

Kenneth: Created page with "== Purge Master Logs == PURGE MASTER LOGS Syntax [http://dev.mysql.com/doc/refman/5.0/en/purge-master-logs.html] : Deletes all the binary logs listed in the log index prior to..."