Opened phpMyAdmin. Selected the target database. Clicked on the Export tab. Chose Quick export method and SQL format. Downloaded and saved the .sql file. Restore Using phpMyAdmin: Created a new or ...

To import data, go to the “Import” tab in phpMyAdmin. To import data into a specific database or table, open the database or table before going to the “Import” tab. In addition to the standard Import ...

Basically, try to get the database to show up by wiping MAMP settings clean and copying in database files. Export the database it if it’s broken, re-import, and reset WordPress permalinks.