What is your max packet size? Are you able to determine where the `error` occurs in the process? During the load of the temporary table? During the query of the temp table?
On Wed, 07 Apr 2004, Ginger Cheng wrote: > Hello, MySQL gurus, > I have been trying to output the result of some large query to a temporary > table and then query from there. But all my trials ended up 'ERROR 2013 at > line 7: Lost connection to MySQL server during query' before creating the > temporary table. The version of MySQL is 3.23.54, for redhat-linux-gnu > (i386). Does anyone have any idea of how to prevent this from happening? > Thank you for help > ginger > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
