WordPress Archives

Tips and Tricks on WordPress usage and development. I am very passionate about WordPress, but it doesn’t work just by itself – it needs a rich environment to live and breathe in.

If you’re after theme and plugin alterations, we have a category for that.

How to disable update notifications in WordPress

wordpress_iconsSometimes “new” doesn’t always mean “better” or “suitable”.

Sometimes we require older versions of plugins and I’d rather WordPress would not tell me that there’s a newer version available. After all, I might accidentally update a plugin – or perhaps my clients do, breaking the site or overwriting customisations.

Let’s take a look at how we can disable those notifications, both for single plugins and for the entire site.

Read more

What to do if you’ve forgotten all credentials to your WordPress site

This podcast describes how to gain access to WordPress even without username, password or working email address. It’s happened to the best of us: you forgot your Password you forgot what User you are even worse, you’ve forgotten which email you’ve used when you installed WordPress worse still, your email no longer exists Fear not, … Read more

How to restore WordPress to a different domain

In this podcast I will show you how to restore a WordPress site that we’ve backed up in the previous show. In particular, we will restore a remote website to our local system first, and because it’s a rather tricky process we’ll also install it on another remote host. For both examples the domain will … Read more

How to bulk delete posts in WordPress with MySQL

mysqlUsually deleting several posts at once is not a problem thanks to the bulk delete options in WordPress. Those queries however rely on a single delete each, initiated by PHP loop. That’s fine if you’re deleting up to about 100 posts at a time.

But it’s not when you have thousands of posts to delete. I’ve come across installations with hundreds of thousands of posts which have often been created automatically – and there comes the time when you need to clean things up and prune that massive database.

Deleting 100.000 posts is impossible from within WordPress: it puts a huge load on your server, it takes forever, and besides WordPress will time out after about 200 posts.

The solution: a dedicated SQL query.

Sounds scary I know – let’s go through it step by step in this article.

Read more

How to run WordPress on your Laptop

In this new Podcast Season I will start things off by showing you how to run WordPress on your laptop. I will explain this on a Mac, but the process is very similar (if not identical) on a PC. All you need is an installer that gives you Apache, MySQL and PHP on your local … Read more

How to move very large MySQL Databases

I’ve been shifting some things around and came across several very large WordPress databases for a few projects I was hosting. The largest was 1.3GB or 317MB compressed (!) which obviously poses a problem. Most sites – even those of frequent bloggers – amount to well under 2MB when compressed, but Multi Site or BuddyPress databases can get large quick.

To extract a database from a WordPress site, I’ve always relied on the superb WP DB Backup by Austin Matzko but even that timed out after 170MB.

In this article I’ll talk you through how we can handle this. I’m assuming here that a simple phpMyAdmin export/import isn’t working for you anymore. This is by all means not the only way to go about this task.

Read more