but I didn't have any question, only
let you know that it is a bug and I thought it justified the email to that
list.
-
Regards,
Rod~
> -Original Message-
> From: Sasha Pachev [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 10, 2001 6:56 PM
> To: Rodrigo Zer
It has been a interesting experience... but it is not reliable enough,
unless I am doing something wrong...
I have MySql() on Mandrake. Installed 1 master 2 slaves.
One slave do a full backup and the other partial (some tables only).
All work fine, except when I get an error and it tries to recon
eplication engine should keep the qualification
on the table name.
-
Regards,
Rod~
> -Original Message-
> From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, September 09, 2001 3:57 AM
> To: Mysql@Lists. Mysql. Com
> Subject: RE: URGENTE - Replicati
od~
> -Original Message-
> From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, September 08, 2001 7:58 PM
> To: Mysql@Lists. Mysql. Com
> Subject: URGENTE - Replication..
> Importance: High
>
>
> Can not find the problem and we are down!
>
> H
Can not find the problem and we are down!
Here the question again (Any advice on replication of "LOAD DATA INFILE"
is very appreciated.)
I setup a mster-slave. My master does a lot of :
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME FIELDS
TERMINATED BY '\t
I setup a mster-slave. My master does a lot of :
LOAD DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';
I changed from "LOCAL" because the docs states:
LOAD DATA INFILE will be handled properly as long as the file still resides
on the
|| ID
like '%,$value,%' || ID like '%,$value'
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:50 PM
> To: Rodrigo
select ID from TABLE_NAME where ID like '%value%'
or I misunderstood the question.
-
Regards,
Rod~
> -Original Message-
> From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
> Corp.]On Behalf Of MikeBlezien
> Sent: Tuesday, July 10, 2001 10:38 PM
> To: [EMA
Is there a way to build a similar SQL that would work on mySql (I use this
on Oracle):
delete from TABLE_NAME where COL1 not in (
select distinct COL1 from TABLE_NAME where COL2 ='SOMETHING')
-
Regards,
Rod~
-
Before
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
>Description:
INSTALL-BIN f
10 matches
Mail list logo
