exporting mysql in mamp-not letting me save file as sql?
This is a weird thing I haven't seen as I'm usually working on a live server. On my MAMP, when I try and export the database, it just opens the file within phpmyadmin-like as a text document. I tried to copy the file to a text document with and gave it a .sql at the end, but that gave me an error when trying to import to the live server. When I try an export from the live server, I get the save location dialog box popping up as normal. What am I missing? Thanks!
phpmyadmin mamp
add a comment |
This is a weird thing I haven't seen as I'm usually working on a live server. On my MAMP, when I try and export the database, it just opens the file within phpmyadmin-like as a text document. I tried to copy the file to a text document with and gave it a .sql at the end, but that gave me an error when trying to import to the live server. When I try an export from the live server, I get the save location dialog box popping up as normal. What am I missing? Thanks!
phpmyadmin mamp
add a comment |
This is a weird thing I haven't seen as I'm usually working on a live server. On my MAMP, when I try and export the database, it just opens the file within phpmyadmin-like as a text document. I tried to copy the file to a text document with and gave it a .sql at the end, but that gave me an error when trying to import to the live server. When I try an export from the live server, I get the save location dialog box popping up as normal. What am I missing? Thanks!
phpmyadmin mamp
This is a weird thing I haven't seen as I'm usually working on a live server. On my MAMP, when I try and export the database, it just opens the file within phpmyadmin-like as a text document. I tried to copy the file to a text document with and gave it a .sql at the end, but that gave me an error when trying to import to the live server. When I try an export from the live server, I get the save location dialog box popping up as normal. What am I missing? Thanks!
phpmyadmin mamp
phpmyadmin mamp
asked Apr 28 '13 at 2:49
JoelJoel
1,33473065
1,33473065
add a comment |
add a comment |
8 Answers
8
active
oldest
votes
It's hard to tell what's wrong with little information. What version of phpMyAdmin are you using?
However when you try to export the database, in the export page you'll have a choice between 'Quick' and 'Custom'. Chose custom and under the 'Output' section you'll see two choices.
- Save output to a file
- View output as text
Generally 'Save output to a file' is selected by default, but i'm not sure whether something has gone wrong and the other option is selected in your case .
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
add a comment |
inside of phpmyadmin you'll need to navigate to:
Setting >> Export >> Export Defaults
Click on the radio button to "Save as file" (this will be under the Custom header)
Click "Save"
see picture here:

This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
add a comment |
Select the database you wish to export and:
click "Custom - display all possible options" under 'export method'.
Click "Save output to a file" under 'Output'.
Click on 'Go'.
add a comment |
My phpMyAdmin settings were already set to export a file; however, I had to change the phpMyAdmin config file /path/to/phpMyAdmin/config.inc.php at approximately line 256:
$cfg['Export']['asfile'] = TRUE;
Note: Check your "format-specific options" when exporting.
Example: Columns enclosed with: you may have to replace " with quote marks (")
add a comment |
I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
add a comment |
Solved mine by changing Export setting
From "Setting" tab check in "Export" section, you'd find "Save as file" and "Save to browser's storage" radio buttons, choose "Save as file" and click "Go". Restart your WAMP OR MAMP and try to export, it should download this time.
add a comment |
I have the same problem

even though

