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

Vote on the WordPress admin header and navigation design tweaks

April 30, 2009 | No Comments Yet

Several members of the WordPress community have volunteered to make tweaks to the WordPress administration panel and now it’s time for you to vote.

For those who haven’t been keeping track, read this background story.

Okay, so here’s the deal. Modifying the nav/header to be a little nicer is was a last-minute design idea, and if it can’t be worked out in the time we have left before 2.8 (which is very little), we’ll just wait until 2.9 to work on it. But! If someone comes up with something the community really likes and it doesn’t break any of the design guidelines for the rest of WordPress, we could sneak it in.

The poll will close at 8pm New York Time or 2am UTC. Here’s another chance to have a say in the development of WordPress!

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

10-step ritual after installing WordPress

January 20, 2009 | No Comments Yet

WordPress is a cinch to install, and that means this 10-item list of things to do right after installing WordPress shouldn’t be too much trouble, either. Here’s the list:

  1. Change the Admin Password and Manage Your Authors
  2. Edit Permalinks
  3. Upload Your Theme and Activate It
  4. Add Your Categories and Change the Default
  5. Activate Akismet
  6. Install Google XML Sitemaps
  7. Install WordPress Database Backup
  8. Test Your Blog With Dummy Content
  9. Add your RSS feed to Feedburner
  10. Activate your Analytics

It’s a great guide for those who haven’t gotten the hang of tweaking their blog to get their whole system in place. Is there something else that you’re doing that wasn’t mentioned on the list? Additional tasks you might want to consider:

  1. Put security measures in place—a must!
  2. Rearrange the dashboard blocks and write post panel for a more streamlined blogging workflow
  3. Construct your blogroll
  4. Integrate social media (Facebook, Twitter, Plurk, del.icio.us, StumbleUpon, Technorati, etc.) into your blog and vice versa
  5. Add a contact form so people can get in touch with you for non-comment matters and other feedback
  6. Consider advertising options

What’s your post-installation ritual?

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

10 WordPress hacks

January 15, 2009 | No Comments Yet

Take your blog to the next level with this list of neat WordPress hacks, compiled by no less than Smashing Magazine and written by Jean-Baptiste Jung. Here’s what to expect:

  1. Display AdSense Ads to Search Engines Visitors Only
  2. Avoid Duplicate Posts in Multiple Loops
  3. Replacing “Next” and “Previous” Page Links with Pagination
  4. Automatically Get Images on Post Content
  5. Using Normal Quotes Instead of Curly Quotes
  6. Deny Comment Posting to No Referrer Requests
  7. Using CSS Sliding Doors in WordPress Navigaton
  8. Display a Random Header Image on Your WordPress Blog
  9. List Your Scheduled Posts

Each tip may seem difficult at first, but all you have to do is follow the instructions and you’ll be good to go. Perfect for beginner and advanced WordPress lovers!

Leave a Comment | Tags: , , ,