exporting data to txt files.. an idiots guide needed

[Lcousins]

right, today I am trying to write a page which exports all the data from a specific table nto a new txt file.

From reading the mysql manual I get the impression the following should work:

$result = mysql_query("select INTO OUTFILE '/fullpath/archive/hello.txt' from nuke_stories", $dbi);

but it doesnt. In conclusion I cant seem toget this INTO OUTFILE command to work, any ideas what I am doing wrong??

lcousins

[nemonoman]

I think you'd want to specify your columns, or *

SELECT * INTO OUTFILE

Also, per the manual:

Make sure you have write permissions in the directory.

!!!IMPORTANT!! INTO OUTFILE will NOT overwrite an existing file of the same name.