10 columns, presumably the line with "address" and "zipcode", not
the line with "first_name" and so forth.
> How did it find that row when the fields are NULL?
I believe it isn't. Do the query with "\G" instead of ";" on
On Fri, Feb 25, 2005 at 06:43:50PM +0100, Jochem van Dieten <[EMAIL PROTECTED]>
wrote:
>
> Don't you think it is childish to link to documentation from 2003?
I've never seen a child do anything like you describe.
-R
is a bit complex -- see
http://www.danga.com/words/2004_mysqlcon/mysql-slides.pdf for an
overview.
(My kit at the same facility was hit too, and recovered correctly, for
what it's worth. :-)
At least this mailing list has progressed beyond "Why didn't they have
a UPS?&q
u know you'll be complaining that MySQL isn't ACID-compliant
because it can't survive a fire.
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus!
http://www.lafferty.
#x27;t matter at all if you end up running a command
that puts your password in the output of 'ps'! Command lines are always
public information. Put the password for mysqldump in the running user's
~/.my.cnf instead, and tighten the permissions on *that* file.
[client]
password=Yo
ISAM proved
sufficient in that application). If you can duplicate what I
saw then it might be worth following up with MySQL AB after testing
in the latest MySQL release.
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacific
---+
> | addtime(now(), '00:60:00') |
> ++
> | NULL |
> ++
> 1 row in set, 1 warning (0.00 sec)
^^
Did you check the warning (with SHOW WARNINGS)?
-Rich
--
nt to do under
the license's terms. The mailing list is probably a bad place to turn
for legal advice (which, incidentally, I am not giving you right now
:-).
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacif
te a table that contains a timestamp, and have a process
there keep updating the timestamp with the current time every, say, 30
seconds or a minute. On the slave, read that row and compare the current
time to the value in it; if they're more than, say, twice the upda
