wordpress のデータを mysql から csv に出力

SELECT p.ID, p.post_name, p.post_title
FROM wp_posts AS p
INTO OUTFILE '/tmp/wp_posts.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

参考：
http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format