All,
I have a situation whereby I have two servers each running mysql in a Master
slave replicated setup.
Currently if the master server goes down we have to manually failover the
database servers, taking a snaphost etc..
Is this still the optimal way to do this, or has the 'Change Master'
command
sorry, I had some extraneous quotes in my perl code:-) zzz
- Original Message -
From: "Martin Moss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 15, 2003 11:17 PM
Subject: Order By question
> I have a query:-
> SELECT rec
I have a query:-
SELECT recTran.TransactionID,tr.* FROM Transaction tr LEFT OUTER JOIN
ReconciledTransactions recTran ON recTran.TransactionID = tr.TransactionID
WHERE tr.ReconciliationID = '8' HAVING recTran.TransactionID IS NULL ORDER
BY 'tr.Amount' DESC;
The problem I have is that the Order By
--- Original Message -
From: "Martin Moss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 10:47 PM
Subject: Re: Select from one table where ID not in another table
> I'm not sure if I've described the exact results I want v
else the "IS NULL" or "NOT NULL" won't work. You might
try...
>
> SELECT table1.*, table2.id FROM table1 LEFT JOIN table2 ON
> table1.ortherkeyid = table2.otherkeyid WHERE table1.otherkeyid = '7236523'
> AND (table2.otherkeyid IS NULL or table2.otherkeyi
r otherkeyid I still want to get
table1.*
Regards
Marty
- Original Message -
From: "Martin Moss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 9:49 PM
Subject: Select from one table where ID not in another table
> All,
>
&g
r otherkeyid I still want to get
table1.*
Regards
Marty
- Original Message -
From: "Martin Moss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 02, 2003 9:49 PM
Subject: Select from one table where ID not in another table
> All,
>
&g
All,
Am wondering if it's possible to do a query that does something like this:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.id DOESN'T EXIST IN table2.id;
Regards
Marty
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://ww
All,
Am wondering if it's possible to do a query that does something like this:-
SELECT table1.*,table2.id from Table1 AS table1,Table2 AS table2
WHERE table1.id DOESN'T EXIST IN table2.id;
Regards
Marty
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.
Is it giving you access denied, or is it failing to find the host machine?
if it's access denied you will need to add the username and hostname (of
whichever machine you are connecting from) and grant that user access.
use the 'mysql_setpermission' script to do this.
If you can't actually see the m
Thanks to everyone who Helped,
Regards
Marty
- Original Message -
From: "Joseph Bueno" <[EMAIL PROTECTED]>
To: "Martin Moss" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 24, 2003 3:56 PM
Subject: Re: New Group By, order by quest
All,
I have a question about grouping numbers.
Lets say I have 10 records each containing a numeric value:-
1
2
3
5
10
-1
-2
-3
-4
-5
What I wish to do is to select the records from the database but group them
like this :-
e.g. by the highest value (ASC or DESC) regarldess of whether the value
Hi,
Just a quick high level design question?
Is mirroring only a one way action?
i.e. one in use database and one backup database?
Or is it possible to use both databases and they'll both update each other?
Regards
Marty
-
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Martin Moss
> Sent: Wednesday 07 June 2000 16:03
> To: Perl-Win32-Users Mailing List; [EMAIL PROTECTED]
> Subject: Corruption of Database
>
>
> All,
>
> I
14 matches
Mail list logo