Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

If I would export a WordPress database, posts and comments etc. are saved to an XML file.
Would comment metadata be included in this XML file?

I.e. the table wp_commentmeta, mentioned here: http://codex.wordpress.org/Database_Description#Table:_wp_commentmeta.

Here:
The WordPress eXtended Rss (WXR) Export/Import, XML Document Format Decoded and Explained
I found some info on the export file format, and the columns in wp_comments are mentioned, but there's no mentioning of any columns in wp_commentmeta.

Edit: Background: I'm planning to write a new commenting system for WordPress, and I'd like to be able to import/export comment data between various blog platforms. (E.g. Blogger and others.) And I think I need to use the comment metadata table. /Edit

Kind regards, Magnus

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

My latest export from my blog (WP 3.3.1) now has the commentmeta in the XML. It's in this format:

        <wp:comment>
        <wp:comment_id>...</wp:comment_id>
        ...
        <wp:comment_user_id>0</wp:comment_user_id>
        **<wp:commentmeta>
            <wp:meta_key>name_of_meta</wp:meta_key>
            <wp:meta_value><![CDATA[value_of_meta]]></wp:meta_value>
        </wp:commentmeta>**
    </wp:comment>

I was looking for information on it while trying to write an exporter from another system. Not much information available online so I tried an export from a well-used blog--it was there!

share|improve this answer
    
Yes, indeed, here in version 3.3 of export.php it's being exported. It's present in v 3.2 but not in 3.1 (which is the version Jan Fabry's answer conserns). Thanks! –  KajMagnus Apr 19 '12 at 12:29
add comment

Looking at the export code, it seems comments don't include comment meta information. The lines above it explicitly include post metadata, but I don't see a query for comment metadata.

share|improve this answer
    
Thanks. How sad, now it'll be much more complicated to write a custom discussion plugin that uses comment metadata, and can be exported/imported between different blog platforms. -- Also, how silly, I cannot upvote your answer: "Vote Up requires 15 reputation". –  KajMagnus Mar 26 '11 at 2:06
    
Thanks for the link to export.php, I found it very interesting, didn't know where to find the export file format documentation but it's in that file :-) –  KajMagnus Mar 26 '11 at 2:10
    
Nowadays it's included, from v 3.2 and onwards it seems, here. –  KajMagnus Apr 19 '12 at 12:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.