Can't Find File Created By OUTFILE

Question

I am trying to save contents of the table 'dbtable' into a csv file using OUTFILE method. It doesn't give me any error and I am unable to find the file either. I have tried without defining the path and using 'mydata.csv' only too. But same result. I am using wamp on Windows 10.

mysqli_query($con,"SELECT * FROM dbtable INTO OUTFILE 'C:\mydata.csv' FIELDS ESCAPED BY '\"' TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n' ");

http://stackoverflow.com/questions/11484471/cant-find-the-file-created-by-outfile-in-mysql — Virendra Nagda, Jan 07 '16 at 07:01

score 2 · Accepted Answer · answered Jan 08 '16 at 05:10

Apparently the issue was with path. It is not taking absolute path 'C:\' instead when I used relative path it worked. Earlier it was saving in /bin/mysql/data/ folder when saved without any path but using ../../../www/ enabled me to bring it to my www folder.

score 1 · Answer 2 · answered Jan 07 '16 at 20:51

Try this:

mysqli_query($con,"SELECT * FROM dbtable INTO OUTFILE 'C:\mydata.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'");

The main differences are I removed "FIELDS ESCAPED BY" as "OPTIONALLY ENCLOSED BY" should take care of that. I found very few examples where "FIELDS ESCAPED BY" worked.

Can't Find File Created By OUTFILE

2 Answers2