Answered by : onkar-gujar

SET general_log = 1;

Source : https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log | Last Update : Thu, 31 Mar 22

Answered by : saif-gaida

Copied
LOAD DATA INFILE '/local/access_log' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'

Source : https://dev.mysql.com/doc/refman/8.0/en/apache.html | Last Update : Tue, 15 Mar 22

Answered by : onkar-gujar

log = /path/to/query.log #works for mysql < 5.1.29

Source : https://stackoverflow.com/questions/6479107/how-to-enable-mysql-query-log | Last Update : Thu, 31 Mar 22