(included in download), Apache / Mysql / PHP /
Visual Basic 6 (blech).
Rules / Licence : No cost, no obligation, no warranty, no guarantee of
fitness, usability or support. Do what you will with it.
Shower me with praise at [EMAIL PROTECTED]
Criticisms to /dev/null. :o)
David Shields
--
Never do
The MySQL manual for 3.23.38, Section 11.4 states that you can have a
replication chain A - B - C - A.
I guess this means
A Master B Slave
B Master C Slave
C Master A Slave
Can this loop be reduced to the most trivial case A - B - A ? If so, it
would help me with a roving laptop issue I have.
Probably a very simple one for you guys, but I'm stuck.
Given a simple table (events):
id int
st time not null
et time not null
I know I can get duration by converting st and et to secs and subtracting
(that bits easy), but how would I go about getting the gap between
successive
It's late, and I'm being dumb, so can anyone help ?
I know that
select customer.custcode, bookings.cust from customer left join bookings on
customer.custcode=bookings.cust
where bookings.cust is null;
will show me all customers with no corresponding entry in bookings table.
But I want to
I've asked this before, but let me describe it another way, and see if
anyone has any bright ideas:
My client has 3 offices.
Each office needs to use same app (over MySQL).
Each office needs (effectively) same database.
Updates done at each office need to be used at other offices.
Updates
Hi, I was wondering if any of you clever people out there can help me. I
have a client with a problem I'm sure some of you have fixed in the past ...
Client has 3 geographically separate sites, running same application (mine,
of course) and generating data on MySQL database.
Periodically
You wrote:
What about mysqldump? See http://www.mysql.com/doc/m/y/mysqldump.html
for more info about mysqldump.
well, no, not really :
site1 - has apache / php / mysql + database x
site2 - has apache / php / mysql + database y
site3 - has apache / php / mysql + database z
at 9:00 am all
Alright then!
database,sql,query,table
Which field type do I use for a simply checkbox Y,N?
Thanks
Any objection to this ?
cbcolumn enum ('Y', 'N') NOT NULL DEFAULT 'Y'
May not be the most space efficient, but its clear, self-documented and
unambiguous.
It does what it says on the tin.
A few weeks ago there was a flurry of postings re a security hole in MySQL
(including flames about whether or not the message should have been posted,
but that's a different issue.
Are there any status updates regarding this problem ? Fixed / Gone away /
never there in first place ?
Info
Joe:
AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a
permissions problem somewhere.
On NT4 these can be a swine to solve. Check out your NT system error logs
as a starting point.
HTH.
David
By the way, I once first tried to set up the slave on a NT machine. But
10 matches
Mail list logo