As a follow up on this, when I run the query you posted
Code:
SELECT * FROM npc_types WHERE isbot=1 INTO OUTFILE 'bots.txt'
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
Without the 'c:\' it dumps the bot.txt file on the server in the /var/mysql/ax_classic/
so what it tries to do is dump the file where the server is. and looks at whatever you put in 'c:/bots.txt' as the whole file (windows must default to C:\ , Linux to /var/mysql/database/)