RE: Lost Connection executing query

[Imran Chaudhry]

The fact that on your Mac installation you re-imported your table data
makes me think it's an index efficiency issue. I have seen MySQL just
lose the connection if the join becomes massively big. On re-import,
the indexes would have been rebuilt and your query would be able to
take advantage of the freshest indexes.

A bit crude, but on your Production box can may need to do the
following on every <table> in your UPDATE:
- drop and create every index
- perform ANALYZE TABLE <table> (this will help if we ask you to
perform EXPLAIN later on)

Ideally you have a pre-Production environment with the same database
(non-replicated). I would recommend trying the re-index tactic there
first if you havne't already.

Hope that Helps,

Imran Chaudhry

--
http://www.EjectDisc.com
Get your Digital Identity - Domain Names, Web Space, E-mail & More!