You’re probably looking for the export/import tools. From the dashboard you can use the export tool to create a file with all the blog posts, comments and users from one blog, and then your other install use the import tool to merge them into the blog you wish to keep. You can map old users … Read more
SELECT u.ID, u.user_email, u.display_name, um1.meta_value AS first_name, um2.meta_value AS last_name, um3.meta_value AS phone_number, um4.meta_value AS salutation, um5.meta_value AS title FROM wp_users u LEFT JOIN wp_usermeta um1 ON u.ID = um1.user_id AND um1.meta_key = ‘first_name’ LEFT JOIN wp_usermeta um2 ON u.ID = um2.user_id AND um2.meta_key = ‘last_name’ LEFT JOIN wp_usermeta um3 ON u.ID = um3.user_id AND … Read more
Joshua – thanks for replying to my question and confirming what needs to remain confidential. If there’s nothing specific you can think of other than admin user data that needs to remain confidential, then I would be confident in saying that’s all you need to worry about (unless you have any plugins which have usernames/passwords, … Read more
Will there be any issue while importing?(since all are on localhost) Yes and no. The content will be fine, as will the posts. Any images uploaded on the other hand will be problematic. This is because it will need to download those images from the original host, which won’t be possible when using a local … Read more
If your custom product catalog is written by you, then you have to do it manually, you can write a script to automate that product if your catalog database is big. Also, there is a plugin to do that you can give a try but this solution is not error-proof, a wrong step will destroy … Read more
Exporting and Importing has been there since at least WordPress 2.1. Probably earlier. It moved into plugins with the release of 3.0, I believe.
Export Users to CSV plugin does support exporting user fields, out of the box. That should work. And, later if you intend to import them to another site, you can try WP All Import plugin, but be aware that this plugin isn’t free.
If you’re on WP 4.4 or newer this function is built in. Go to extra->export and select ‘media’. This will download all attachment posts. You can import the file in your new install.
In your WordPress Dashboard, if you go to Tools > Export, you can select your custom post type and export only posts in that post type. It gives you the option between All Content, Posts, Pages, and your custom post types following those three options. As for SQL, well are you looking to export the … Read more
Since the asker really doesn’t want to post the answer … someone has to do it: SELECT wp_users.ID , wp_users.user_email FROM wp_users LEFT JOIN wp_bp_xprofile_data ON wp_bp_xprofile_data.user_id = wp_users.ID, WHERE wp_bp_xprofile_data.field_id = 8 AND wp_bp_xprofile_data.value=”yes” field_id = 8 being the Field you want to get (in my example, newsletter) wp_bp_xprofile_data.value=”yes”, being the value of the … Read more