MySQL Dump Snippets

mysqldump -h example.com -u admin -padminpass sales_db orders > orders_dump.sql

mysql -h example.com -u admin -p sales_db -e "SELECT * FROM orders INTO OUTFILE '/tmp/orders.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n';"