add a comment |
- Click on server>Appearance settings>More settings>Export
- Make sure your export method is set to Quick
- Check the 'Save as file' then 'Apply' at bottom.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f16259052%2fexporting-mysql-in-mamp-not-letting-me-save-file-as-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
8 Answers
8
active
oldest
votes
8 Answers
8
active
oldest
votes
active
oldest
votes
active
oldest
votes
It's hard to tell what's wrong with little information. What version of phpMyAdmin are you using?
However when you try to export the database, in the export page you'll have a choice between 'Quick' and 'Custom'. Chose custom and under the 'Output' section you'll see two choices.
- Save output to a file
- View output as text
Generally 'Save output to a file' is selected by default, but i'm not sure whether something has gone wrong and the other option is selected in your case .
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
add a comment |
It's hard to tell what's wrong with little information. What version of phpMyAdmin are you using?
However when you try to export the database, in the export page you'll have a choice between 'Quick' and 'Custom'. Chose custom and under the 'Output' section you'll see two choices.
- Save output to a file
- View output as text
Generally 'Save output to a file' is selected by default, but i'm not sure whether something has gone wrong and the other option is selected in your case .
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
add a comment |
It's hard to tell what's wrong with little information. What version of phpMyAdmin are you using?
However when you try to export the database, in the export page you'll have a choice between 'Quick' and 'Custom'. Chose custom and under the 'Output' section you'll see two choices.
- Save output to a file
- View output as text
Generally 'Save output to a file' is selected by default, but i'm not sure whether something has gone wrong and the other option is selected in your case .
It's hard to tell what's wrong with little information. What version of phpMyAdmin are you using?
However when you try to export the database, in the export page you'll have a choice between 'Quick' and 'Custom'. Chose custom and under the 'Output' section you'll see two choices.
- Save output to a file
- View output as text
Generally 'Save output to a file' is selected by default, but i'm not sure whether something has gone wrong and the other option is selected in your case .
answered Apr 28 '13 at 13:56
Madhura JayaratneMadhura Jayaratne
1,6741916
1,6741916
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
add a comment |
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
That was it-thanks!
– Joel
Apr 29 '13 at 4:23
add a comment |
inside of phpmyadmin you'll need to navigate to:
Setting >> Export >> Export Defaults
Click on the radio button to "Save as file" (this will be under the Custom header)
Click "Save"
see picture here:

This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
add a comment |
inside of phpmyadmin you'll need to navigate to:
Setting >> Export >> Export Defaults
Click on the radio button to "Save as file" (this will be under the Custom header)
Click "Save"
see picture here:

This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
add a comment |
inside of phpmyadmin you'll need to navigate to:
Setting >> Export >> Export Defaults
Click on the radio button to "Save as file" (this will be under the Custom header)
Click "Save"
see picture here:

inside of phpmyadmin you'll need to navigate to:
Setting >> Export >> Export Defaults
Click on the radio button to "Save as file" (this will be under the Custom header)
Click "Save"
see picture here:

