Improve your WordPress installation with SQL hacks

July 29, 2010 | No Comments Yet

Jean-Baptiste Jung shares how you can perform very useful tasks and tweaks for your WordPress blog with the use of database SQL queries. Database manipulation may be a bit advanced for the average WordPress user, but for those who are curious, this article is a great start as the tutorials are not really intimidating at all.

Here’s the shortlist:

  1. Creating a Backup of Your Database
  2. Batch Delete Post Revisions
  3. Erase 5000 Spam Comments in a Second
  4. Change the Post Attribution
  5. Manually Reset Your Password
  6. Change Your WordPress Domain Name
  7. Display the Number of SQL Queries on Your blog
  8. Restore Your WordPress Database

View other WordPress posts on Smashing Magazine here.

Leave a Comment | Tags: , , , ,

More than a dozen useful WordPress database queries

March 1, 2010 | No Comments Yet

Secure, clean up, and optimize your blog with 10 “life-saving” SQL queries from Cats Who Code. Most of them are short and should work by simply copying & pasting them into your database manager. Here’s what you can do:

  1. Manually change your password
  2. Transfer posts from one user to another
  3. Delete post revisions and meta associated to those revisions
  4. Batch delete spam comments
  5. Find unused tags
  6. Find and replace data
  7. Get a list of your commentators emails
  8. Disable all your plugins at once
  9. Delete all tags
  10. List unused post meta
  11. Disable comments on older posts
  12. Replace commentator url
  13. Replace commentator email adress
  14. Delete all comments with a specific url

The article also recommends an SQL WordPress plugin so you don’t have to go anywhere else to execute the queries. If you’re not familiar with SQL, the best way to learn is by example! As a precautionary measure, however, make sure to have a database backup ready before doing any database manipulation.

Leave a Comment | Tags: , , , , , , ,

Designing for WordPress screencast series

May 4, 2009 | No Comments Yet

Alex Denning of Nometech.com has launched a screencast called Designing for WordPress, a three-part series that teaches you how to go from a static HTML web design to a full-fledged WordPress design, all in glorious video.

Designing for WordPress is something that a lot of people want to learn how to do. But don’t know where to start. Why? There aren’t too many great tuts out there for people wanting to get started with WordPress theme design. In this screencast we’ll be converting HTML to WordPress: a great place to start for any aspiring theme developer.

If you know a fair amount of HTML and want to go into WordPress theme design, this video should be a good place to start. Watch out for the succeeding parts too!

(Via Hack WordPress)

Leave a Comment | Tags: , , , ,

Blogger to WordPress tutorial

April 10, 2009 | 1 Comment

Gemma Baltazar (The Lady Programmer) has written in a guest post on JaypeeOnline a step-by-step tutorial on migrating from Blogger/BlogSpot to a self-hosted WordPress website. It’s very detailed, complete with screenshots so you know exactly where to click and tweak.

This is just part 1 of, so watch out for the next installment!

Leave a Comment | Tags: , , , ,

WordPress.tv and WordCamp.tv launches

January 17, 2009 | No Comments Yet

WordPress is going interactive with WordPress.tv, the official site of all video tutorials about WordPress. This new website was just announced at Las Vegas WordCamp, the first WordCamp of the year. Here’s what to expect from the site:

Installation and usage tutorials for both WordPress.org and WordPress.com users. If you’re a visual learner, you’ll enjoy this a whole lot more than browsing the Codex or the Support Forums.

WordCamp footage, including behind-the-scenes. Attend WordCamp without having to leave your desk with WordCampTV.

Slides, interviews, and audio by the Automattic team and other WordPress experts. Connect with the people that are making your beloved WordPress the most excellent blogging software out there.

Other WordPress media suggested by you! Know of a great WordPress-related video? Send it via the contact form.

Leave a Comment | Tags: , , , , , ,

WordPress video tutorials for everyone

November 25, 2008 | No Comments Yet

Speckyboy has compiled dozens of video tutorials that will teach you just about everything you need to know about WordPress. And even if you know your way around the PHP files and the admin dashboard, you’ll still be able to learn several new things just by watching.

This post is a must-bookmark! It’s amazing how generous people from the WordPress community are.

Leave a Comment | Tags: , ,