exporting mysql in mamp-not letting me save file as sql?












14















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!










share|improve this question



























    14















    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!










    share|improve this question

























      14












      14








      14


      3






      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!










      share|improve this question














      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






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 28 '13 at 2:49









      JoelJoel

      1,33473065




      1,33473065
























          8 Answers
          8






          active

          oldest

          votes


















          23














          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.




          1. Save output to a file

          2. 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 .






          share|improve this answer
























          • That was it-thanks!

            – Joel
            Apr 29 '13 at 4:23



















          11














          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:
          enter image description here






          share|improve this answer


























          • 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





















          1














          Select the database you wish to export and:




          1. click "Custom - display all possible options" under 'export method'.


          2. Click "Save output to a file" under 'Output'.


          3. Click on 'Go'.







          share|improve this answer

































            1














            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 (")






            share|improve this answer

































              0














              I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.






              share|improve this answer
























              • 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



















              0














              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.






              share|improve this answer































                0














                I have the same problem
                enter image description here



                even though
                enter image description here






                share|improve this answer































                  -1















                  1. Click on server>Appearance settings>More settings>Export

                  2. Make sure your export method is set to Quick

                  3. Check the 'Save as file' then 'Apply' at bottom.






                  share|improve this answer

























                    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
                    });


                    }
                    });














                    draft saved

                    draft discarded


















                    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









                    23














                    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.




                    1. Save output to a file

                    2. 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 .






                    share|improve this answer
























                    • That was it-thanks!

                      – Joel
                      Apr 29 '13 at 4:23
















                    23














                    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.




                    1. Save output to a file

                    2. 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 .






                    share|improve this answer
























                    • That was it-thanks!

                      – Joel
                      Apr 29 '13 at 4:23














                    23












                    23








                    23







                    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.




                    1. Save output to a file

                    2. 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 .






                    share|improve this answer













                    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.




                    1. Save output to a file

                    2. 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 .







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    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



















                    • 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













                    11














                    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:
                    enter image description here






                    share|improve this answer


























                    • 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


















                    11














                    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:
                    enter image description here






                    share|improve this answer


























                    • 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
















                    11












                    11








                    11







                    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:
                    enter image description here






                    share|improve this answer















                    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:
                    enter image description here







                    share|improve this answer














                    share|improve this answer



                    share|improve this answer








                    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





















                    • 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













                    1














                    Select the database you wish to export and:




                    1. click "Custom - display all possible options" under 'export method'.


                    2. Click "Save output to a file" under 'Output'.


                    3. Click on 'Go'.







                    share|improve this answer






























                      1














                      Select the database you wish to export and:




                      1. click "Custom - display all possible options" under 'export method'.


                      2. Click "Save output to a file" under 'Output'.


                      3. Click on 'Go'.







                      share|improve this answer




























                        1












                        1








                        1







                        Select the database you wish to export and:




                        1. click "Custom - display all possible options" under 'export method'.


                        2. Click "Save output to a file" under 'Output'.


                        3. Click on 'Go'.







                        share|improve this answer















                        Select the database you wish to export and:




                        1. click "Custom - display all possible options" under 'export method'.


                        2. Click "Save output to a file" under 'Output'.


                        3. Click on 'Go'.








                        share|improve this answer














                        share|improve this answer



                        share|improve this answer








                        edited Apr 28 '13 at 16:16









                        jszumski

                        7,067113452




                        7,067113452










                        answered Apr 28 '13 at 15:53









                        Haneef ThayyilHaneef Thayyil

                        111




                        111























                            1














                            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 (")






                            share|improve this answer






























                              1














                              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 (")






                              share|improve this answer




























                                1












                                1








                                1







                                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 (")






                                share|improve this answer















                                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 (")







                                share|improve this answer














                                share|improve this answer



                                share|improve this answer








                                edited Jan 21 '14 at 20:30









                                Sam

                                16.6k13459




                                16.6k13459










                                answered Jan 21 '14 at 20:05









                                shesthebethshesthebeth

                                114




                                114























                                    0














                                    I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.






                                    share|improve this answer
























                                    • 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
















                                    0














                                    I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.






                                    share|improve this answer
























                                    • 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














                                    0












                                    0








                                    0







                                    I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.






                                    share|improve this answer













                                    I had the same problem on a Drupal database. Check the size of some tables. I had to empty some cache tables. That worked.







                                    share|improve this answer












                                    share|improve this answer



                                    share|improve this answer










                                    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



















                                    • 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











                                    0














                                    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.






                                    share|improve this answer




























                                      0














                                      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.






                                      share|improve this answer


























                                        0












                                        0








                                        0







                                        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.






                                        share|improve this answer













                                        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.







                                        share|improve this answer












                                        share|improve this answer



                                        share|improve this answer










                                        answered Jun 3 '16 at 15:55









                                        zEELzzEELz

                                        13




                                        13























                                            0














                                            I have the same problem
                                            enter image description here



                                            even though
                                            enter image description here






                                            share|improve this answer




























                                              0














                                              I have the same problem
                                              enter image description here



                                              even though
                                              enter image description here






                                              share|improve this answer


























                                                0












                                                0








                                                0







                                                I have the same problem
                                                enter image description here



                                                even though
                                                enter image description here






                                                share|improve this answer













                                                I have the same problem
                                                enter image description here



                                                even though
                                                enter image description here







                                                share|improve this answer












                                                share|improve this answer



                                                share|improve this answer










                                                answered Jan 1 at 17:04









                                                Simon HSimon H

                                                12.8k74477




                                                12.8k74477























                                                    -1















                                                    1. Click on server>Appearance settings>More settings>Export

                                                    2. Make sure your export method is set to Quick

                                                    3. Check the 'Save as file' then 'Apply' at bottom.






                                                    share|improve this answer






























                                                      -1















                                                      1. Click on server>Appearance settings>More settings>Export

                                                      2. Make sure your export method is set to Quick

                                                      3. Check the 'Save as file' then 'Apply' at bottom.






                                                      share|improve this answer




























                                                        -1












                                                        -1








                                                        -1








                                                        1. Click on server>Appearance settings>More settings>Export

                                                        2. Make sure your export method is set to Quick

                                                        3. Check the 'Save as file' then 'Apply' at bottom.






                                                        share|improve this answer
















                                                        1. Click on server>Appearance settings>More settings>Export

                                                        2. Make sure your export method is set to Quick

                                                        3. Check the 'Save as file' then 'Apply' at bottom.







                                                        share|improve this answer














                                                        share|improve this answer



                                                        share|improve this answer








                                                        edited Nov 24 '18 at 12:52









                                                        Stephen Rauch

                                                        29.7k153657




                                                        29.7k153657










                                                        answered Nov 24 '18 at 12:28









                                                        user10698950user10698950

                                                        1




                                                        1






























                                                            draft saved

                                                            draft discarded




















































                                                            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.




                                                            draft saved


                                                            draft discarded














                                                            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





















































                                                            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







                                                            Popular posts from this blog

                                                            Mossoró

                                                            Error while reading .h5 file using the rhdf5 package in R

                                                            Pushsharp Apns notification error: 'InvalidToken'