Chenri J wrote:
one more question, how about when i'm using 'BEGIN'
and doesn't end it with 'COMMIT' neither 'ROLLBACK'
what will happen.
I've tried before and nothing happen but does anyone have an opinion?
This depends on a number of things:
If the table handler in question does not support tra
Chenri J wrote:
i'm still using 3.23
can anyone show me how to activate update log
by modifying the my.cnf/ my.ini
Show you?
It is not clear what you want. Do you need help starting the editor?
What OS are you using? On Windows systems Notepad can be used to edit
the configuration files.
x27;m still using 3.23
> can anyone show me how to activate update log
> by modifying the my.cnf/ my.ini
>
> And a question about update log,
> does it only record update and delete (mysql documentation),
> how about insert? do the log recorded those too?
>
> thanks
>
>
i'm still using 3.23
can anyone show me how to activate update log
by modifying the my.cnf/ my.ini
And a question about update log,
does it only record update and delete (mysql documentation),
how about insert? do the log recorded those too?
t
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 with
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
the
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
Hi!
On Jul 28, Daniel Kasak wrote:
> http://www.mysql.com/doc/en/News-5.0.x.html
>
> The change log says it's "no longer supported". Does that mean that it
> will be there, but there are no guarantees that it's accurate, or that
> it's being removed
http://www.mysql.com/doc/en/News-5.0.x.html
The change log says it's "no longer supported". Does that mean that it
will be there, but there are no guarantees that it's accurate, or that
it's being removed completely?
The update log is very handy when doing development
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 pr
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 09, 2003 4:10 AM
Subject: how turn off binary update log?
> 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 bin
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
= 1
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]
Su
-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 (
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
>
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
Comments inline below.
On Wednesday 09 January 2002 18:13, Paul DuBois wrote:
> At 17:23 -0800 1/9/02, Kyle Hayes wrote:
[snipped replication explanation]
> >The program works by getting the contents of the update log and using
> > the Perl DBI do() function on each statement.
>
are using various versions of MySQL, but all 3.23.x
>series. We are slowly upgrading to the latest version 3.23.47.
>
>I don't know the version of the MySQL Perl DBI libraries we use, but they
>are not too old. We have mixed Red Hat and SuSE systems.
>
>The program works by ge
. We are slowly upgrading to the latest version 3.23.47.
I don't know the version of the MySQL Perl DBI libraries we use, but they
are not too old. We have mixed Red Hat and SuSE systems.
The program works by getting the contents of the update log and using the
Perl DBI do() functi
Hi,
I just updated a new database with the update log from another server, and
the script failed on the LOAD DATA INFILE commands that I have to import
data overnight from other sources, because, of course, those files didn't
exist.
Now, I know I can use --force to allow the script to com
>Description:
To make myself clear, I am talking about the binary update log file.
When specifing a fixed filename in my.cnf and running the flush-logs command
(via mysqladmin) MySQL does not close the file and open the new file when
run by a logrotate script. This does work correctly if no
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 potentia
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 i
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
plication, is out unless I upgrade, then
may not be what I want to do anyway (I haven't digested the manual on this
yet). The manual doesn't reccomend using the update log. And my version
doesn't support mysqlhotcopy.
So, who is responsible for what in the back-up department?
I
s for your help, I'm not totally stupid, it's just that I seem to have
a fog in front of my eyes.
Joe
>that's just me.
>
>hth.
>
>-ravi.
>
>-Original Message-
>From: Joe Taraba [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, July 04, 2001 1:48 PM
>To: [E
h.
-ravi.
-Original Message-
From: Joe Taraba [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 04, 2001 1:48 PM
To: [EMAIL PROTECTED]
Subject: Replication, update log, mysqldump???
Hi;
I'm trying to learn MySQL, having some difficulties understanding backup
strategies.
mysql
eferring to all the
changes in appendix "F. MySQL change history" that would take some REAL
time to sort through.
>- Original Message -
>From: "Joe Taraba" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Wednesday, July 04, 2001 1:4
I think you can check this link
http://www.mysql.com/documentation/mysql/bychapter/
- Original Message -
From: "Joe Taraba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 04, 2001 1:47 PM
Subject: Replication, update log, mysqldump???
> Hi
four
ways to go:
Replication
update log
mysqldump
mysqlhotcopy script
The mysqlhotcopy script is apparently not available for my version so I
manually backed-up (copied) all the *.frm, *.MYD, and *.MYI files for each
database, so I know the usefulness of that approach--sort'a.
I tried mysql
. For the
life of me, I cannot find the update log! I've even run a find on the
entire machine. Any ideas as to where it may be or why it did not get
generated? The error log shows nothing unusual.
Thanks!
Paul
**
Hi
You can find that information in the Changes History in the MySQL
Manual.
Bye,
Benjamin.
On Thu, Mar 29, 2001 at 11:41:39AM +0100, [EMAIL PROTECTED] wrote:
> Hi
>
> When did the option log-slow-queries become available.
>
> It works on my 3.23.33 setup, but not on a 3.22.32
[...]
Hi
When did the option log-slow-queries become available.
It works on my 3.23.33 setup, but not on a 3.22.32
Thanks
Simon
--
Simon Windsor
CricInfo http://www.cricinfo.com/
Tel: +44 (0) 1249 700744
Fax: +44 (0) 1249 700725
Email: mailto:[EMAIL PROTECTED]
This email message is for the sole u
Hi,
I have looked, again, in the manual and can't remember ever reading about
this - but is it possible?
I have one server with multiple databases. One of these databases fills the
update log up to 2Gb limit in days (and I am not too bothered about logging
that stuff anyway. we have txt
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/
Are entries in the update log recorded in the *exact*
order that the SQL 'hits the database'?
I am using mysql version 3.22.22.
I would normally assume the log was accurate but someone just
told me that with mySQL log entries can be out of order by a few seconds
because diffe
I'm running mysql with --log-update=update_log with no
extension, so every time I flush the logs I get the next
sequential number appended as an extension to the new
update_log file. If I flush the logs regularly every
day, that sequence number will continue to grow - is
there any way to reset t
37 matches
Mail list logo
