I ma connected to the MySQL Server by a trusted connection on a remote PC using work bench
I am using the Select * into OUTFILE statement
into OUTFILE 'C:\\testexport1.xls'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
This is working but is exporting the file to the server instead of my PC, how do I get the file to be exported to my PC instead of the server.