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

• Quota 'IN_USE_ADDRESSES' exceeded. Limit: 8.0 in region
• Only allow Google Load Balancer traffic (Firewall Rules)
• Lost connection during Debian apt-get upgrade
• Bootstrap 3 Navbar with Logo Image
• Redis HMGET, HGETALL, HSET, HGET Benchmark
• PHP GetHostByName() Slow? Make it Faster
• Use Timestamp with new DateTime() in PHP
• Calculate Elapsed Time Between Two Dates in PHP

Updated Posts

• Let's Encrypt on Nginx and SSL Grade A+
• Vertically align Facebook and Twitter share buttons
• Download Windows 10 ISO without Media Creation Tool
• DEB.SURY.ORG Updated the Signing Key (March 2019)
• Firefox add-ons cannot be verified and have been disabled
• Server Certificate Verification failed CAfile (apt-get update)
• Python Socket IPv6 (AF_INET6) Listen
• Allow User to Run Sudo Command without Password