Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

As Cms I use Wordpress I want to export a whole category (windows 8) and I run the SQL command :

SELECT * FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
WHERE (wp_term_taxonomy.term_id = 15
   AND wp_term_taxonomy.taxonomy = 'category'
   AND wp_posts.post_type = 'post'
   AND wp_posts.post_status = 'publish');

I get the tables but then I can not export as SQL (there is no option) - Strange , is there a way to export only selected tables as SQL ?

enter image description here

share|improve this question
odds are that it cannot generate the corresponding sql as it touches multiple tables. you will need to export each table to generate the sql. otherwise, suck it up and export to csv and write your loader –  billinkc Oct 26 '13 at 17:25
add comment

Your Answer


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

Browse other questions tagged or ask your own question.