I've been reapplying transactions to my aforementioned screwed up database.
It seems however, that the binary transaction log doesn't quite work
properly
with user variables (with MySQL 3.23.38). I have this entry from the log:
insert into Projects (ParentID, Name, LongDesc) values (@customer, "VPN",
"VPN Work");
I remember doing that transaction, and I'd done a "SELECT @customer:=ID
WHERE ..."
beforehand. Since that SELECT isn't stored in the binary log (that I can
find), the value
for @customer is NULL.
This just seems like a bug to me (I know what my SELECT was, so I've redone
it, but
this would be a problem for large-scale restoring).
PS. Now I feel like I'm flooding the list, but that's ok ...
--
Michael T. Babcock
CTO, FibreSpeed
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
