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

• Route OpenVPN Connections Through Floating IP
• How to Configure a Floating IP in a VPS (Hetzner)
• Set OpenVPN to Listed on a Specific IP Address
• Bash Trim Leading and Trailing Whitespace from a String
• Bash Get Name of Ethernet Network Interface
• VPN Providers with Dedicated Static IP Address
• OpenVPN Iptables Rules
• WireGuard VPN Iptables Rules

Updated Posts

• AMD Chipsets & Graphics Card Drivers for Windows 7, 8, 10
• AMD Radeon 7400 Drivers for Windows 10
• How to pass custom command-line parameters in InnoSetup
• Add Desktop shortcut for all Windows PC users
• Programmatically create desktop icon with InnoSetup
• GeneratePress - a Lightweight WordPress Theme 2021
• InnoSetup disable DesktopIcon via command-line
• Use cURL to authenticate with JWT Bearer tokens