Chad Callihan makes a comparison:
I haven’t had a MySQL post for awhile, so it’s time to add some variety to the blog.
There are a couple of different ways to export data with a SELECT query in MySQL: INTO OUTFILE and INTO DUMPFILE. Let’s use the MySQL Sakila sample database and walk through some examples to compare these two options.
Read on to see when you might want to use each of these.