Format mysql query log file output

Question

I created a querylog.log file and place the line below:

log="C:\Users\paul\Documents\dumps\querylog.log"

in my.ini under [mysqld] to log all mysql queries on my computer but the problem that I have is that the queries are not properly formatted in the file. Is it possible to have the output logs formatted where everything will be written on a separate line (like have all the queries on one line)?

Thanks in advance for any help.

End each line with `\n` (has to be in double quoted string). — Qirel, Jun 14 '16 at 18:07

score 0 · Answer 1 · answered Jun 14 '16 at 18:29

The only way you could achieve this is, using triggers.

As soon as any log is written to the log file, fire a php script which

Opens the logfile
Appends the file and adds a new line
Closes the connection with the file (so that it's usable again by the log writer).

Format mysql query log file output

1 Answers1