WordPress Philippines

Improve your WordPress installation with SQL hacks

July 29, 2010 | Leave a Comment

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.

Related Posts

• Previous post: Tips on keeping your WordPress blog secure
• Next post: 7 popular features for a better WordPress theme

• More than a dozen useful WordPress database queries
• WordPress.tv and WordCamp.tv launches
• WordPress video tutorials for everyone
• WordPress Plugin: WordPress Exploit Scanner
• Vote on the WordPress admin header and navigation design tweaks

Tags: database, sql, tutorials, tweaks, wordpress

Leave a Reply

Name (required)

E-mail (required, never displayed)

URI

RSS | Mobile | Email | Twitter

• reputation defender
• Michael Fertik