8 Useful WordPress SQL Hacks
December 23rd, 2008 by MattSmashing Magazine has done it again. Their latest post, 8 Useful WordPress SQL Hacks, is a goldmine of useful tricks to streamline your WordPress experience.
The tips include
- Backing up (and restoring) your database
- Batch deleting post revisions
- Resetting a lost admin password
- Updating your database with a new domain, if you ever move to a new one
Definitely some knowledge to have your blogger’s toolbox.
If you really want to master SQL, I’d recommend reading Learning MySQL or similar book.
Twitter
TwitterI think I have my automated backup system fully set up. /var/www, /etc, and a dir with MySQL dumps are synced to Amazon S3 daily by cron.
Follow Matt on Twitter