20

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!

Joel
  • 2,691
  • 7
  • 40
  • 72

8 Answers8

37

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 .

Madhura Jayaratne
  • 2,204
  • 1
  • 15
  • 20
21

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

Ed Heltzel
  • 1,679
  • 1
  • 13
  • 9
  • 1
    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 08:39
2

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.

zEELz
  • 171
  • 6
1

I exported with custom option first, switched back to quick and it worked as normal.

Tariro
  • 11
  • 1
0

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

jszumski
  • 7,430
  • 11
  • 40
  • 53
Haneef Thayyil
  • 9
  • 1
0

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

Sam
  • 20,096
  • 2
  • 45
  • 71
shesthebeth
  • 9
  • 4
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.

Eric Wassink
  • 1
  • 1
  • 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](http://stackoverflow.com/help/whats-reputation) you will be able to [comment on any post](http://stackoverflow.com/help/privileges/comment). – 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
-2
  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.
Stephen Rauch
  • 47,830
  • 31
  • 106
  • 135
user10698950
  • 1