Problem: you wish to write table data to file, but you wish to do so on client side.
SELECT … INTO OUTFILE writes the file on server. What are your options on client?
1. mysql client
If you have direct access from your client machine to your DB server machine, and can connect via mysql client, you get a very customizable file write:
bash$ mysql -h db_host --execute "SELECT * FROM my_table" > /tmp/output.txt
The above writes fancy tables, so you probably want to:
bash$ mysql -h db_host --execute "SELECT * FROM my_table" --bat > /tmp/output.txt
Also try:
bash$ mysql -h db_host --execute "SELECT * FROM my_table" --silent --raw > /tmp/output.txt
To turn off headers.
More options include the –xml or –html formats. Continue reading » “Ways to export MySQL result set to file on client side”