Title: WordPress Import Function Not Working! Last modified: August 22, 2016 --- # WordPress Import Function Not Working! * Resolved [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/) * I am trying to import posts from another wordpress site using the Tools > Import function and it is not working. I’ve tried checking the “upload attachments” box and unchecking it. The file I am uploading is a small .xml file that was generated using the Export function with WordPress 3.9.2 I believe. Please help! Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/wordpress-import-function-not-working/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-import-function-not-working/page/2/?output_format=md) * Moderator [Bet Hannon](https://wordpress.org/support/users/bethannon1/) * (@bethannon1) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651345) * Is the site that you are trying to import INTO also 3.9.2? * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651377) * No, it is the most recent WP 4.1. * Moderator [Bet Hannon](https://wordpress.org/support/users/bethannon1/) * (@bethannon1) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651379) * I am assuming that you have tried making the export from the original site again, since perhaps it is somehow corrupted, right? * Can you be more specific than it’s “not working”? Do you mean that the import runs, but there is an error message? (If so, what is that message?) Or, do you mean that it seems to run the import, but imported posts & pages don’t seem to be in the dashboard? * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651380) * No, I made the export from a site which was being taken down, so it is no longer active. I do not get an error message, it acts as if the import worked and says“ All Done” or something of that sort. But none of the posts come over. I do still have access to the old site’s database, so if I can just export the posts tables, I’d be open to going that route. * Moderator [Bet Hannon](https://wordpress.org/support/users/bethannon1/) * (@bethannon1) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651381) * If you are comfortable with the db import, that’s the route I would go, rather than continuing to troubleshoot the import. * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651382) * Could you give me any tips? Do I just export the wp post table? Or comments, etc? Any way to pull the images that are attached to those posts? * Moderator [Bet Hannon](https://wordpress.org/support/users/bethannon1/) * (@bethannon1) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651383) * You will want to move the posts & comments via database, but the images will have to be moved via ftp. I haven’t ever done this sort of import like this before( I use a backup plugin to capture what I need and restore it), so someone else will have to give details about how to do this in phpMyAdmin. * You might find helpful info here, although I know you aren’t moving a whole site: [http://codex.wordpress.org/Moving_WordPress](http://codex.wordpress.org/Moving_WordPress) * There are also a couple of plugins that purport to help migrate or import into db, but I can’t vouch for any of those. Sorry. * [Justin Greer](https://wordpress.org/support/users/justingreerbbi/) * (@justingreerbbi) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651384) * Hi [@dmooredesign](https://wordpress.org/support/users/dmooredesign/), * The link provided above by Bet is a great place to start when migrating. If you have any questions about the Migration using phpMyAdmin please do not hesitate to ask. * Here is a specific link to help with exporting your database: Backing up your Database: [http://codex.wordpress.org/Backing_Up_Your_Database](http://codex.wordpress.org/Backing_Up_Your_Database). * Are you wanting to move just the posts and media or are you moving the entire site to a new host? * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651385) * Thanks Bet. Justin, I only need the posts/comments from a previous website. I already did a complete migration, but now I need to go back and grab the posts( blog) which wasn’t in the original plan. So I’m looking to move specific tables, not the entire database. Thanks. * [Justin Greer](https://wordpress.org/support/users/justingreerbbi/) * (@justingreerbbi) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651386) * Thanks for the info. * There are a couple tables you will need to export: – posts – postmeta – comments– commentsmeta * Please make a full export of your new database before continuing. * Check the above table, and select “Export” from the dropdown below the table list. When exporting the following settings are a personal preference. * – Select: Save output to a file – Select: “data” under “Format-specific options”- Under “Data creation options” check “Truncate table before insert” (if there are already posts in the new db before importing, there will be errors) – Then click “Go” * You will download a .sql that can then be imported into your new database. It would be a lot easier to simply export your entire old database but if it is not an option please export a full backup of your old database as well for safe keeping. * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651387) * Thanks. I already have the old and new database backed up. Copying the entire db is not an option, because it would export pages. I do not need that, plus the new site is a completely different theme with different settings. Just need the posts. * When importing this sql file, do I need to drill down into a specific table? Or will it merge with the existing database and automatically break into appropriate tables? * [Justin Greer](https://wordpress.org/support/users/justingreerbbi/) * (@justingreerbbi) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651388) * Exporting your posts via phpMyAdmin is going to be a bit more of a task than simply exporting as I thought and posted. WordPress uses the table “post” for posts and pages. * You are going to have to use the SQL tab in phpMyAdmin to accomplish what you are needing to do. This is a very complex method so I am going to try something else first. * This may sound a bit excessive but another way you can export all your needs is to install the old WP site in a development environment and use the built in exporter with WP again. You may have a corrupt export file. * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651389) * I actually saved 3 different xml files when exporting originally through WP. One for 2014 posts, one for 2013-2008 and one for ALL. I’m trying to import the one with ALL now, but not I’m getting an error message “The connection was reset” when clicking upload/import. * [Radices](https://wordpress.org/support/users/radices/) * (@radices) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651390) * I think it’s a Server error… perhaps hitting a memory limit or max upload limit. Do you have another install that you can test the import on? * Thread Starter [dmooredesign](https://wordpress.org/support/users/dmooredesign/) * (@dmooredesign) * [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/#post-5651391) * I was able to get it to import successfully on a second try. Thanks everyone for your help. Viewing 15 replies - 1 through 15 (of 17 total) 1 [2](https://wordpress.org/support/topic/wordpress-import-function-not-working/page/2/?output_format=md) [→](https://wordpress.org/support/topic/wordpress-import-function-not-working/page/2/?output_format=md) The topic ‘WordPress Import Function Not Working!’ is closed to new replies. ## Tags * [export](https://wordpress.org/support/topic-tag/export/) * [Import](https://wordpress.org/support/topic-tag/import/) * [wp import](https://wordpress.org/support/topic-tag/wp-import/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 17 replies * 4 participants * Last reply from: [Justin Greer](https://wordpress.org/support/users/justingreerbbi/) * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/wordpress-import-function-not-working/page/2/#post-5651407) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics