1. Install a new instance of WordPress
2. Import the database
Go to phpMyAdmin underyour new install to open the sql database
SELECT PRODUCTION DATABASE
Click on the database without ‘snapshot’ in the name.
DROP THE TABLES
Before importing the database, the current database has to be emptied of its content. Click on “Check All’ to select all of the database tables, then from the drop down menu select ‘Drop.’
On the following screen confirm with a ‘Yes.’ All of the database tables will now disappear.
Now that the tables are dropped, you are ready to import the database to phpMyAdmin. Click on the ‘Import’ tab in the menu. Next, click on ‘Choose File’ and select your database export file. Finally, click on ‘Go’ at the bottom of the page.
If successful, you will now see the new tables in the database.
3. Upload wp-content
FTP into your site and upload your wp-content folder, making sure to overwrite the existing wp-content folder.
4. Update database with new URL
SELECT ‘WP_OPTIONS’ TABLE
Go back to phpMyAdmin and find the corresponding database, the one not labeled snapshot. The database contains a set of tables which store a collection of values. Locate the ‘wp_options’ table and click on it.
SELECT ‘SITEURL’ OPTION
The table contains a collection of options and values. Locate the option ‘siteurl’ and click on ‘edit’ in the row where you see the option.
EDIT ‘SITEURL’ OPTION VALUE
Edit the ‘siteurl’ value to be that of your domain . Then click on ‘Go’ at the bottom of the page to save the changes.
SELECT ‘HOME’ OPTION
Go back to the ‘wp_options’ table, locate the ‘home’ option, and click on ‘edit’ in the same row.
EDIT ‘HOME’ OPTION VALUE
Edit the ‘home’ value to be your domain as well. Then click on ‘Go’ at the bottom of the page to save the changes.
5. Change the password for the user “multipage”
Also in phpMyAdmin should be a table called wp_users. Click edit on that to view the current users in your database. You should have a wpengine user and a multipage user. From there, click to edit the multipage user.
EDIT ‘USER_PASS’ OPTION VALUE
From the “Function” dropdown of “user_pass”, select “MD5”. Then, enter your preferred password in the “Value” space.
6. LOGIN TO WORDPRESS ADMIN
You should now be able to navigate to [yourdomain].com/wp-admin to login to the back end of your site. Your username is “multipage” and your password is whatever you changed it to in the previous step.