Import your database

Step 4 of the Migrate my WordPress site manually series.

 Warning: This step in the series is performed in the Managed WordPress account you’re migrating to. If you perform these steps in the database you’re moving from, you’ll lose your data.

Import the WordPress database you exported. You’ll use phpMyAdmin to get this done.

1. Open phpMyAdmin. (Need help opening phpMyAdmin?)
2. In left menu, select your database name.
3. On the Structure tab, select Check All.
4. Next to Check All under With selected, select Drop.
5. Under Do you really want to, select Yes.
6. In left menu, check to ensure the tables were dropped. It should show zero tables.
7. On the Import tab under File to import, select Choose File. Locate and select the SQL file you previously exported, and then select Open. Be sure to select Partial import and SQL as the format of the imported file.
8. Select Go.
9. Make note of your table prefix after importing your database. You’ll need this when you make your final edits. In this example the table prefix is wp_:

More info

• Migrate my WordPress site manually