MySQLのCSVエクスポート

# mysql -u root -p

mysql> grant file on *.* to username@localhost;（ユーザーにファイル出力権限を付与）

$ mysql -u username -p databasename

mysql> select * from tablename into outfile "/tmp/dump.csv" fields terminated by ',' lines terminated by '\r\n';