Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in the
/var/log/mysql/ folder, the oldest file is from the 2009-12-27. The MySQL
service has not been restarted since the server came back up 150
-
From: Steve Staples [mailto:sstap...@mnsi.net]
Sent: January 6, 2010 2:35 PM
To: mysql@lists.mysql.com
Subject: Binary Logging
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in the
/var/log
]
Sent: January 6, 2010 2:35 PM
To: mysql@lists.mysql.com
Subject: Binary Logging
Good afternoon.
I am having a weird problem with the Binary Logging of my MySQL.
For some reason, we have it on (still not sure why) but when i look in the
/var/log/mysql/ folder, the oldest file is from
To: mysql@lists.mysql.com
Subject: RE: Binary Logging
Silly me sees that there is an 'expire_log_days' in the my.cnf
But again, if i was to purge everything but the last day or 2... running
this command i found:
PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY);
From the MySQL command
Rithish,
It's possible to do this by turning off binary logging, restarting the
server, importing, turning on binary logging, and restarting.
-Sheeri
On 2/27/06, Rithish Saralaya [EMAIL PROTECTED] wrote:
Hello.
I was going to recreate a database of size 35 GB from sql dump file. Wanted
: create/restore database without binary logging
Rithish,
It's possible to do this by turning off binary logging,
restarting the server, importing, turning on binary logging,
and restarting.
-Sheeri
On 2/27/06, Rithish Saralaya
[EMAIL PROTECTED] wrote:
Hello.
I was going
Thanks Sheeri.
Regards,
Rithish.
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 11:26 PM
To: Rithish Saralaya
Cc: MySQL general mailing list
Subject: Re: create/restore database without binary logging
Rithish,
It's possible to do
Hello.
I was going to recreate a database of size 35 GB from sql dump file. Wanted
to know if it is possible to do it without mysql writing into the binary
log. If yes, how?
Regards,
Rithish.
hello,
how can i create a binary log in a new database
- Original Message -
From: Adam Lipscombe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: 14/12/2005 3:50 PM
Subject: Mysqldump INSERT statements (Was Mysqldump line endings)
(--result-file) option to save your output but use
) 636-9239
-Original Message-
From: prathima rao [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 14, 2005 6:04 AM
To: mysql@lists.mysql.com
Subject: how to create binary logging for a database
hello,
how can i create a binary log in a new database
- Original Message
MySQL 4.0.18, Tru64 5.1B
The log partition filled up on one of our instances. RESET MASTER
fails with:
ERROR 1186: Binlog closed, cannot RESET MASTER
I deleted some older logs by hand, but RESET MASTER still fails.
FLUSH LOGS appears to succeed, but no binary logs are being written,
and RESET
Hi there,
I just found that mysql 4.0.18 is doing binary logging. How can I turn this off?
I outcommented the line in my.cnf and restarted the server, but it is still creating
those binary loggs inside the data dir. I do not see a nead for this, plus I fear that
it might fill up the file system
I just found that mysql 4.0.18 is doing binary logging. How can I
turn this off?
SNIP
I do not see a nead for this, plus I fear that
it might fill up the file system, plus I think it is reducing performance.
The binary log is primarily there to let you restore data. Say you backup
every
Bryan Brannigan [EMAIL PROTECTED] wrote:
I'm having difficulty getting binary logging to run. My system is a Debian 3.0r2
system running MySQL-server 4.0.16-log. I have added log-bin to my my.cnf file.
However, when I restart MySQL I don't get a binary log anywhere. When I run SHOW
I'm having difficulty getting binary logging to run. My system is a Debian 3.0r2
system running MySQL-server 4.0.16-log. I have added log-bin to my my.cnf file.
However, when I restart MySQL I don't get a binary log anywhere. When I run SHOW
MASTER STATUS, I receive an empty set. I'm sure
http://mindforums.com/forums/showthread.php?threadid=82
Per this thread I started to set up the two way replication as stated and
reached a point where I had/have a question about binary logging. How and
what does binary logging keep track of. I know that it keeps track of
changes made
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
18 matches
Mail list logo