Yes, use the “import_id” field in the post, when calling wp_insert_post. This is treated as a “suggested” ID for the post that will be used if no post with that ID already exists. $post = array( ‘post_title’=>’whatever’, ‘post_content’=>’whatever’, ‘import_id’=>123 ); wp_insert_post($post);
Back up your database (this is very very important) and download and install “Velvet Blues Update URLs” plugin. On the settings page enter in the old URL field http://subdomain.domain.com/subdomain.domain.com Enter in the new URL field the URL of your website. Select all options and click “Update”. Update your permalinks as well.
Making content (database) changes on a staging environment is never recommended. You should only use a local/staging environment for template changes. Then, update your theme/plugins (the wp-content folder), and push those files to the live site. Once that’s completed, you can then populate the content. Database merging/synchronization is it’s own specialty/portion of the industry, and … Read more
Since you cannot get access to the website due to a HTTP/HTTPS conflict, you need to ensures that all of the URLs for your website are up-to-date, try the following steps using the Search Replace DB tool: Go and download Interconnect IT’s Database Search & Replace Script here Unzip the file and drop the folder … Read more
You have a narrow selection to choose from. Either replace the database tables with something like wp-cli or have a special import-export process for your data. If you want to make this granular, you could make a post metabox to import/export post content and metadata as json. Then updates could be incremental and on the … Read more
An update & resolution: I asked the web host for help and they found that I had a piece of code in .htaccess limiting the access to wp-config.php. Once the code was removed, all worked as it should.
Two possible easy ways to replace Old website URL to New Website URL: 1/ Directly replace in SQL file: Export the database and open SQL file. Manually find and replace old website URL with new website URL. Once replace is done, save and import database again. 2/ Use Migrate DB plugin: Use the third-party WordPress … Read more
There is extensive question/answers for moving from development to produciton in general Easily Move a WordPress Install from Development to Production? However for your specific question best plugin that I know is commercial BackupBuddy. It packs whole site (including WP itself) and can restore it to different URL.
There might be hardcoded links in the theme; download it and do a multifile search with a text editor. Editing the text dump destroys serialized data; see another Q/A here: Why is my database import losing text widget data? Update 4/19/2015 To correctly change URLs in the database, the SQL queries below will work when … Read more
Note: This is more a comment than an answer, but I wanted to format it nicely. I don’t know about recording, but I imagine something like the following in SQL could work. INSERT INTO DB1.Tbl1 ( id, x, y ) SELECT DB2.Tbl1.id, DB2.Tbl1.x, DB2.Tbl1.y FROM DB2.Tbl1 ON DUPLICATE KEY UPDATE x=x, y=y; Beware, this is … Read more