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 the
end so that you see what values are in which columns.
-Rich
--
Rich Lafferty
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.
-Rich
--
Rich Lafferty
because it can't survive a fire.
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus!
http://www.lafferty.ca/|http://zapatopi.net/treeoctopus.html
[EMAIL PROTECTED
/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?, I suppose. :-)
-Rich
--
Rich Lafferty
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=Your password goes here
-Rich
--
Rich Lafferty
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 Northwest Tree Octopus!
http
|
++
1 row in set, 1 warning (0.00 sec)
^^
Did you check the warning (with SHOW WARNINGS)?
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus
not giving you right now
:-).
-Rich
--
Rich Lafferty --+---
Ottawa, Ontario, Canada| Save the Pacific Northwest Tree Octopus!
http://www.lafferty.ca/|http://zapatopi.net/treeoctopus.html
[EMAIL PROTECTED
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 update
period off, you know that updates aren't getting replicated.
Cheers,
-Rich
--
Rich Lafferty