during the execution of mysql_upgrade.
My situation 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
.
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 execute mysql_upgrade. Which also means blocking write access
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://rajshekhar.net
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
, but 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
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
#set
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]
datadir=/var/lib/mysql
socket=/var/lib/mysql
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_bin.index
i have
: 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
log-bin-index = /var/log/mysql/mysql_bin.index
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
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
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?
Is extention of log files
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=1000
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]
--Subject: Turn off log-bin without restarting
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, and I
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
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 in my
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 had also tried just
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