You need to select into dumpfile instead of outfile. See the section of the manual on select syntax:
http://www.mysql.com/doc/en/SELECT.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]