I'm searching the way to logging all output from MySQL. I know that I can use 'tee' command while using MySQL CLI, but I'm using PHP (PDO driver). And, I don't want to use PHP for creating a log file, is required a low level logging. So, maybe there's a way to copy all data that passed via MySQL socket file?
Asked
Active
Viewed 59 times
0
-
you would have to add that code to your php – Aug 16 '16 at 22:07
-
have you looked at [this](http://stackoverflow.com/q/5441972/4233593)? – Jeff Puckett Aug 16 '16 at 22:08
-
@JeffPuckettII no MySQL log file contains all query output – Aug 16 '16 at 22:09
-
1@Dagon I believe the [general query log](https://dev.mysql.com/doc/refman/5.7/en/query-log.html) will go a long way depending on needs. see [this answer](http://stackoverflow.com/a/38414915/4233593) – Jeff Puckett Aug 16 '16 at 22:13
-
@JeffPuckettII it logs the queries, not there output – Aug 16 '16 at 22:14
-
@Dagon ah yes *output*, sorry, I guess I should use my eyes a little more when reading. – Jeff Puckett Aug 16 '16 at 22:15
-
I took out php and pdo tags as you explicitly stated that you don't want to use them. – Your Common Sense Aug 17 '16 at 05:08
-
Might need to be start logging through php/pdo. Please return the tags – phpcoding Aug 17 '16 at 14:04
-
I mean start low-level logging through command that will transferred to MySQL server through php/PDO, while not using PHP to logging directly. – phpcoding Aug 17 '16 at 14:09