05 August, 2012

enabling or disabling MySQL log

To see the current status of mysql log, type the following command in XAMPP
SHOW VARIABLES LIKE  'general_log';

below output will come in the phpmyadmin
Variable_nameValue
general_logOFF
To enable the log, type
SET GLOBAL general_log = 1;
Disabling log
SET GLOBAL general_log = 0;


To check where is the log file saved 
 SHOW VARIABLES LIKE  'general_log_file';

Below output will come
Variable_name    Value
general_log_file    \xampp\mysql\data\dino-laptop.log

 
The log files will be saved in the above mentioned path
 

No comments:

Post a Comment