Export Table To TXT File

[lintz]

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

I've tried the below without any success.

SELECT * FROM mytable INTO OUTFILE 'C:\file.txt' 

[visualAd]

SELECT * FROM mytable INTO OUTFILE 'C:\\file.txt'

The mysql user will need to have he appropriate permissions to do this.

[lintz]

Thanks but no text file is created and nothing is exported.

This is my code. Have I got the coding correct?

$query = "SELECT * FROM mytable INTO OUTFILE 'C:\\file.txt'";
$result = mysql_query($query); 

[The Hobo]

Are you using two backslashes or one?