Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: mysql service and dbd::mysql

by hmerrill (Friar)
on Nov 13, 2003 at 14:24 UTC ( #306798=note: print w/replies, xml ) Need Help??


in reply to mysql service and dbd::mysql

I don't know what platform you are running MySQL on, but I know on Red Hat Linux that MySQL logging was *NOT* turned on by default. In order to turn on logging I had to modify the /etc/rc.d/init.d/mysql start/stop/status script - where it invokes safe_mysqld, I add '--log=/var/log/mysqld.log' and so changed the line
from this: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf >/dev/null 2> +&1 & to this: /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --log=/var/lo +g/mysqld.log >/dev/null 2>&1 &
and remember to restart the mysqld server('service mysqld restart' on Red Hat Linux) to make the changes take effect. If you can get MySQL to log messages it might help you figure out what the problem is.

HTH.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://306798]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2023-12-03 18:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?











    Results (20 votes). Check out past polls.

    Notices?