I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
into outfile 'test123.csv'
FIELDS terminated by ','
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).
a) What is going on?
b) How do I fix it?
Thanks so much!!
|Query_cache instance creation||0|
|Need Help Converting Character Sets||7|
|Can other mysql-using progs interefere with config?||2|
|Select data from large tables||0|
|localhost vs domain for connection string||6|
|Seems like an easy query, but isn't to me. Help?||2|
|Re: backfill results for the same month and year||0|
|Re: migrate existing data each additional product||0|