on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
the --binlog-do-db option along with it. Databases not named
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only for
ONE database of several being on my server?
cheers,
M.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
At 18:55 -0600 3/25/04, Moritz von Schweinitz wrote:
hi again!
on a related note to my previous question:
how can i switch on the creation of a (binary) update log, but only
for ONE database of several being on my server?
You probably want to enable the binary log with --log-bin, and use
hello, Jeff.
you wrote 10 ìàðòà 2003 ã., 5:18:23:
JK From you're info below, mysql *shouldn't* be turning on the binary log. An
JK easy way to test is just to run the 'ps' command and see if '--log-bin' is
JK being added to the command line. If you have a long command line for the
JK mysql
hello, mysql.
i have installed mysql-server 3.23.55 from ports under FreeBSD 4.7-STABLE.
databases place is /var/db/mysql. and in this dir creates binary log of updated
databases in /var/db/mysql/bingo-bin.001, 002, etc. i do not turn on this in
configs and startup files, but it don't care appear
-bin.xxx
I assume that it's the binary update log, but i haven't that with my old
3.23.48.
So please, how can i disable this log ??
Rgds
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
You must disable log-bin.
To disable just put # in front of log-bin like
#log-bin
Then stop the mysql daemon and restart. You will never binary update log
again.
-Original Message-
From: David BORDAS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 9:40 PM
To: [EMAIL PROTECTED]
Subject
Greetings,
We plan to use the binary update log plus backups to enable us to
restore databases and then re-apply updates when necessary. It appears
to me that the binary update log contains updates to all databases on
the mysqld-max process, and that there is no way to keep a separate
On Mon, May 27, 2002 at 10:31:06AM -0700, jim hopp wrote:
Greetings,
We plan to use the binary update log plus backups to enable us to
restore databases and then re-apply updates when necessary. It
appears to me that the binary update log contains updates to all
databases on the mysqld
On Wed, Sep 19, 2001 at 09:37:29AM -0700, Cameron Watters -- List Subscriptions wrote:
Just a quick question regarding how (if at all) MySQL's binary update log
consumes resrouces as it records modifications to various tables in the
database.
Are there any potential performance issues
Just a quick question regarding how (if at all) MySQL's binary update log
consumes resrouces as it records modifications to various tables in the
database.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log
OBLIGATORY TOPIC REFERENCE TO BYPASS FILTER: mysql
Just a quick question regarding how (if at all) the binary update log
consumes resrouces.
Are there any potential performance issues or limitations to be
expected (other than excessive consumption of diskspace) if this log is
not flushed
I am trying to figure out how to do this so I can do
incremental backups. Any ideas would be appreciated.
Thanks,
Shane
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
13 matches
Mail list logo