Export output to file

1. mysql -u<user> -p<pass> [-h<host>] <database> -e "select cols from table where cols not null" > /tmp/output

1. SELECT order_id,product_name,qty.

FROM orders.

INTO OUTFILE '/tmp/orders.csv'.

FIELDS TERMINATED BY ','.

ENCLOSED BY '"'.

LINES TERMINATED BY '\n'.

/tmp directory works exclusively

3. MySQL-dump

3. MySQL-dump Mysqldump <database|--all-databases> -u <user> -p --result-file=<file_name>

http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html