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

• Connect as Root using WinSCP on Google Cloud Compute Engine
• Become Root on Google Cloud Compute Engine VMs
• Connect to Google Cloud Compute Engine VM via PuTTY SSH
• DigitalOcean Slow, My Experience
• Keep current version of config files when apt-get install on Debian
• How to Extract Links from a Web Page in Linux
• PHP Library for Google Authenticator (Two Factor Authentication 2FA)
• Should I reboot Debian server after apt-get upgrade?

Updated Posts

• Unable to extract and upload PackageInfo.xml
• Stop Bad Bots from Crawling Your Website
• DEB.SURY.ORG Updated the Signing Key (March 2019)
• PHP Check if XML String is Valid
• PHP Securely Save Passwords in Your Database
• Redirect 404 Errors to Homepage with Nginx
• Nginx Rewrite Rule to Add Slash to The End of Any URL
• Lost connection during Debian apt-get upgrade