How to purge binary logs when you have no space left on DB server

How to purge binary logs when you have no space left on DB server

When you need to purge binary logs on a MySQL server, you just need to connect to your server and use the PURGE BINARY LOGS command.

PURGE BINARY LOGS BEFORE '2008-04-02 22:46:26';
  
SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 300;
start slave;

Related Articles

Office Locations

Macau:

MAIN OFFICE - Rua Formosa No. 21, 3 Andar G, Edf. Yee Mei   (Tel: +853 8394 8394 ),

BRANCH - Avenida de Almeida Ribeiro, Beco da Cadeia No. 10A R/C  (Tel: +853 8394 8383 )

Hong Kong:

RM 1810, Tower B, Viking Technology & Business Centre, No.93 Ta Chuen Ping Street, Kwai Chung, NT (Tel: +852 3598 3683

China:

广东省珠海市横琴新区,琴海西路6号,万象世界2幢14楼1421室 (Tel: +86 15338 153379