nuary 06, 2010 11:43 AM
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
e-
> 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 no
ginal Message-
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
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
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
ySQL general mailing list
> Subject: Re: 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/
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 s
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.
) 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
hello,
how can i create a binary log in a new database
- Original Message -
From: "Adam Lipscombe" <[EMAIL PROTECTED]>
To:
Sent: 14/12/2005 3:50 PM
Subject: Mysqldump INSERT statements (Was Mysqldump line endings)
>> (--result-file) option to save your output but use the > output
redi
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 M
> I just found that mysql 4.0.18 is doing binary logging. How can I
> turn this off?
> 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 y
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
"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&
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 receiv
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 to
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
18 matches
Mail list logo
