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
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