Is it safe to directly delete all rows in the wp_posts table that have a post_type of revision? (I’ve seen conflicting answers on this—but I’d love to be able to just do it this way if it’s safe) Safe, it’s safe. If there is only one user (you) that can edit posts on the site … Read more
Since WP-CLI 0.24.0 you can now use aliases which enable you to import a remote database quite easily. By using aliases, you can run WP-CLI commands against another WP-CLI install. That install could be a remote machine. With this in mind I’ve hacked together a bash alias that chains together several WP-CLI commands to pull … Read more
I think the answer to your question right now is “No”. There is no easy way to trigger maybe_convert_table_to_utf8mb4 on sites once they were already upgraded beyond WP 4.3 on a server that didn’t meet the requirements laid out in this post: https://make.wordpress.org/core/2015/04/02/the-utf8mb4-upgrade/ Note that, based on looking at WP source code, it seems they … Read more
You can check by looking at the size of the rewrite_rules option in the database. If it’s small (which I believe it should with this structure), you’re not using verbose rules. By contrast, if you see several lines per static page, you’re using verbose rules and it’s not good.
Update: Since WordPress 4.4. this is now supported by the insert, update, replace and delete methods of wpdb and the ticket #15158 has been closed as fixed. Thanks to @dmsnell for commenting about that update. On the other hand, the null support in wpdb::prepare() is currently closed as wontfix in ticket #12819. Previous answer: NULL … Read more
I would indeed switch to InnoDB. Table locking/row locking has long been discussed by many. I would always choose InnoDB hands down. However, there is another profound reason for choosing InnoDB…CACHING. While most people boast that MyISAM is faster for reads, most people forget that the many cache for MyISAM, which is called the key … Read more
The Problem I think there’s a typo in there: The name of the filter is posts_fields not post_fields. That could explain why the title2 field is unknown, because it’s definition isn’t added to the generated SQL string. Alternative – Single filter We can rewrite it to use only a single filter: add_filter( ‘posts_orderby’, function( $orderby, … Read more
There is a plugin called WP-DB-Backup http://wordpress.org/extend/plugins/wp-db-backup/ You can configure it to email you a backup of your blog at a specific interval.
You could do this using the WordPress uninstall.php support: <?php if( ! defined( ‘WP_UNINSTALL_PLUGIN’ ) ) exit(); global $wpdb; $wpdb->query( “DROP TABLE IF EXISTS NestoNovo” ); delete_option(“my_plugin_db_version”); ?> This uninstall.php file is called when your plugin is deleted.
As far WordPress is concerned – your multi-dimensional array is one option. To update just part of the multi-dimensional array its necessary to retrieve the entire array, alter it accordingly and then update the entire array. Suppose your multi-dimensional array is as follows: my_options = array( ‘option_a’=>’value_a’, ‘option_b’=>’value_b’, ‘inner_array’=>array( ‘foo’ => ‘bar’, ‘hello’ => ‘world’, … Read more