Skip to main content
Keep your business open during COVID-19Learn More
Call us
Phone numbers and hours
Help Center

Explore our online help resources

We are experiencing high volume today, and as a result, you may experience longer than usual wait times.
BlogHelp

Managed WordPress Help

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.
    select database name
  3. On the Structure tab, select Check All.
    check all the boxes
  4. Next to Check All under With selected, select Drop.
    select drop from the menu
  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.
    ensure table database is empty
  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.
    select the import tab
    select import options
  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_:
    table prefix in phpMyAdmin

More info

Community Related

buckeyeamy's Avatar
Help with importing databases

7 Replies

Last posted over 4 years ago.

way245's Avatar
Database Connection?

1 Replies

Last posted about 4 years ago.

icebergslim's Avatar
Importing CSV data to MSSQL database?

1 Replies

Last posted almost 4 years ago.

lehuynh's Avatar
SQL Database was lost

Be the first to reply

Last posted about 3 years ago.

Don't see what you are looking for? Search the Community