I think this is the problem (cited from mysqld.log)
Some pointers may be invalid and cause the dump to abort...
followed by my query to create the tmp table
But I am not sure how to fix it.
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:ht
Hi,
The max packet site is 1048576. But I don't think it is a problem cuz I
have successfully outputted the result of this query before. I checked
mysqld.log. This is the tail I think might related to the problem:
Number of processes running now: 0
040406 22:22:01 mysqld restarted
Cannot initi
f 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 an
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