Do you have a question? Post it now! No Registration Necessary. Now with pictures!
June 2, 2006, 12:32 am
rate this thread
I am trying to turn on General logging on mysql server [on a RHE linux
If I go >mysqld -l filename
on shell, it says "command not found". What is the best way to create
General log on a live server.
Somehow MYSQL server doesn't have a my.cnf file. I have searched all
over but there are no signs. Whenever I have to start/stop/restart the
server, I use the ready-made mysql script.
Re: Create General query log
it is typically in /etc/my.cnf . You can find out where it is expected
by running: "mysqld --help --verbose"
You should see a line of output that looks like this (along with a lot
of other stuff):
Default options are read from the following files in the given order:
The following groups are read: mysqld server mysqld-5.0
Once you know what option file to use, create the file and put your
options in it (in your case, you'd need to add a [mysqld] section to
the blank file and then enable the general query log under that, then
restart the server).
We also provide MySQL and PostgreSQL training - both on-site and public
enrollment courses. http://www.otg-nc.com
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
- » tinyint field column value constantly resets to "127", why?
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum