LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices



Reply
 
Search this Thread
Old 07-04-2005, 04:29 PM   #1
khwang
LQ Newbie
 
Registered: Jun 2005
Location: Canada
Distribution: Ubuntu Hoary
Posts: 25

Rep: Reputation: 15
Location of mysql logs?


I'm using Ubuntu, I set up Apache, MySQL, PHP. Everything runs fine, I set up --log-warnings but I don't know where the actual log file is located? I went to /etc/mysql/ but it's not there.
 
Old 07-04-2005, 05:04 PM   #2
hfawzy
Member
 
Registered: Aug 2002
Location: Egypt
Distribution: Debian Sarge, Slackware 10.0
Posts: 163

Rep: Reputation: 30
You'll find mysql logs under /var/log.
Actually, this directory contains most of log files (X11, etc..).
 
Old 12-16-2010, 06:01 AM   #3
shanakac
LQ Newbie
 
Registered: Dec 2010
Posts: 1

Rep: Reputation: 0
Quote:
Originally Posted by hfawzy View Post
You'll find mysql logs under /var/log.
Actually, this directory contains most of log files (X11, etc..).
when i check it there it sayd the file is a SYMBOLIC Link "path" but when i check it in the path mentioned the log file is not there ..
 
Old 12-16-2010, 07:36 AM   #4
chickenjoy
Member
 
Registered: Apr 2007
Distribution: centos,rhel, solaris
Posts: 200

Rep: Reputation: 30
open the my.config file and the default log file should be there.
 
Old 12-16-2010, 09:00 PM   #5
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,324

Rep: Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041Reputation: 2041
@shanakac: Note that the preceding comments before yours are 5 yrs old(!). Things change ....
 
Old 12-16-2010, 11:16 PM   #6
chickenjoy
Member
 
Registered: Apr 2007
Distribution: centos,rhel, solaris
Posts: 200

Rep: Reputation: 30
@ topic date ..... I didn't notice that too.
 
Old 12-17-2010, 12:22 AM   #7
rentalsolutions
LQ Newbie
 
Registered: Feb 2010
Posts: 14

Rep: Reputation: 0
Location of mysql logs?

All log files are created in the data directory.
You can force the server to close and reopen the log files (or in some cases switch to a new log file) by flushing the logs.
Log flushing occurs when you issue a FLUSH LOGS statement or execute a
mysqladmin flush-logs, mysqladmin refresh, mysqldump --flush-logs, or mysqldump --master-data command.

Last edited by Tinkster; 12-17-2010 at 05:31 PM.
 
Old 12-17-2010, 07:51 AM   #8
onebuck
Moderator
 
Registered: Jan 2005
Location: Midwest USA, Central Illinois
Distribution: SlackwareŽ
Posts: 11,450
Blog Entries: 4

Rep: Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505Reputation: 1505
Hi,

Quote:
Originally Posted by rentalsolutions View Post
All log files are created in the data directory.
You can force the server to close and reopen the log files (or in some cases switch to a new log file) by flushing the logs.
Log flushing occurs when you issue a FLUSH LOGS statement or execute a
mysqladmin flush-logs, mysqladmin refresh, mysqldump --flush-logs, or mysqldump --master-data command.
I'm asking you to remove the advertisement links in your signature.

No third part advertisement is allowed. If you wish to advertise here on LQ then contact ads@linuxquestions.org.

I appreciate your cooperation in this matter.
 
  


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
Help with MySQL logs icarusfall Linux - Software 0 11-14-2005 06:24 PM
MySQL data Location. AbsoluteMonkey Linux - General 2 12-22-2004 05:58 PM
Router Logs sent to Syslog - Can I change the location Gnarg Linux - Networking 4 08-10-2004 10:24 AM
location of logs in Mandrake 10 shea1roh Linux - Newbie 2 06-29-2004 10:46 AM
location of apt-get logs theoldman Fedora 1 05-17-2004 09:02 PM


All times are GMT -5. The time now is 11:14 PM.

Main Menu
Advertisement
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