Posted on February 20, 2019 at 8:06 pm

Simple bash script to dump a MySQL table into a CSV file:

mysql dbname -u'user' -p'password' <<QUERY_INPUT
SELECT field1, field2, field3, field4 FROM table_name
INTO OUTFILE '/path/file.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ',' 
ESCAPED BY '"' 
LINES TERMINATED BY '\r\n';
QUERY_INPUT

Make sure user mysql can write to INTO OUTFILE ‘/path/file.csv’

Else you will get a “Permission denied” error.

Other Posts

• Disable Driver Signature Enforcement on Windows 7 64-bit
• Get Local File Permissions from Command-Line on Linux
• Automatically Renew Let's Encrypt Certificates (Nginx)
• Run Shell Command And Capture Output in Python
• Python Iterate over a List in Chunks
• Run Processes in Parallel in Python
• Convert Int to String in Python
• How to Terminate a Python Script

Updated Posts

• How to Permanently Run NodeJs Script in Background
• How to Stop NodeJs Puppeteer Follow Redirects
• NodeJs How to Get GET Query String in Express.js
• Route All Internet Traffic Through Tor on Linux Debian
• NodeJs How to Split/Splice Array in Chunks
• NodeJS Error: Socket Hang Up (ECONNRESET)
• PHP Notice: Undefined offset: 1 (Array)
• Install Node.js on Debian 8 Jessie