Just so I don't forget...
I did a test of this.
select firstName, lastName from users into outfile 'tempTest9999'
Then, after creating an appropriate table...
load data infile 'tempTest9999' into table tempTest
The thing I don't want to forget is that the file was put into the directory...
/var/lib/mysql/DATABASENAME
The owner and group were both 'mysql'.
I know, it's what one would expect, but I forget these things.