In answer to my own question:
Why don't the binary logs write?
The '%-bin.index' file left over from previous version (4.1.9) had to be
deleted after the conversion to 5.1.6.
By deleting this file, the binary logs started to recreate.
I hope this is useful to somebody :)
Ben
Ben Clewett
Hello.
If documentation isn't clear, you may want to report a bug at:
http://bugs.mysql.com
Jerry Bonner <[EMAIL PROTECTED]> wrote:
> I realize that.
>
> The documentation states that username and timestamp,
> by default, are logged to "(update log, binary update log, and s
I realize that.
The documentation states that username and timestamp,
by default, are logged to "(update log, binary update log, and slow queries
log, whatever log has been activated)". But apparently it isn't.
I was hoping that there was a way to get that information in the binary
log, but
Hello.
I think these lines from sql/mysqld.cc from 4.1.13 distribution shows
that --log-long-format doesn't affect the behavior of MySQL:
{"log-long-format", '0',
"Log some extra information to update log. Please note that this
option is deprecated; see --log-short-format option.",
0, 0,
On Mon, Jan 05, 2004 at 09:12:24AM +1300, Sam Vilain wrote:
> No-one out there doing step-by-step replay of binary logs ?
mysqlbinlog
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 162 days, proce
George Mathew <[EMAIL PROTECTED]> wrote:
> Seems to be the binary log saves all INSERT statements, even if it is
> a duplicate error.
Only successfully executed INSERTs are written to the binary logs.
> How could I restore my table using mysqlbinlog if there
> are duplicates in the log file.
Wha
I would greatly appreciate your notes if you are willing to post them. I'm currently
preparing for the core exam.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No-one out there doing step-by-step replay of binary logs ?
On Tue, 30 Dec 2003 17:52, Sam Vilain wrote;
> Hi there,
>
> Is there a utility out there to do transaction-at-a-time view and/or
> replay with MySQL's binary log ? Primarily for audit / debug
> purposes.
>
> I'm only in
On Wed, Jun 11, 2003 at 03:30:01PM -0500, Sam Jumper wrote:
> Is it possible to have more than one binary log per master or is it
> possible to start more than one thread to execute queries?
>
> I have 2 computers in a master and slave configuration. The slave is
> running without error but it
In order to help, could you post some info about both servers config (cpu
speed, disk speed and OS as well as network capacity) - That would really
help people understand the problem and find the bottleneck...
Cheers,
A
-Original Message-
From: Sam Jumper [mailto:[EMAIL PROTECTED]
Sent:
file.
Is this what you meant.
Thanks
sam
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "sam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 2:40 PM
Subject: Re: binary log not recording 4.0.9
> Y
s.
I appreciate any help you can offer,
Sam Pizzuto
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "sam" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 31, 2003 9:20 AM
Subject: Re: binary log not recording 4
If your application is opening one database, and then updating
medic.sometable, the update will not be recorded in the bin file.
sam wrote:
I am trying to use replication with 4.0.9.
Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when present
At 16:21 -0500 12/11/02, David Nedved wrote:
Hi All,
I have two qestions about the binary log files that I couldn't find the
answer to.
1.) how do you force a log switch other than startup / shutdown?
FLUSH LOGS
2.) when the number gets to 999 does it keep going with more digits,
wrap aroun
14 matches
Mail list logo
