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
1st as you figured out, WordPress does not offer any built in multilingual support for posts and pages. 2nd Themes, plugins etc. need a separate translation workflow than pages. But that is usually ok, since the theme does not change as much as the pages (normally). To translate the themes I would recommend Loco Translate … Read more
A good way around this I’ve found is to modify your local wp-config.php to access the remote database directly. You often have to enable remote sql in CPANEL. Then you enter the remote host URL in the define(‘DB_HOST’, ‘yoursite.com’); part of the config.
How to use the WP export and get images that are contained in a posts gallery
How to export all content with feature images?
The file is likely correct, but the program that you’re viewing it in is probably interpreting it with ISO-8859-1 / latin1 encoding. The é pairing is something I have often seen when viewing a UTF-8 encoded é in latin1. Be sure that the program you are viewing the file in is set to view in … Read more
How do I export WordPress galleries?
Problems with WordPress Import
Export xml use/import images from theme directory
Have you read this: Migrating Multiple Blogs into WordPress 3.0 Multisite Have a look at this Youtube Video too. It’s self explanatory.