I’ve already written about how to import your content to WPEngine using the WordPress import tool. Another option is to import your WordPress database to phpMyAdmin.
You’ll find the WPEngine control panel is very different than cPanel. Access to your server and databases is made via your user panel which you can access from the backend User Portal link in your WordPress dashboard.
Click this screenshot to see what your control panel (User Portal) looks like:
To access PhpMyAdmin,
- login to your site which should be yourdomain.wpengine.com/wp-login.php
- Click on User Portal in the top left tab under WP Engine
- You may also need to login again
- Click on Manage WordPress
- Click on the Database tab which you can see in the above screen shot
This opens phpMyAdmin so you can import your .sql backup file
Note: To avoid importing default WordPress tables into a database which already included them, simply drop the existing tables from the default database WPEngine have already setup on your new server space.
You’ll find 2 links in the top left sidebar
Its your decision which database you want to use for importing your content.
- Click the database you wish to import your .sql file to
- Drop the default tables for the default database WPEngine have already created
- Click import
- Browse for the file and select it
- Click Go at the bottom of the page to import your database
Large .SQL Database Files
You may have a problem if your database file is too large. In this case, contact WPEngine’s support as you may be able to upload your database to your server using SFTP and then import it from there to phpMyAdmin using a command line with SSH access.
Another option is to ask support to increase the limits on uploading to phpMyAdmin.
Note: Be aware that your wp login details will change so you’ll need to use the username and password from your old site as this is whats in the database import.
The migration to managed hosting has been a pleasant and satisfying experience.Subscribe for Free & Premium Genesis Tutorials