
Originally Posted by
pdxdoug
Down toward the bottom of the export screen in phpMyAdmin is a checkbox to save it to Save as a file. After checking that checkbox and clicking Go, your browser should offer you a location to save your file locally (on your computer). Make a note of that location.
If you are not prompted by your browser for the default file save location, you might want to change that. In Firefox, click tools - options and main. You should see an area pertaining to downloads. Set it to whatever your preferences are. There is a similar setting in IE.