pocketfullofcheese

less info
116 reputation
14
bio website pkp.sfu.ca
location
age
visits member for 2 years
seen Apr 27 at 20:01

Apr
26
awarded  Notable Question
May
31
awarded  Popular Question
Aug
28
awarded  Editor
Aug
28
awarded  Supporter
Aug
28
revised how to use a different tmp dir for INTO OUTFILE select with MySQL?
added 287 characters in body
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
haha. upvoted for creativity. However, my problem is that SELECT ... INTO OUTFILE writes to /tmp regardless of where you specify the output. mysql -e does not let me format the output the way INTO OUTFILE does (specify delimiter, escape char, line ending, etc)
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
Can you explain how the query below is related to the mysqldump part? I see only a SELECT ... INTO OUTFILE statement below and the --tab part of the mysqldump command above; where is the connection?
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
wait, the second option does not allow me to format the output. I wanted to use terminated by, escaped by, and lines terminated by
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
the second option might get around that. I will give it a try!
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
I am specifying another location, but mysql seems to do the sorting or otherwise using a tmp file before writing it to where I specify
Aug
28
comment how to use a different tmp dir for INTO OUTFILE select with MySQL?
yes, on a different partition
Aug
28
awarded  Student
Aug
28
asked how to use a different tmp dir for INTO OUTFILE select with MySQL?