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

• How to Disable Hibernation on Windows 10
• Disable Windows Defender on Windows 10 via Regedit
• Install Latest NVIDIA Drivers for Windows 10
• How to improve security of encrypted hard disks
• Get Server IP Address with Ifconfig and IP in Bash
• bash: ipconfig: command not found
• Check if a number is within a range in bash
• Linux Commands to Check HDD from Rescue Mode

Updated Posts

• Double Opt-in Email Newsletter Made Right (by Yoast)
• Let's Encrypt on Nginx and SSL Grade A+
• Free Email Ticketing Systems for Startups
• Delphi URLEncode like PHP
• Delphi Function to Parse JSON Unicode Chars
• Ask Users What Features They Need (Product Roadmap)
• Make Your Domain Emails Not Spoofeable
• Create Documentations Easily with GitBook