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 initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html
Does that mean it tried to create the tmp table as an innoDB table instead of MyISAM and I need to get innodb_data_file_path set to correct it?
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]