Quickly scanning this page, it doesn't seem to give syntax for an
incremental backup. I am hoping to be able to run something that dumps
only data changed since the last backup.
Rob Wultsch wrote:
On Wed, May 14, 2008 at 10:25 PM, John Comerford
[EMAIL PROTECTED] wrote:
2) Incremental
Hi,
I have installed MySQL on an Opteron 64bit with operating system Scientific Linux CERN SLC release
4.6 (Beryllium)
by an archive TAR, under the directory /opt/local/mysql50.
The problem is that I want to install drivers DBD to use MySQLBenchmark but i
run
perl Makefile.PL
On Wed, May 14, 2008 at 11:13 PM, John Comerford
[EMAIL PROTECTED] wrote:
Quickly scanning this page, it doesn't seem to give syntax for an
incremental backup. I am hoping to be able to run something that dumps only
data changed since the last backup.
You could use diff and the previous dump
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value to
a table on insert if postcode = 1000.
this is how i did it:
delimiter |
drop trigger testdep|
create trigger testdep
before insert on departements
I've overcome the problem by using a RichText memo box. Thanks for your help
in any case.
Neil
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: mysql@lists.mysql.com
Subject: RE: replace chr(10) in field Date: Wed, 14 May 2008 19:18:07 +
I thought this, but when I display the
Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right answer? Maybe i'm missing something or am i doing
something wrong?
mysql select (11.11-FLOOR(11.11))=0.11;
++
| (11.11-FLOOR(11.11))=0.11 |
On Thursday 15 May 2008 13:24:10 Adam de Zoete wrote:
Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right answer? Maybe i'm missing something or am i doing
something wrong?
Perhaps it is performing FLOAT and not DECIMAL math. 11.11 is represented
If both (user_id,delivery_id) can be made primary key, then the second index
would not be required. But the performance of the query would be better if
it reads one index rather than indexes on each COLUMN in the WHERE CLAUSE
On 5/15/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi,
Don't feel bad, many an experience programmer has been bitten by this.
The problem is that many decimal fractions do not have exact representations
as binary fractions. .01 is an example of this.
I'm not sure how MySQL does arithmetic internally, but (11.11 - 11) is just
a hair under .11:
mysql
-Original Message-
From: Adam de Zoete [mailto:[EMAIL PROTECTED] On Behalf Of
Adam de Zoete
Sent: Thursday, May 15, 2008 6:24 AM
To: mysql@lists.mysql.com
Subject: Floor Decimal Math
Hi,
I'm running mysql 4.1.20 (Mac OS 10.4.11) and wondering why this ain't
returning the right
Locking will ocours with MyISAM tables when INSERT, UPDATE, DELETE or REPLACE
statemats arrive that tables, lock at the table level. In INNODB engine, a lock
ocours at the row-level.
BDB have lock at the page-level.
Wagner Bianchi
Diretor de Tecnologia - INFODBA CT
[EMAIL PROTECTED] - (31)
mysql reset master;
Wagner Bianchi
Diretor de Tecnologia - INFODBA CT
[EMAIL PROTECTED] - (31) 3272 - 0226 / 9114 - 7695
- Mensagem original
De: Kaushal Shriyan [EMAIL PROTECTED]
Para: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Enviadas: Domingo, 11 de Maio de 2008 13:39:02
hi,
I have a table with tasks. column status could be 1 (means todo) and
0 (meas done).
also,have column order_no to sort tasks by priorities.
once in a while order_no is not in order, e.g 1, 2, 3, 5, 6, 8, 11,
12, 13, 19, 20,... (some numbers are missing).
is there built in function to reset
On Thu, May 15, 2008 at 2:30 AM, rustam ershtukaev [EMAIL PROTECTED] wrote:
I have been trying to write a trigger in mysql, but can't get it to
work. It's really simple,i just need my trigger to add varchar value to
a table on insert if postcode = 1000.
this is how i did it:
delimiter |
On Thu, May 15, 2008 at 11:38 AM, afan pasalic [EMAIL PROTECTED] wrote:
is there built in function to reset order_no or I have to create php
script for it?
There is not a built in way to do this. Using a user defined variable
it is not all that hard to deal with though
mysql drop table if
What about:
ALTER TABLE tablename
ORDER BY fieldname;
HTH, Cor
- Original Message -
From: Rob Wultsch [EMAIL PROTECTED]
To: afan pasalic [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Thursday, May 15, 2008 8:23 PM
Subject: Re: reorder records in database
On Thu, May 15, 2008
On Thu, May 15, 2008 at 4:32 PM, C.R.Vegelin [EMAIL PROTECTED] wrote:
What about:
ALTER TABLE tablename
ORDER BY fieldname;
HTH, Cor
First off, please don't top post if a conversation is not already top
posting. It is the custom of the group to bottom post...
Your solution does not remove
I have worked as a DBA for a long time, just not with MySQL and I have
spent a lot of time making sure the application is secure. I suppose my
question was really what is the best way to do incremental backups? The
DB I have most experience with has thing like after imaging etc. which
allows
[take 2]
--
Philip M. Gollucci ([EMAIL PROTECTED])
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C
Work
19 matches
Mail list logo
