You may or may not know this, but your WordPress blog is driven by a MySQL database, which contains the blog’s posts, settings, comments and much more. Over the past decade or so, MySQL has become the most popular database engine on the Web.
As fantastic as WordPress is, there are times when you don’t have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Jean-Baptiste Jung has written an incredibly useful article for Smashing Magazine (a great source for WordPress tips, BTW), outlining 8 useful MySQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.
Covered in this article…
- Creating a Backup of Your Database
- Batch Delete Post Revisions
- Erase 5000 Spam Comments in a Second
- Change the Post Attribution
- Manually Reset Your Password
- Change Your WordPress Domain Name
- Display the Number of SQL Queries on Your Blog
- Restore Your WordPress Database
Click here to read the full article on Smashing Magazine.
