12-20-2008, 09:15 AM
Quote:Over the past 10 years, the MySQL database has become incredibly popular on the Web. Every WordPress blog is driven by a MySQL database, which contains the blogs posts, settings, comments and much more.
While plug-ins and even coding hacks can solve some problems and achieve some tasks, sometimes you dont have any other choice than to execute SQL commands in phpMyAdmin or directly to the database via SSH. Lets take a look at 8 useful SQL hacks for WordPress. Each section of this post presents a problem, suggests a solution and provides an explanation to help you understand the solution.
1. Creating a Backup of Your Database...
2. Batch Delete Post Revisions...
full article: http://www.smashingmagazine.com/2008/12/...sql-hacks/