MySQL/Binary Logs

Purge Master Logs
PURGE MASTER LOGS Syntax
 * 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
 * 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
 * Lists the binary log files on the server.

Syntax:
 * SHOW BINARY LOGS
 * SHOW MASTER LOGS

Show Master Status
SHOW MASTER STATUS Syntax
 * Provides status information about the binary log files of the master.

Syntax:
 * SHOW MASTER STATUS