Export comments WordPress plugin

I launched a new WordPress plugin to export a blog’s comments. Specifically, this plugin creates a tab-delimited text version of the wp_comments database table. Options include approved, pending or spam (or any combination of) comments.

This page will soon expand. For now…

Download this plugin from WordPress.org

15 Comments so far

  1. Anil Selarka on February 13th, 2011

    Where does the exported comments go? We do not get any information about location of the files.

  2. Corey on February 13th, 2011

    Anil:

    There is no “save to disk” feature yet. Here are the instructions I included with the plugin:

    “Activate the plugin and visit the “Export comments” page under Settings. Choose what type of comments you wish to export and click the Export comments button.”

    After that, the exported data is sitting right in front of you on the page in a textarea.

  3. CambriaMaven on March 2nd, 2011

    This plug-in is just what I needed. The only thing that would make this closer to perfection would be to include the WP title the comment was made on, instead of just the post ID. But since I can still accomplish this in a 3 step process (combining the output from export to text with the output from this plug-in), I’m definitely not complaining.
    Thanks for your work and for sharing it.

  4. Corey on March 2nd, 2011

    CambriaMaven:

    Thanks for your feedback. Right now, the export is just a complete dump of the wp_comments database table.

    I am certainly open to more of your suggestions if you’d like to influence a future release. I don’t have any grand plans since it already meets my simple needs.

    Thanks again

  5. Greg on June 6th, 2011

    great plugin! how would you go about re-importing the comments in another wordpress blog?

  6. Corey on June 6th, 2011

    Greg:

    You might find it easier to back up and restore comments using phpMyAdmin to export an SQL statement. This plugin creates delimited data.

  7. Greg on June 6th, 2011

    yes that’s the conclusion i came to as well. Thanks Corey

  8. jenn on June 9th, 2011

    This was just what I was looking for! I needed a way to get my comments out and organized for a contest. Thank you!

  9. bee on July 11th, 2011

    This really helped me, thank you!

  10. Ian Douglas on August 16th, 2011

    I get the following error on a 64M (php.ini) WordPress install:

    Fatal error: Out of memory (allocated 65798144) (tried to allocate 49 bytes) in /home/bikyaweb/public_html/wp-includes/wp-db.php on line 1383

    Any ideas of a fix?

    thanks

  11. Abhishek on August 30th, 2011

    Thanks my friend.

    I needed it for reporting against spams.

    The copied data can be saved as csv too.

  12. Jason on September 14th, 2011

    Nice plug-in, but I’d like to export my comments that are in the Trash, too. Is there any way to do that? Or can you add that feature for the next version?

  13. Michael E. Rubin on December 7th, 2011

    Hi Corey,

    Our admin installed the plug-in this afternoon. It seemed to work fine at first. Now, whenever I click “Export Comments” nothing happens. It just hangs and the screen goes blank.

    Any ideas?

    At your service,
    Michael E. Rubin
    mrubin@redbox.com

  14. Corey on December 7th, 2011

    Michael:

    If the screen goes blank, you might be hitting a 500 error. Can you check the log for an error?

  15. Tore on December 20th, 2011

    Thank you very much! You just saved me about two hours of work!
    Thank you for sharing!

Leave a reply

 

Thanks for reading!

Sign up for email updates: