SAFELY ROTATING MYSQL GENERAL LOGS in Windows



Step 1: Disable general log.
         
         SET GLOBAL general_log = 'OFF';

Step 2: take general log and slow query log  backup
       
                -- general_log backup
mysqldump -u root -p mysql general_log --lock-tables=0                    >"D:/general_log_bkp.sql"

Step 3: truncate mysql.general_log;

Step 4: Enable general log
SET GLOBAL general_log = 'ON';



Comments

Popular Posts