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


Popular posts from this blog

phpbb3 Forum not showing after creating