Posted on April 1, 2018 at 9:40 pm
MySQL command to export data in CSV format:
SELECT id,product,quantity FROM orders WHERE foo = 'bar' INTO OUTFILE '/var/lib/mysql-csv/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; |
Use this command from bash shell to export MySQL to CSV:
nohup mysql -h localhost -u username -p'password' databasename -e "SELECT id,product,quantity FROM orders INTO OUTFILE '/var/lib/mysql-csv/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\'' LINES TERMINATED BY '\n';" > /dev/null 2>&1 & |
The above command will run in background.
Other Posts
- Detect VMWare Virtual Machine
- Detect Microsoft Virtual PC Virtual Machine
- Fix MariaDB 10.5 "Can't create test file" errors
- Use MariaDB and MySQL without Password (MySQL Backup)
- Check if a Trademark is already registered
- Make name server address permanent in /etc/resolv.conf
- InnoSetup error the servicemanager is not available
- InnoSetup disable DesktopIcon via command-line
Updated Posts
- Delphi 10 Berlin System.Hash MD5 SHA1 SHA2 Hash
- Use cURL to check for SSL certificate issues:
- How to test Socks5 proxy with cURL
- How to use variables in a sed command
- Best Socks5 Servers for Linux Debian
- Error NO_PUBKEY in Google Cloud Debian Packages Update
- How to Run a Command with Time Limit in Bash Linux
- MySQL InnoDB log sequence number is in the future