Yes it works! This is the code, assuming both the databases share the same username & password: $wpdb->select(‘mydbname’); wp_cache_flush(); Once done, re-issue the same statements, with the original database name. Can’t see any performance issue at the moment, maybe because this is done when building a custom form picking data from two posts out of … Read more
Try the Web Ninja Comment Count Fixer plugin http://wordpress.org/extend/plugins/web-ninja-comment-count-fixer/
Well, I think you’ve already alluded to the answer. You need to script your database changes. And then run that script on the live database using phpMyAdmin or something like this command if you have terminal access: mysql db_name < scripted_changes.sql If, however, you’ve referring to CONTENT changes then that’s a different thing all together. … Read more
Here is the SQL Query with everything set. This does assume you have the standard wordpress table prefix in your config. update wp_posts set post_title = replace(post_title,”>”,””)
Instead of using $wpdb->query(), use $wpdb->get_results(). This method allows you to specify a return type so the query is returned as an associative array. For example … $results = $wpdb->get_results( “SELECT * FROM mb_download_manager WHERE filename=”” . $namemeta . “.zip””, ARRAY_A ); This will return you an indexed array of associative arrays … so you … Read more
To use wordpress functions outside the context of the wordpress environment, you can include wp-blog-header.php, so in the context of test.php: require(‘./wp-blog-header.php’);
How about a Pivot Query? This would return rows that have first_name,last_name,user_login. You could then add whatever condition you wanted using a WHERE clause. SELECT MAX(CASE WHEN wp_usermeta.meta_key = ‘first_name’ then wp_usermeta.meta_value ELSE NULL END) as first_name, MAX(CASE WHEN wp_usermeta.meta_key = ‘last_name’ then wp_usermeta.meta_value ELSE NULL END) as last_name, wp_users.user_login FROM wp_users LEFT JOIN wp_usermeta … Read more
This will not be the full answer but i think it will greatly help you if you are able to make templates – you will be able to do this: In theme init (when it installs) make function which will make db query to find all post with your post_type and renames post_type to your … Read more
Folks, I think I solved the problem! I switched the import file from UFT-8 to ANSI encoding, and the site appears to be working fine. I guess moving between Windows and Linux machines, encoding is really important. I’ve never had this problem before, but I will watch out for it in the future.
The only native import/export facility is the one under Tools in the admin. And even that needs an extension (plugin) for importing from different formats. It’s pretty straightforward to build one yourself. Something along the lines of: $options = get_my_options(); header( ‘Content-disposition: attachment; filename=my_export.txt’ ); header( ‘Content-Type: text/plain’ ); echo json_encode( $options ); exit; And … Read more