MySQL 'INTO OUTFILE' path syntax in Windows?

When I am querying like:





SELECT * FROM table1 WHERE name LIKE '%some%' INTO OUTFILE 'C:\\bun.xls';





from a remote computer the output file: 'bun.xls' is saved in the server, and not in the local C of the remote computer. Why? Is it really like this?


What should I do in order to save/download the table data from the server to local C of the remote computer? Is there a correct syntax for path in Windows like the proper way to use // or the \ or /'s?





IIf the file already exists, how can I overwrite it? Can I also append data to the existing file? How?





O my God, I'm asking too much.... sorry. Pls help...

MySQL 'INTO OUTFILE' path syntax in Windows?
I don't know? Are you sure you can forcibly transfer a file into someone's computer?... Maybe you need to escape your slashes...? =S