MySQL does not have a thing such the Oracle transaction log.
But it has the Binary Log used by replication,
for this reason the binary log is server level and it is "decoupled"
from the storage engine concept.
Basically (if we consider the old good "statement" format) it is just a
file with com
Sir,
I am Sorry,
My request is related to "binlog_format" variable.
Thank you
From: ewen fortune
To: Vikram A
Cc: MY SQL Mailing list
Sent: Tue, 4 May, 2010 3:31:44 PM
Subject: Re: Best Bin log - type in MYSQL
Vikram,
> I am using win-server and xp for my
you can circumvent the problem by using stdout.
just drop the "INTO OUTFILE '/tmp/result.txt'".
the result should look something like that:
mysql -BAN -e "select ..." >filename
you can also pipe truh gzip to compress the file and save
a lot of space.
re,
wh
note: i found ";" is not a good se
Vikram,
> I am using win-server and xp for my master, slave setup. when i do the
> beginTrans with bin-log = STATEMENT it is causing error. If i defined this
> with any one of the following, its working quite fine. MIXED, ROW.
>
> Which is the best one in the above two? Or how it differs?
> Can
Thank you for replying Carlos, but I'm under the impression that this
will also put the file on the server. Acutally, mysqldump --tab uses
INTO OUTFILE to generate the dump if i'm not mistaken
Carlos Eduardo Caldi wrote:
Hi
You can use on shell, connect at the client mysq -h (host or IP)
-p(
Hi,
I am using win-server and xp for my master, slave setup. when i do the
beginTrans with bin-log = STATEMENT it is causing error. If i defined this with
any one of the following, its working quite fine. MIXED, ROW.
Which is the best one in the above two? Or how it differs?
Can I have your ex
