There is more to do to clean up a site than export/import posts data. The malware can be anywhere. And it could have gotten into your site via many paths. Before you export/import posts, you need to ensure that the current posts are not the source of malware. I’d do a whole cleaning of the … Read more
Instead of going for a complex nested array, I decided that it might be best to keep it to simple two level set of arrays. $x = array( 101 => [ (int $parent_id), (bool $completed) ], 102 => [ (int $parent_id), (bool $completed) ], 103 => [ (int $parent_id), (bool $completed) ], 104 => [ … Read more
Yes it is possible, one simple way is to delete wp-config.php and add wp-config-sample.php then open the site in the browser, it ask you to install the wordpress. So, install a fresh wordpress. After that open your phpmyadmin, select the database which wordpress created for you, then check all tables of this database then select … Read more
Try using 127.0.0.1:3306 instead of using localhost. :3306 is the default port when using PHP7. That should do it.
Is it safe to add INDEX to a column in WordPress database?
Reset post IDs with all post meta
Optimize WP site for millions of posts
Found it. It was a field in phpMyAdmin which is set to a semicolon(;) by default. I have changed it to an unused char and the query ran normally.
This should be possible. You can try function seconddb() { global $seconddb; $seconddb = new wpdb(‘Username’,’password’,’database name’,’localhost’) } add_action(‘init’,’seconddb’); in your functions.php. Then you can fire a query to the new db like $seconddb->get_row( “SELECT * FROM yourtable…” ); instead of $wpdb->get_row().
MySQL Actibity without any active visitors via Google Analytics