Re: MySQL log files

2003-11-29 Thread Egor Egorov
Admin-Stress [EMAIL PROTECTED] wrote: How can I enable MySQL 4.0.16 log ? I just compiled and installed it in my RedHat 9.0 system, but I cant see any log files. I use default /etc/my.cnf from my-large.cnf. Depends on what exactly logging you want to turn on (binary, update, general

MySQL log files

2003-11-28 Thread Admin-Stress
Hello, How can I enable MySQL 4.0.16 log ? I just compiled and installed it in my RedHat 9.0 system, but I cant see any log files. I use default /etc/my.cnf from my-large.cnf. Sorry, if this question is too newbie, but I cant understand clearly reading MySQL manual. Thanks for helping me :)

Re: MySQL log files

2003-11-28 Thread Mayuran
How are you starting mysql? as a service? I dont think it keeps a log file by default. If you are not starting mysql as a service, start it with the --log-error=/var/log/mysqld --log-warnings flags. If you are starting it as a service, add those flags to your mysql file inside

Can mySQL log files be located on another server?

2001-12-13 Thread Peter M. Perchansky
Greetings: http://www.mysql.com/doc/B/i/Binary_log.html Is it possible to place this and the error log file generated by mySQLd on the hard drive on another server? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc.

RE: Can mySQL log files be located on another server?

2001-12-13 Thread Johnny Withers
. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 2:55 PM To: [EMAIL PROTECTED] Subject: Can mySQL log files be located on another server? Greetings: http

configuring mysql log files

2001-04-10 Thread Kim Albee
My database log files are expanding very quickly - and when I look at them, they are logging all of the select statements, not just the delete, insert, update, etc. statements. How do I specify for the logfiles to only log "update" statements and not the selects? Thanks, Kim Albee