LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 10-18-2002, 08:43 PM   #1
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Rep: Reputation: 30
MySQL Log Files


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.
 
Old 10-19-2002, 03:50 AM   #2
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
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!
 
Old 10-19-2002, 08:20 AM   #3
Def
LQ Newbie
 
Registered: Sep 2002
Posts: 3

Rep: Reputation: 0
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
 
Old 10-19-2002, 08:36 AM   #4
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
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 ...
 
Old 10-19-2002, 09:30 AM   #5
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Original Poster
Rep: Reputation: 30
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.
 
Old 10-20-2002, 09:21 PM   #6
cheeyee
LQ Newbie
 
Registered: Oct 2002
Posts: 6

Rep: Reputation: 0
wat os are u using now?
 
Old 10-20-2002, 10:24 PM   #7
cli_man
Member
 
Registered: Apr 2002
Location: New York, USA
Distribution: Redhat 7.2, 9.0 Slackware 9.1
Posts: 428

Original Poster
Rep: Reputation: 30
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can't log in to mysql walterbyrd Linux - Software 2 03-25-2005 05:30 PM
Deleted /var/log/messages, can't log any files-iptables chingyenccy Linux - Newbie 7 02-27-2005 04:03 PM
cannot log into mysql jomy Linux - Networking 1 02-27-2005 05:05 AM
Can log files be time stamped? (such as FTP login and transfer log files) bripage Linux - Networking 6 08-08-2002 10:55 PM
Handling Mysql Binary log files saravanan1979 Programming 0 03-25-2002 01:16 AM


All times are GMT -5. The time now is 12:12 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration