Export a WordPress Database from Another Host
This guide will take you through the process of exporting your database from your previous host, so that you can then migrate it to WP Engine. Your WordPress database contains all of your website’s content—including things like posts, pages, categories and settings.
Most other web hosting companies offer the cPanel (a Unix based web hosting control panel) for managing your website, because of this we’ll use the cPanel in this guide.
Open Database in phpMyAdmin
The most common way to access your database is by using a tool called phpMyAdmin (phpMyAdmin is a software tool that handles the administration of MySQL over the web).
Log into your cPanel (please contact your previous host for assistance if you need it) and click on the icon called phpMyAdmin. This will open up an application used to manipulate and manage your database.
NOTE: The images below are from the most current version of phpMyAdmin. Older versions may have a slightly different setup.
Next, select your database name on the left.
You will see a vertical list of databases on the left side of your window. Click on the database for the website you are planning to migrate.
In the example below, the database used by the website we want to migrate is called abaybee_wrdp1.
Configure a Custom Export
Once you have selected the correct database, click on Export in the top navigation menu.
Next, you will be provided with options for the Export Method.
- Select Custom. This will show additional export options.
- Older versions of phpMyAdmin may not have an “Export Method” and will default straight to “Custom,” which is just fine.
- For Format, choose SQL
- From the Tables box, click Select All to ensure that all of the tables are exported.
- Scroll down and locate the Object Creation Options subsection, ensure only the following items are selected:
- Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement
- Add CREATE TABLE statement
- IF NOT EXISTS
- Enclose table and field names with backquotes
- The final piece to consider is Maximal Length of Created Query, which is found at the bottom of the Export page. For databases over 300MBs we highly recommend you alter the Maximal Length of Created Query to: 1047551
Export Database and Save Locally
Click on the Go button at the bottom of the page. The database export will now save to your computer with a .SQL file extension (e.g. abaybee_wrdp1.sql in the screenshot below).
The exported file will typically be downloaded to your /Downloads folder. The location of this folder may differ, depending on your browser or operating system.
Should you encounter issues with your database imports not pulling all of your information over, consider cutting down the maximal query length by half to 523776 bytes, or down to 104858 bytes until the import completes successfully.
NEXT STEP: Import a database to WP Engine