Trying to Download Table but Access is Denied

[lilman]

Error Access denied for user 'lilman_sds'@'localhost' (using password: YES) with query SELECT * INTO OUTFILE 'http://www.url.com/spreadsheet.xls' FROM survery

That is the error I am recieving when I try to execute this SQL statement:

$export="SELECT * INTO OUTFILE 'http://www.url.com/spreadsheet.xls' FROM survery";

Now my user has all privileges, so does anyone have an idea as to why I am getting this problem?

[PHPSpirit]

You need use a FILE PATH for outfile no URL.

$export="SELECT * INTO OUTFILE '/home/user/spreadsheet.xls' FROM survery";

[lilman]

Alright, thank you for your reply.  I changed it to '/home2/user/public_html/spreadsheet.xls' and I still get the same error.