Warning when using LOAD DATA LOCAL INFILE

[Fortune]

I use to LOAD DATA LOCAL INFILE to import data into mySQL table.
The result is like this:
Query OK, 3834 rows affected (0.51 sec)
Records: 3834[nbsp][nbsp]Deleted: 0[nbsp][nbsp]Skipped: 0[nbsp][nbsp]Warnings: 9

I know there is something wrong in my INFILE.
I checked the manual and tried to use:
SELECT * INTO OUTFILE 'temp.txt' FROM Table_Name;
But it showed:
ERROR 1045: Access denied for user

Is there is a way to find out why I get the warnings? Thank you!

[Terra]

Backlink reference:
http://www.aota.net/ubb/Forum15/HTML/000081-1.html

In short, 'SELECT * INTO OUTFILE' won't work as it requires the 'File_priv'...

--
Terra
sysAdmin
FutureQuest