Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

WordPress Local WordPress Development Local WordPress Development Migrating WordPress from Local to Live Server

Gina Bégin
PLUS
Gina Bégin
Courses Plus Student 8,613 Points
Posted by Gina Bégin
Gina Bégin
Courses Plus Student 8,613 Points

Not able to export an .sql database file with MAMP — it just opens a new page with code.

I feel like I am endlessly here bugging you guys. I am so sorry. But it appears my MAMP is a little different than in the video.

I went to export under the data base I was using for the course, followed the instructions Zac has on the video (custom, select all, etc.) and then hit "Go" (or "Export," whatever the button reads at the bottom of all the choices. It simply ran a page of code and didn't download any file. I tried to CTRL click to save, but that option wasn't there. This is all I got (and this is my first attempt at markdown, so I might not even get the screenshot right):

screenshot

4 Answers

Gina Bégin
PLUS
Gina Bégin
Courses Plus Student 8,613 Points
Gina Bégin
Gina Bégin
Courses Plus Student 8,613 Points

Dang, I figured it out. It somehow reverted to "save as text output" instead of a file. My mousepad has been jumping a bit lately, so it may have been an inadvertent slip there.

dorzki
dorzki
4,312 Points
dorzki
dorzki
4,312 Points

when you export see that you have the option to export to a file: http://www.techrepublic.com/blog/smb-technologist/import-and-export-databases-using-phpmyadmin/

dorzki
dorzki
4,312 Points
dorzki
dorzki
4,312 Points

simply select all the text inside the textbox and save it to a textfile with the .sql extension :)

Gina Bégin
Gina Bégin
Courses Plus Student 8,613 Points
Gina Bégin
Gina Bégin
Courses Plus Student 8,613 Points

You'd think that would work, right? But that's what I'm saying... that option is not there to save. I select all, then CTRL + click (I'm on a Macbook Pro) and it immediately deselects all the text and, additionally, there is not "Save as..." option.

Stumped. According to the video, it should have automatically downloaded to my computer as an .sql file. Neither route is working on my version of MAMP (from the online page).

dorzki
dorzki
4,312 Points
dorzki
dorzki
4,312 Points

buy a new one ;)

Please mark the question as solved :)

dorzki
dorzki
4,312 Points

indeed :)