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 fix “this class is not key value coding-compliant” after accidentally adding an IBOutlet instead of an IBAction

It has happened to us all: you’re in a storyboard, you’re using the Assistant Editor, you want to control-drag from a button into your code and create an action. But sadly you forget to select “Action” from the drop down menu and instead create an outlet. No biggie you think, deleting the outlet code. You […]

How to convert an NSString into an integer

Imagine you had an NSString and wanted to save it as an integer value. You can use the intValue method for that: NSString *myString = @”47″; int myInt = [myString intValue]; To do the reverse, you can use the initWithFormat method: int myInt = 32; NSString *myOtherString = [[NSString alloc]initWithFormat:@”%i”, myInt];

How to backup WordPress

In this podcast I will show you how to backup a full WordPress installation. This includes your files and your database. It’s not a tough task, but you need to know how to do it. We will be using FileZilla and phpMyAdmin for this. Have your credentials ready (you’ll get those from your hosting provider). … Read more

How to style the Add Media button in P2

I’ve noticed that the Add Media button in P2 version 1.4.2 is a bit too low when you write a Blog Post. The button usually sits neatly above the status box, however it cuts into the top of the box due to the additional text field for the blog post – like so: It’s not … 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

Say hello to The WP Guru Podcast

Apple_Podcast_logo

This week I finally had a chance to prepare The WP Guru Podcast for you!

Get all my past, present and future screencasts delivered for free and automatically.

I’ve been planning this for years, and even though relatively simple to setup it took a bit of organisational efforts behind the scenes to make it happen. What this means is that when I record a screencast, you can now receive it via your favourite Podcast Catcher (such as iTunes).

Read more