How do I export a table from mySQL database to a txt file?

I've tried the below without any success.
PHP Code:
SELECT * FROM mytable INTO OUTFILE 'C:\file.txt'