Over on HTG main we’ve been working on cleaning things up after getting hit with an unexplained 35% drop in Google traffic, and as part of that process we’ve been deleting old posts that we don’t really want around anymore.
The problem is that once you delete hundreds or thousands of posts in WordPress, it’s basically impossible to empty the trash using the interface — it’ll take a few minutes and then time out without successfully emptying the trash.
Luckily there is always a better way… and in this case, it’s as simple as running a database script. You can launch a MySQL console by running this command from the terminal, using the values from your wp-config.php file to connect to the database.
mysql -uUser -pPassword database
Once there, paste in the following, and promise not to get mad if your whole site breaks. Maybe you…
The post How to Empty the WordPress Trash Using a MySQL Query appeared first on FeedBox.