Your question is a bit specific if you “only” want to automatically import some posts/pages. There are other ways to do this then using a XML export file. If you have text-only posts, then you should use LOAD DATA INFILE. At first you have to export your posts. global $wpdb, $wp_filesystem; $tables = array( ‘posts’ … Read more
Sounds like you have successfully gotten all 300 Pages imported based on the comments. (Regardless of how you did it, either by using the WordPress import plugin or by using some MySQL tool like phpMyAdmin or Sequel Pro or whatever)… You have 300 pages in the wp_posts table. Let’s start from here then… The ACF … Read more
I’m using a plugin called TurboCSV (found here, at the time of writing). The plugin offers support to add data to your various custom fields, which need to be created before the import takes place. In my personal use, I was able to successfully import thousands of items from one .csv, including hundreds of taxonomy … Read more
OPTION 1: If a WordPress WXR file, an XML file exported from WordPress, is too large to import, there are several things you might try to overcome that limit. Increase the amount of memory a PHP script may consume. Note: If using a shared hosting service, you may need to ask your host to increase … Read more
This answer is essentially the same as Ünsal’s, but I’d like to elaborate a bit because despite being right his answer didn’t help me (I was just trying to remember what I’d done in the past, I should have read his more carefully and I would have figured it out, but I think for others … Read more
I had a very similar problem when I moved a WordPress Blog from a single WordPress installation to a Multisite installation with different domain names but same IP. I found out that the problem is the wp_http_validate_url function which drops the URL if the source IP is the same as the destination IP. You can … Read more
Why images don’t get imported It’s the export step that causes the issue here with image attachments. WordPress’ export function doesn’t include the “attachment” post type unless you select the “All content” export option. But if you only want to import and export your posts from one site to another, you lose your attachments. There … Read more
Select * from wp_posts where post_type=”attachment”; Will return all the entries in the Media Library. After the execution, you can export the result table as SQL, or CSV, or any other portable data format you like. Remember, if you are not sure if the entries already exist in your database, use the INSERT IGNORE statement … Read more
This is where your problem is: I then edited the resulting .sql file to update all of the file paths and URL references to point to our production site. You can’t do that. WordPress stores many options as “serialized data”, which contains both the string content of things and their length. So when you modify … Read more
I posed this question to John O’Nolan, a WordPress core developer, who forwarded my question to core committer Aaron Jorbin. O’Nolan responded by saying (I’m paraphrasing) that there isn’t any official documentation on the WXR standard, but that reverse engineering a WXR export should give me all the information I need. O’Nolan also noted that … Read more