With the help of @toscho pointing out get_post();, I was able to spit out a .csv with a blank template. At first, I had memory limit issues b/c of the amount of data, so I moved the site locally and was able to get everything I need with the get_post(); This is the gist of … Read more
All site content for your WordPress site is stored in the database. The files that query and display the data, store settings, etc, are in the theme and plugin folders. There is the wp-config.php file that stores access credentials for your database. And media files are stored in the wp-content folder, but media files locations … Read more
Very likely your settings are there but during your find and replace in sql you may have corrupted the serialised options. If you are doing a mysql dump from site #1 and importing dump to database for site #2, you might want to use my WordPress migration script. Using the WordPress migration script you can … Read more
You should probably not run preg_replace on the meta data for a _wp_attachment_metadata field as the data is serialized. I would recommend instead you write a small script to loop through the images, unserialize the data, update the value, serialize and store the modified array. Here’s a sample function which does just that: function wpse_135525_fix_imagepaths() … Read more
Your easiest option is to just take a copy of your local database and import it to the server using phpmyadmin or similar. You can then add these 2 options to your wp-config.php file to update the site URL. define(‘WP_HOME’,’http://example.com’); define(‘WP_SITEURL’,’http://example.com’); That was you will get everything in the database on to the live site … Read more
Export Custom Post Type posts with all Custom Fields and Custom Texonomy associated with it
Export WordPress Table to CSV from page
Is it possible to recover featured images after WordPress export/import
You don’t have to export and import the tables from the database; you don’t have to build an export/import function for your theme either. There is an Export tool built in WordPress under the Tools menu and in the same sub-menu you’ll find the Import tool as well. The process is pretty straightforward: export the … Read more
I would recommend doing it mostly in Javascript: Basic steps (pseudo code): On the archive page add check boxes <input type=”checkbox” name=”post-with-id-1″ value=”1″> next to each post and a submit button <input type=”submit” value=”Submit”> at the top or bottom of the page. In js, listen for clicks on the submit button. When it is clicked … Read more