Location of mysql logs?

khwang · 07-04-2005, 03:29 PM

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.

hfawzy · 07-04-2005, 04:04 PM

You'll find mysql logs under /var/log.
Actually, this directory contains most of log files (X11, etc..).

shanakac · 12-16-2010, 05:01 AM

Quote:

Originally Posted by hfawzy

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 ..

chickenjoy · 12-16-2010, 06:36 AM

open the my.config file and the default log file should be there.

chrism01 · 12-16-2010, 08:00 PM

@shanakac: Note that the preceding comments before yours are 5 yrs old(!). Things change ....

chickenjoy · 12-16-2010, 10:16 PM

@ topic date ..... I didn't notice that too.

rentalsolutions · 12-16-2010, 11:22 PM

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.

onebuck · 12-17-2010, 06:51 AM

Hi,

Quote:

Originally Posted by rentalsolutions

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.