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

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 .


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