I don't think there is any way to lock down the general log to a
single database.. perhaps if you tell us what you are trying to
accomplish, we might be able to propose something..
As of today, 5.0.45 is the recommended install version.
http://dev.mysql.com/downloads/mysql/5.0.html
- micha
of course you'll need to restart the server after making the changes
to the options file..
On 7/30/07, Christian High <[EMAIL PROTECTED]> wrote:
> set these options in the option file under the [mysqld] section
>
> log-slow-queries=
> log=
>
> log= is the general query log
>
> i am not sur
set these options in the option file under the [mysqld] section
log-slow-queries=
log=
log= is the general query log
i am not sure what you mean by the mysql log. if you mean the error
log than that would be
log-error=
if you mean the binary log that would be
log-bin=
if you don't enter anyt
bruce wrote:
chris...
hate to tell you.. .but you can have the log files set as i described..
the real issue was due to permission issues on the dir/file for the mysql
lol.. i'm not having much luck answering questions lately ;)
Thanks for letting us know about the fix.
--
MySQL General Mai
bruce wrote:
hi...
i changed the mysql my.cnf to provide log files. i restarted mysql, but i
don't see the log files...
any idea as to what i may have missed. i'm running FC4, mysql 4.1.
the my.cnf is:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
set-variable = max_connect
> I think I am confused. I have many bin index files, but I have not gotten
rid of them.
>
> I read somewhere that I should not remove them...or I should not remove
the entries in the index file.
>
> Since I am unsure of which one above is correct, I am posting to the list.
>
> Can someone let
[EMAIL PROTECTED] wrote:
>
> I think I am confused. I have many bin index files, but I have not gotten rid of
> them.
>
> I read somewhere that I should not remove them...or I should not remove the entries
> in the index file.
>
> Since I am unsure of which one above is correct, I am posting
>> I think I am confused. I have many bin index files, but I have not
>> gotten rid of them.
>>
>> I read somewhere that I should not remove them...or I should not
>> remove the entries in the index file.
>>
>> Since I am unsure of which one above is correct, I am posting to the
>> list.
>>
> -Message d'origine-
> De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Envoyé : Monday, December 29, 2003 8:12 PM
> À : [EMAIL PROTECTED]
> Objet : Log Files in MySQL
>
>
> I think I am confused. I have many bin index files, but I
> have not gotten rid of them.
>
> I read somewh
At 17:22 -0300 10/14/03, Daniel Franco wrote:
InnoDB uses some log files that are placed in the directory 'MySQL / data'.
What are those files ? Why and when InnoDB needs to save those logs ?
InnoDB uses them to record ongoing changes being made by transactions,
and for auto-recovery after a crash.
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "ritu singla" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 2:31 PM
Subject: Re: Log Files in InnoDB (MySQL)
> Ritu,
>
> the ib log files contain r
> Hello,
> i could not understand what is the content of log
> files in InnoDB in MySQL...is it the log of the
database,i
> mean, the data, or the transaction log??
>
> Thanx in advance..
> Ritu Singla
>
>
> Everything y
> 1. In which directory i can find the config file to config the log file
> 2. Where can i find the log file for mysql?
The log file will be in the data directory. In my case:
/usr/local/mysql/var
It has ending .err
You can place my.cnf in this dir also and some other places.
C
For Unix /etc/my.cnf
you then in the my.cnf say were you would like the logs!
Simon
-Original Message-
From: Krishna M [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 16:27
To: [EMAIL PROTECTED]
Subject: Log files
Hello,
I have a Question,
1. In which directory i can fi
14 matches
Mail list logo
