LinuxQuestions.org
Visit Jeremy's Blog.
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, 03: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, 04: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, 05: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, 06:36 AM   #4
chickenjoy
Member
 
Registered: Apr 2007
Distribution: centos,rhel, solaris
Posts: 239

Rep: Reputation: 30
open the my.config file and the default log file should be there.
 
Old 12-16-2010, 08:00 PM   #5
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.x
Posts: 18,442

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

Rep: Reputation: 30
@ topic date ..... I didn't notice that too.
 
Old 12-16-2010, 11:22 PM   #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 04:31 PM.
 
Old 12-17-2010, 06:51 AM   #8
onebuck
Moderator
 
Registered: Jan 2005
Location: Central Florida 20 minutes from Disney World
Distribution: SlackwareŽ
Posts: 13,983
Blog Entries: 46

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

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:24 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
Open Source Consulting | Domain Registration