edited Dec 13 '16 at 1:14
answered Aug 29 '13 at 12:45
GinfuruGinfuru
54168
54168
This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
add a comment |
This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
This is the right answer! That solved my problem. After updating Mamp I couldn't save on file anymore with the quick export (by default I mean).
– Andycap
Sep 25 '13 at 8:39
add a comment |
Select the database you wish to export and:
click "Custom - display all possible options" under 'export method'.
Click "Save output to a file" under 'Output'.
Click on 'Go'.
add a comment |
Select the database you wish to export and:
click "Custom - display all possible options" under 'export method'.
Click "Save output to a file" under 'Output'.
Click on 'Go'.
add a comment |
Select the database you wish to export and:
click "Custom - display all possible options" under 'export method'.
Click "Save output to a file" under 'Output'.
Click on 'Go'.
Select the database you wish to export and:
click "Custom - display all possible options" under 'export method'.
Click "Save output to a file" under 'Output'.
Click on 'Go'.
edited Apr 28 '13 at 16:16
jszumski
7,067113452
7,067113452
answered Apr 28 '13 at 15:53
Haneef ThayyilHaneef Thayyil
111
111
add a comment |
add a comment |
My phpMyAdmin settings were already set to export a file; however, I had to change the phpMyAdmin config file /path/to/phpMyAdmin/config.inc.php at approximately line 256:
$cfg['Export']['asfile'] = TRUE;
Note: Check your "format-specific options" when exporting.
Example: Columns enclosed with: you may have to replace " with quote marks (")
add a comment |
My phpMyAdmin settings were already set to export a file; however, I had to change the phpMyAdmin config file /path/to/phpMyAdmin/config.inc.php at approximately line 256:
$cfg['Export']['asfile'] = TRUE;
Note: Check your "format-specific options" when exporting.
Example: Columns enclosed with: you may have to replace " with quote marks (")
add a comment |
My phpMyAdmin settings were already set to export a file; however, I had to change the phpMyAdmin config file /path/to/phpMyAdmin/config.inc.php at approximately line 256:
$cfg['Export']['asfile'] = TRUE;
Note: Check your "format-specific options" when exporting.
Example: Columns enclosed with: you may have to replace " with quote marks (")
My phpMyAdmin settings were already set to export a file; however, I had to change the phpMyAdmin config file /path/to/phpMyAdmin/config.inc.php at approximately line 256:
$cfg['Export']['asfile'] = TRUE;
Note: Check your "format-specific options" when exporting.
Example: Columns enclosed with: you may have to replace " with quote marks (")
edited Jan 21 '14 at 20:30
Sam
16.6k13459
16.6k13459
answered Jan 21 '14 at 20:05
shesthebethshesthebeth
114
114
add a comment |
add a comment |
I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
add a comment |
I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
add a comment |
I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.
I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.
answered Mar 29 '14 at 14:33
Eric WassinkEric Wassink
11
11
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
add a comment |
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.
– Jeroen
Mar 29 '14 at 15:02
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
@Jeroen - it may not be the most detailed answer, but "Check the size of some tables. I had to empty some cache tables" is at least an answer.
– iandotkelly
Mar 29 '14 at 15:21
add a comment |
Solved mine by changing Export setting
From "Setting" tab check in "Export" section, you'd find "Save as file" and "Save to browser's storage" radio buttons, choose "Save as file" and click "Go". Restart your WAMP OR MAMP and try to export, it should download this time.
add a comment |
Solved mine by changing Export setting
From "Setting" tab check in "Export" section, you'd find "Save as file" and "Save to browser's storage" radio buttons, choose "Save as file" and click "Go". Restart your WAMP OR MAMP and try to export, it should download this time.
add a comment |
Solved mine by changing Export setting
From "Setting" tab check in "Export" section, you'd find "Save as file" and "Save to browser's storage" radio buttons, choose "Save as file" and click "Go". Restart your WAMP OR MAMP and try to export, it should download this time.
Solved mine by changing Export setting
From "Setting" tab check in "Export" section, you'd find "Save as file" and "Save to browser's storage" radio buttons, choose "Save as file" and click "Go". Restart your WAMP OR MAMP and try to export, it should download this time.
answered Jun 3 '16 at 15:55
zEELzzEELz
13
13
add a comment |
add a comment |
I have the same problem

even though

add a comment |
I have the same problem

even though

add a comment |
I have the same problem

even though

I have the same problem

even though

answered Jan 1 at 17:04
Simon HSimon H
12.8k74477
12.8k74477
add a comment |
add a comment |
- Click on server>Appearance settings>More settings>Export
- Make sure your export method is set to Quick
- Check the 'Save as file' then 'Apply' at bottom.
add a comment |
- Click on server>Appearance settings>More settings>Export
- Make sure your export method is set to Quick
- Check the 'Save as file' then 'Apply' at bottom.
add a comment |
- Click on server>Appearance settings>More settings>Export
- Make sure your export method is set to Quick
- Check the 'Save as file' then 'Apply' at bottom.
- Click on server>Appearance settings>More settings>Export
- Make sure your export method is set to Quick
- Check the 'Save as file' then 'Apply' at bottom.
edited Nov 24 '18 at 12:52
Stephen Rauch
29.7k153657
29.7k153657
answered Nov 24 '18 at 12:28
user10698950user10698950
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f16259052%2fexporting-mysql-in-mamp-not-letting-me-save-file-as-sql%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