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

• NodeJs Request.Get Example with Error Handling
• NodeJs HTTPS.Get Example with Error Handling
• How to Find PHP.ini Location
• How to Enable Display of Errors in PHP
• Go One Directory Level Up/Back with Dirname() in PHP
• Save a String to File in Python
• Create a File Name with Current Date & Time in Python
• Get Current Script Path in Python

Updated Posts

• Compress Word, Excel and PowerPoint Office Documents
• Download OpenVPN 2.4.7 and TAP-Windows
• api-ms-win-crt-runtime-l1-1-0.dll is missing
• jQuery Get File Extension Before Uploading File
• Estimate Number of Visitors and Pageviews of any Website
• How to Configure OVH Email POP3 with Thunderbird
• Simple jQuery File Upload SimpleUpload.js
• Repeat AJAX GET Until a Specific Response is Met in jQuery