MySQL Log Files

cli_man · 10-18-2002, 08:43 PM

Here is a question for ya, I am working trying to learn MySQL and PHP and have all kinds of error working with mysql, it would be helpful to have a logfile for mysql that might shed light on what I am doing wrong, it is not just one thing or I would post that for help, it is just me learning yet more about a computer, but I think it would help to have a log file. Does MySQL have log files that log errors? And where would I find it? Thanks.

markus1982 · 10-19-2002, 03:50 AM

For the error parts of your PHP code you can always use mysql_error described in http://www.php.net/manual/en/function.mysql-error.php

MySQL itself has an error log, but that won't shed any lights for you in the case of programming errors!

Def · 10-19-2002, 08:20 AM

Log of MySQL queries turn on by option --log=/var/log/mysql.q

Will be logged all queries and DB connections.

--
Sincerely,
Andrew A.Romanchenko
Programmer of Rapid Internet Development Department
Alar Information Technologies, www.alarit.com

markus1982 · 10-19-2002, 08:36 AM

Quote:

Originally posted by Def
Log of MySQL queries turn on by option --log=/var/log/mysql.q

Will be logged all queries and DB connections.

Keep in mind that this will DEFINATELY slow down your whole system ...

cli_man · 10-19-2002, 09:30 AM

Ok thank you for the info, slowing down the system is not a problem as of right now, It is mainly a system used for development and testing, it will be a couple of months before it goes live. And I wanted to see what was being passed to the databases so the logging should give me what I wanted. Thank you for your fast replies.

cheeyee · 10-20-2002, 09:21 PM

wat os are u using now?

cli_man · 10-20-2002, 10:24 PM

For the servers I work with mostly redhat 7.2 that is what I am using that I was asking this question about, but in general I work troubleshooting windows all day long, and my own machines run win 95, 98, me, 2000, xp, redhat 7.2, mandrake 8.1, solaris 8. and yes I do have all of those running at the same time on different machines. I would love to go all linux but unfortunatly Bill Gates pays my paycheck every week, not literally but seeing that I spend all day every day troubleshooting windows I like to thing that he is paying me, so as long as that is what I am doing for a living I have to keep up with all the windows products.