#mysql
5 PostsRestore selected posts from a backup
Recently at work we had a situation where we needed to roll back to the previous day's backup of our WordPress site to undo some changes…
Removing unused tags in Wordpress
Sometime you may need to mass delete a bunch of tags that are unused (or maybe only used once). I'm sure there are plugins for this, but…
Simple Database Connections
The 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 simple example using…
Import a database from the command line
Sometimes you need to import a large database that exceeds the size limits imposed by phpMyAdmin. You can change some settings in your php…
MySQL SSH tunnel
If your MySQL server is configured to only accept local connections, then you can't connect remotely by just specifying the hostname in your…