HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

There is no export as SQL option

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
sqloptionthereexport

Problem

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?

Solution

I get this effect only when applying a query.

A table, view, or other direct structure seems to export into SQL fine.

The SQL option seems is not available to a query result set, very sadly.

Context

StackExchange Database Administrators Q#52269, answer score: 3

Revisions (0)

No revisions yet.