MySQL dump to csv

Post date: Apr 5, 2015 2:24:58 PM

Run this in a bash script on the destination computer

echo "select * from tablename order by id asc" |mysql -p -u username databasename

You will be prompted for the password