MySQL to CSV

With mysqldump you can only create a CSV file if you have permission (and access) to the database server filesystem. So if you have a remote database server, you can use the following:

mysql -u[username] -h[server] -p[password] -B
  -e "select * from database.table"
  --default-character-set=utf8 > dump.csv