I ended up fixing this by preventing the id clash by adding a huge number to the post id column and then exporting the content. The queries I ran are ; Update the post ids of all attachments. I choose 1000,000 since I already had more than 100,000 posts. update wp_posts set id = id … Read more
Exporting CPT from dev site and import into live site?
Assuming that all the meta (fields) in both of the Custom Post Types (CTPs) is relatable, this is the way I would go about figuring out how much work is in order: Make a new post in each CTP (both sites) and make sure all the meta fields are filled in. It will help if … Read more
If you don’t mind exporting pages and posts separately, you can use the default WordPress export tool to achieve that. On the Export screen you can set the tool to export only posts. Then add a suitable date filter. After that do another export, but this time set the tool to export only pages. You … Read more
Actually there is no primary category key. Usually, the first category is primary category by default. So technically, the below are the only fields I will need. Post ID | Post Title | Post Content | Post Excerpt | Post categories | Category Term IDs
Only a small portion of my export page renders
How do I split a single WPML site with 6 languages (English is Main) into Multisite with 5 subfolders
Content export, reinstall and content import
I have a similar process to output all email addresses from the database into a downloadable txt file. It looks like this: $xoutput = show_subscriber_list(); $xfile = fopen(‘xsubscriber.txt’ , “w”) or die(“Unable to open file!”);; fwrite($xfile,$xoutput); fclose($xfile); $filename=”xsubscriber.txt”; // of course find the exact filename…. header(‘Pragma: public’); header(‘Expires: 0’); header(‘Cache-Control: must-revalidate, post-check=0, pre-check=0’); header(‘Cache-Control: private’, … Read more
The Core export function only outputs data from the prefix_posts and prefix_postmeta tables, so it would take a lot of doing to extend it to export other tables entirely, especially since it converts everything to XML. Instead of trying to modify this core function, it would be much simpler if your plugin’s data could be … Read more