re
>> server,
>> I would like to turn off binary logging just for the session of the
>> mysql_upgrade connection.
>>
>> mysql_upgrade does not support anything like --disable-log-bin (which seems
>> is a
>> feature that should be supported for this cli app)
session of the
> mysql_upgrade connection.
>
> mysql_upgrade does not support anything like --disable-log-bin (which seems
> is a
> feature that should be supported for this cli app) (1)
> So it seems my only option is to turn off binary logging for the entire server
> while I exe
is I do not want to turn off binary logging for the entire server,
I would like to turn off binary logging just for the session of the
mysql_upgrade connection.
mysql_upgrade does not support anything like --disable-log-bin (which seems is a
feature that should be supported for this cli app) (1
Marcos VinÃcius Vieira dos Santos wrote:
> I used --localstatedir in ./configure but both data files and log files
> was stored together.
In your my.cnf file, put the lines (in [mysqld] section
datadir = /sgdb/data
log-bin = /var/log/mysql
--
raj shekhar
facts: http://rajshekh
Hello everyone,
I am compiling mysql source and need stored MySQL data files and log files (log
bin) separated. For example:
/var/log/mysql /* log files
and
/sgdb/data /* data files
I used --localstatedir in ./configure but both data files and log files was
stored together.
How do
MySQL still expects the
index file to be in the data directory.
Try configuring the index file to be stored in the data directory, while
configuring the binlogs to be stored in the logs directory as you wanted.
log-bin = /var/log/mysql/mysql_bin.log
log-bin-index = /var/lib/mysql/mysql_bin.index
If
st'
Subject: RE: log-bin
arrggg..
hi martin.
nope, i tried to add the line to my my.cnf file. in fact, i also copied the
bin log files from the /var/lib/... to the /var/log/mysql dir
i now have in the my.cnf file
>>log-bin = /var/log/mysql/mysql_bin.log
>&g
arrggg..
hi martin.
nope, i tried to add the line to my my.cnf file. in fact, i also copied the
bin log files from the /var/lib/... to the /var/log/mysql dir
i now have in the my.cnf file
>>log-bin = /var/log/mysql/mysql_bin.log
---->>log-bin-index = /var/log/mysql/mysql_b
Hi,
On Dec 8, 2007 3:44 PM, bruce <[EMAIL PROTECTED]> wrote:
> hi...
>
> i'm trying to run mysql on a fedora core 5, system to allow the log bin
> files to be created.
>
> i have the following my.cnf file:
>
> ---
> [mysqld]
hi...
i'm trying to run mysql on a fedora core 5, system to allow the log bin
files to be created.
i have the following my.cnf file:
---
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=3
#log-error = /var/log/mysql_err.log
hi,
i enable option log-bin in my mysql db server so that i can use the log to recover the
transaction which did not backup.
But, except for the binary log file hostname-bin, i found another file
hostname-bin.index. What is the function of it?
Thanks
Brian
Sohail Hasan <[EMAIL PROTECTED]> wrote:
> I am using mysql version 4.0.12 on a solaris sparc box. My server has
> stopped creating the log-bin files although it is defined in my.cnf. The
> directory permissions of the data directory are fine. What is wrong with
> the setup?
I
I am using mysql version 4.0.12 on a solaris sparc box. My server has
stopped creating the log-bin files although it is defined in my.cnf. The
directory permissions of the data directory are fine. What is wrong with
the setup?
Sohail
--
MySQL General Mailing List
For list archives: http
: Ian Collins [mailto:[EMAIL PROTECTED]
Sent: Friday 11 July 2003 00:59
To: [EMAIL PROTECTED]
Subject: Turn off log-bin without restarting database
I want to turn off replication logging (we have stopped using
replication) without shutting down the server.
(The only downtime allowed is about 2am,
CHANGE MASTER TO MASTER_LOG_HOST='', MASTER_LOG_POS='',
MASTER_LOG_PORT='';
SLAVE STOP;
SHOW SLAVE STATUS;
-->-Original Message-
-->From: Ian Collins [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, July 10, 2003 4:59 PM
-->To: [EMAIL PROTECTED]
-->
I want to turn off replication logging (we have stopped using
replication) without shutting down the server.
(The only downtime allowed is about 2am, and I needmy sleep).
I couldn't see how to do this in the docs. Is it possible?
The variables in my /etc/my.cnf are,
log-bin
server-id
It would be nice to have the possibility to exclude CREATE TEMPORARY TABLE
statements from the log bin.
Because such statements are really used not for updating a DB, but for
constructing intermediary statements that eventually derive in a final
INSERT/ UPDATE. I believe only this final statement
Hello,
I set up a replication architecture with MySql
everything works fine.
Now I concentrate on log-bin file and I have a question
I have understood (I hope... )
-that I can set a max_binlog_size,
-that a new file (extension n+1) will be used while reaching max_binlog_size,
-that the slave
On Fri, Jan 25, 2002 at 03:30:11AM -0500, Ken wrote:
> I'm trying to enable binary logging on my MySQL server (3.23.28-gamma-log), per the
>recommendations in the manual about properly backing up the database.
>
> In my /etc/my.cnf I have:
> [mysqld]
> log-bin=updates
>
I'm trying to enable binary logging on my MySQL server (3.23.28-gamma-log), per the
recommendations in the manual about properly backing up the database.
In my /etc/my.cnf I have:
[mysqld]
log-bin=updates
I had also tried just:
[mysqld]
log-bin
But no update log file is being created
How can I get the log-bin initial position?
Like: trevas-bin.001
trevas-bin.002
I want to know in which position trevas-bin.002 began.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
21 matches
Mail list logo
