Why not change your site’s htaccess file to include this code RewriteEngine On RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://www.example.com/$1 [R=301,L] …changing to your domain name. This takes all port 80 requests (http) and rewrites them to https. Then, make sure that the wp_options table has the https URL for your site in both locations. There … Read more
I was able to come up with a solution according to advice from the comments. Working code: function import_shows() { $olddb = new wpdb(constant(“DB_USER”),constant(“DB_PASSWORD”),”THE_DB”,constant(“DB_HOST”)); $sql = “SELECT * FROM shows”; $rows = $olddb->get_results($sql); foreach($rows as $obj) { error_log($obj->name); } return; }
Here is the solution i’ve found : in wordpress-importer plugin function process_posts : // try to use _wp_attached file for upload folder placement to ensure the same location as the export site // e.g. location is 2003/05/image.jpg but the attachment post_date is 2010/09, see media_handle_upload() $postdata[‘upload_date’] = $post[‘post_date’]; if ( isset( $post[‘postmeta’] ) ) { … Read more
Option 1 : Since I wanted fresh setup without going through the hassle of changing urls in the database, I went ahead and imported the data from theme and further made the changes on my own. Option 2 : If you really want your old content then I would suggest to use the export option … Read more
How to import several big Import XMLs?
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
Every WordPress site is capable of Multisite from the perspective of the files contained in each. What has to happen is to run some scripts that will prepare the database and file structure, as well as deliver the necessary changes that you will need to make in your .htaccess and wp-config.php files. Everything that you’ll … Read more
Okay, the issue was my last regular expression that changed the http: to https: did not save. I reran the expression again and refreshed the page and it worked. Here’s the gist of how to do this (with wp cli) for anyone who comes across this. In the original site directory: wp db export This … Read more
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
Featured image from custom to WordPress database