As CMS I use Wordpress. I want to export a whole category (windows 8) so 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 cannot export as SQL (there is no option) - strange. Is there a way to export only selected tables as SQL?