Skip to content

Instantly share code, notes, and snippets.

@mshuler

mshuler/wp_comments csv export

Created October 5, 2010 20:36
Show Gist options
  • Save mshuler/612283 to your computer and use it in GitHub Desktop.
Save mshuler/612283 to your computer and use it in GitHub Desktop.
Download ZIP
export wordpress commenter info
Raw
wp_comments csv export
SELECT comment_author, comment_author_email, comment_content, comment_parent
INTO OUTFILE '/tmp/comment_export.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM wp_comments;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment