MYSQL: Log and Conf file

Swakoo · 10-17-2005, 11:24 PM

Hi guys...

any idea where, by default, would mysql log file be? Just tried to do a restore of a database dump but it prompt error, but not detailed.

Because I check my.cnf, it shows /var/log/mysqld.log but that file is empty...

also.. is there another .conf file for mysql, where more options/configurations can be made? because i did a show variables in mysql and it showed many settings.. i suppose i can change them...

anyone? thanks man!

btmiller · 10-17-2005, 11:46 PM

Try /var/db/mysql and /var/mysql as locations for the log. The MySQL logs only log program errors, not errors in your SQL syntax or anything like that. It might help if you posted the error message.

The config file is usually located in /etc/my.conf but that location can be changed.

tkedwards · 10-17-2005, 11:51 PM

On Redhat'ish distros the log file is /var/log/mysqld.log

Swakoo · 10-18-2005, 03:07 AM

i see... the error i had was a data error.. probably one of the primary key had a duplicated key thats why...

mysqld.log is empty. for me - no program error i suppose?

Swakoo · 11-11-2005, 07:43 AM

Hi guys, recently my db had an error "Too many open connections" or something...

it was told to me by my colleague... apparently our forums showed the error..

1) What usually cause this problem and what can be used to give the server more connection?

2) My mysqld.log in /var/log shows a latest entry of july... i suppose no error in between? Is there any other log?

thanks!

tkedwards · 11-11-2005, 06:28 PM

Google that error and you find: http://dev.mysql.com/doc/refman/5.0/...nnections.html