Fred G Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 25, 2012; 16:02
Fred G
Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Hi--
I'm trying to do the following: SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date, db.sale.sale_no, db.sale.sale_total_amt into outfile 'test123.csv' FIELDS terminated by ',' FROM db.emp LEFT OUTER JOIN db.sale ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the file works fine, in about 12 sec/77 sec. I read online how to export MySQL queries into csv's, and I'm not sure what I am doing wrong. I keep getting the error: Error Code: 2013. Lost connection to MySQL server during query, where the duration/fetch values are 600.547 sec (~10 minutes).
I'm wondering: a) What is going on? b) How do I fix it?
Thanks so much!!
Jul 26
Dhaval Jaiswal Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26, 2012; 06:52
Dhaval Jaiswal
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26
Fred G Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26, 2012; 09:46
Fred G
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26
hsv Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26, 2012; 00:05
hsv
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26
Fred G Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 26, 2012; 15:23
Fred G
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 31
Michael Widenius Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Jul 31, 2012; 12:36
Michael Widenius
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Aug 01
Fred G Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Aug 01, 2012; 13:24
Fred G
Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!