To see the current status of mysql log, type the following command in XAMPP
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
SHOW VARIABLES LIKE 'general_log';
below output will come in the phpmyadmin
Variable_name | Value |
---|---|
general_log | OFF |
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