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

• PHP Notice: Undefined offset: 1 (Array)
• How to Sleep/Wait/Pause on a NodeJs Function
• How to Run a NodeJs Script
• How to Install a Module/Package/Library in NodeJs
• 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

Updated Posts

• Detect a failing hard-disk on a Linux server
• Certbot.errors.CertStorageError: expected to be a symlink
• Example hard-disk error logs on a Linux server
• Certbot renew error: Account at does not exist.
• Suspicious online shops from helpandserving@gmail.com
• Nginx Rewrite Rule to Add Slash to The End of Any URL
• Compress Word, Excel and PowerPoint Office Documents
• Download OpenVPN 2.4.7 and TAP-Windows