There is no export as SQL option
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?
phpmyadmin
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
add a comment |
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?
phpmyadmin
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
3
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
2
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38
add a comment |
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?
phpmyadmin
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
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?
phpmyadmin
phpmyadmin
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
edited Nov 30 '14 at 9:08
Michael Green
14.5k83060
14.5k83060
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
asked Oct 26 '13 at 17:07
tarkan dosttarkan dost
2612
2612
3
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
2
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38
add a comment |
3
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
2
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38
3
3
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
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
2
2
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38
add a comment |
3 Answers
3
active
oldest
votes
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.
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
add a comment |
its bug or they forgot it
they have fixed it on phpmyadmin 4.8.5 you should update
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
just select the database and visit the export section.
it happens when you select the table only.
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f52269%2fthere-is-no-export-as-sql-option%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
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.
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
add a comment |
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.
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
add a comment |
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.
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
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.
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
answered Jul 24 '14 at 18:58
MarcosMarcos
1313
1313
add a comment |
add a comment |
its bug or they forgot it
they have fixed it on phpmyadmin 4.8.5 you should update
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
its bug or they forgot it
they have fixed it on phpmyadmin 4.8.5 you should update
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
its bug or they forgot it
they have fixed it on phpmyadmin 4.8.5 you should update
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
its bug or they forgot it
they have fixed it on phpmyadmin 4.8.5 you should update
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
answered 7 mins ago
Aphiwat ChawilaiAphiwat Chawilai
1
1
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Aphiwat Chawilai is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
just select the database and visit the export section.
it happens when you select the table only.
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
add a comment |
just select the database and visit the export section.
it happens when you select the table only.
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
add a comment |
just select the database and visit the export section.
it happens when you select the table only.
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
just select the database and visit the export section.
it happens when you select the table only.
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
answered Jan 17 at 10:32
Nilanjan RahaNilanjan Raha
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f52269%2fthere-is-no-export-as-sql-option%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
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
2
Or you can use SELECT INTO to create a table, populate it with the needed data and then export the table to the SQL dump.
– BuahahaXD
Apr 7 '15 at 15:38