More than a dozen useful WordPress database queries
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:
- Manually change your password
- Transfer posts from one user to another
- Delete post revisions and meta associated to those revisions
- Batch delete spam comments
- Find unused tags
- Find and replace data
- Get a list of your commentators emails
- Disable all your plugins at once
- Delete all tags
- List unused post meta
- Disable comments on older posts
- Replace commentator url
- Replace commentator email adress
- 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.
WordCamp Philippines 2009 talk: WordPress in the Wild
Markku Seguerra just blogged about his talk in this year’s WordCamp Philippines called “WordPress in the Wild”:
WordPress used to simply be a blogging app and not much more. It’s growth in the past few years though has pushed it to adapt a more extensible structure to allow for other uses beyond blogging as well as various other customizations. These changes made it more appealing to a wider range of users, but at the same time it also introduced some performance bottlenecks that become apparent when your blog rises to be just a bit too popular. Ah, the price of success.
His slides on WordPress deployment, performance, optimization, and security are embedded in the post, but scroll down for all the important links and points covered by his presentation. A bit on the technical side, but definitely a must-read for everyone running a WordPress website.
WordPress training seminar in Cagayan de Oro on July 25
Once again, Blogie Robillo is organizing an advanced training seminar on WordPress deployment, usage, and management–this time on July 25 in Cagayan de Oro City. Specific topics include: WP installation & maintenance, web hosting basics, understanding WP themes, choosing & managing WP plugins, managing content on WP, and monetizing your WP blog with Google AdSense.
Signup here. The seminar costs Php500 and will go last from 9:30 am to 5:00 pm.
Still waiting for WordPress seminars in Metro Manila, guys!
