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.

I want to export and export only the Categories and their description using SQL. For now I've managed to retrieve them using this:

SELECT
    wp_term_taxonomy.description,
    wp_terms.term_id,
    wp_terms.name,
    wp_terms.slug
FROM wp_term_taxonomy
    JOIN wp_terms ON ( wp_term_taxonomy.term_id = wp_terms.term_id )
WHERE wp_term_taxonomy.taxonomy = 'category'

I need some advices on how do to this so I can not screw up the blog. I mention that on the new blog I do not have these categories.

share|improve this question
add comment

2 Answers

How about just backing up those two tables using phpMyAdmin as detailed in the codex article on wordpress backups?

share|improve this answer
add comment

The best solution is to setup a backup routine for your SQL database which I maintain.

Using DBC Backup 2 you can setup a schedule and trigger a manual backup anytime you like. This way you can then muck around with categories or posts or other settings and have the confidence you can use your SQL backup if needed

share|improve this answer
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.