A running instance of phpMyAdmin A user with full access to the databases (such as the phpmyadmin user) A database to back up With those things at the ready, let’s back up and restore that data.

Hi, I tried to export all of the MySQL databases using phpMyAdmin as an SQL file. After downloading it, I did an SCP of it to the new server which is a local to remote transfer. Now, when I am ...

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.