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: , , , ,

Microsoft loves WordPress

May 12, 2010 | 2 Comments

WordPress on Microsoft at MIX Online

While the culture of WordPress and open source software are closely tied with the Linux-Apache-MySQL-PHP stack, that doesn’t mean the publishing platform doesn’t accommodate other development stacks like Microsoft’s. And don’t forget that one of the most popular desktop blogging software is Windows Live Writer!

So MIX Online has opened a new website called WordPress on Microsoft, which aims to provide tips on running WP-powered sites with Windows Server, SQL Server, Windows Azure, and SQL Azure and useful tools like Incarnate.

Why are they doing this? The simple answer is love:

  • Love of technology
  • Love of web developers and web designers
  • Smart business

If you’re running WordPress on a Windows Server or wondering how you can, head over to WP on MS for advice straight from experts. The Getting Started page is a great jump-off point.

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: , , , , , , ,