WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I exported all posts of a WordPress blog. Then I imported the xml file to another WordPress blog. When I tried to search few posts in the new blog, which are in the old blog, I did not find anything. When I opened the xml file, I found that it's incomplete. The file contains 14,226 lines of code. The size of the file is 1.2 MB. I used default tool of WordPress to export and import.

How to export complete list of posts and then import the same?

I have another lame idea to do this, if I don't get any good solution. I can delete the posts which are exported and then export again. But this is a stupid time taking process.

share|improve this question

To copy a WordPress install from A to B, do an SQL dump on site A, and restore it to site B. Then search and replace the DB to swap the old URLs for the new URLs. Make sure to copy over the uploads folder in wp-content.

To do the search replace, consider using a tool such as this:


share|improve this answer
and/or this: wordpress.org/extend/plugins/search-regex – its_me Jun 20 '12 at 16:14
@Tom J Nowell I posted a question for a simillar situation but I needed to import 2 sites into one. I hope I can still do this same way. I have a question about featured image, does the sql dump has path to the featured image for each post as well? In general how the featured image works. Is it part of the post content table? please advise. – Jay Feb 10 '14 at 15:38
Each of those questions could easily be asked as a question rather than in a comment. I suggest you do so rather than deprive yourself of reputation and quality answers – Tom J Nowell Feb 10 '14 at 16:41
  1. Install the WP Migrate DB plugin
  2. Enter new server path and site address
  3. Export database
  4. Create a new DB and import the database SQL file
  5. Download the files and change the wp-config.php database connection details with the new details from the new DB
  6. Upload the files to the new installation
share|improve this answer
Hi Brad, thanks again. I am trying what you suggested. In my case, I am going to use a different theme and I see that this migrate plug in copy the theme name to the path. Is that something I can change once migrated? – Jay Feb 10 '14 at 17:10
Yes. Changing themes is very simple – Brad Dalton Feb 11 '14 at 10:16

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.