InMotion Hosting Support Center

Can I do a Partial Database Restore?

Category: Wordpress

n/a Points
2015-12-29 3:13 pm EST

Hits: 72
I would like to do a clean install of Wordpress because I have so many duplicate pages from various themes "dummy" content. I would then like to upload only my database of posts. I have exported and downloaded wp-posts.sql to my computer. My question is, can I just upload that file (the posts data) to a fresh install of Wordpress? Thank you. Simon

You must login before you can ask a follow up question.

You must login before you can submit an answer.



11,130 Points
2015-12-29 3:45 pm EST
Hello Simon,

Thank you for contacting us about a partial database restore. I ran a few tests to find a workaround for you in phpMyAdmin, but I'm sure you can use whichever SQL client you prefer.

The issue is that the wp-posts.sql is of course not a full database, just a table. So you would need to "drop" that table from the database.

I was able to make it work by "dropping" the wp-posts table in a new WordPress installation and then re-creating it and importing the wp-posts.sql file.

Christopher M

You must login before you can post a comment about this answer.

Christopher, thank you. Can you tell me how to Drop the table from the instal. Can I do the instal then the delete the table and insert mine?
3 Points
2015-12-29 4:40 pm EST

11,130 Points
2015-12-29 6:27 pm EST
Hello Simon,

In phpMyAdmin, the "Drop" option is available on the same line as the table itself. You will see the following options: Browse, Structure, Search, Insert, Empty, Drop. Yes, you can do the new WordPress install first (which is what I did in my test) then go in and edit the table and import your wp-posts.sql data.

You must login before you can post a comment about this answer.

Like this Question?

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!