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
Post a Comment