February 14, 2014Restore selected posts from a backupRecently at work we had a situation where we needed to roll back to the previous day's backup of our WordPress site to...mysqlwordpress
November 25, 2013Removing unused tags in WordpressSometime you may need to mass delete a bunch of tags that are unused (or maybe only used once). I'm sure there are...mysqlwordpress
August 24, 2013Simple Database ConnectionsThe other day I had to explain to someone how to connect to a MySQL database in PHP. It was a good reminder. Here's a...mysqlphp
July 30, 2013Import a database from the command lineSometimes you need to import a large database that exceeds the size limits imposed by phpMyAdmin. You can change some...shellmysql
June 17, 2013MySQL SSH tunnelIf your MySQL server is configured to only accept local connections, then you can't connect remotely by just specifying...shellmysqlphp