Backing up your wordpress mysql file and encrypting it for offsite storage.

This is reminder to myself (but if it’s usefull, then feel free).

Forgot the name of the database (Duh!) 😀

Backup wordpress MySQL database

Encrypt using gpg for offsite storage, remember your not using your (or someone’s) public key to encrypt the file, your using a specific password so…

Hint: Keep a note of the password. 😀

The encryted file will have a gpg extension, so in my case it’s called “wordpress.sql.gpg”.

How to Decrypt the file

Will give you 2 files, the original encrypted wordpress.sql.gpg file, and the unencryped wordpress.sql file.

Encrypting and decrypting documents
Backup and Restore MySQL Databases

Upgraded to WordPress 2.5

Just upgraded to WordPress 2.5 using subversion, took me a total of 5 minutes to do (excellent). Disabled all the plugins, ran the following command and updated the database. If your going to try it yourself I would suggest that you read the documentation provided by the WordPress Team before you try. You do of course, need shell access to your webpages before you can use Subversion.


[code lang=”bash”]svn sw[/code]

Continue reading

Upgraded wordpress plugins

Spent a bit of time today upgrading my WordPress plugins

  1. I’ve upgraded Google XML from 3.0.2 to 3.0.3
  2. I’ve upgraded NextGen Gallery from 0.74 to 0.82

I did have a problem with the sideshow part of NextGen, but a quick scan about told me that I was missing the file “imagerotator.swf” from my installation directory. All I had to do was download JW Image Rotator, extract the file “imagerotator.swf” and copy it to my nextgen-gallery plugin directory.

[code lang=”bash”]cp imagerotator.swf ~/public_html/wp-content/plugins/nextgen-gallery/[/code]

Everything seems to have upgraded without a problem 🙂

Updated wordpress using subversion

Ohh the joys of subversion, I’ve just updated my wordpress blog from version 2.3.2 to version 2.3.3 to address a security issue. I’m really glad I converted my wordpress installation last month to use subversion.

All I had to do was ssh into my account and type:

[code lang=”bash”]svn sw[/code]

It then updated the following files:

[code lang=”bash”]
U wp-includes/gettext.php
U wp-includes/version.php
U wp-includes/pluggable.php
U xmlrpc.php
U wp-admin/install-helper.php
Updated to revision 6736.

Job done, lunch time for me 🙂

SportTrack Software

I’ve been using SportTrack Software in conjunction with my Garmin Forerunner 305 over the last year and a half, and I’ve got to say, it’s a brilliant piece of software. That good in fact that I’ve even parted with £15 for the pleasure (money well spent IMHO). It tells me how many miles I’ve ran with my running shoes (really handy) and keeps an inventory of all my running kit. You can even export your run or race to Google Maps and Google Earth, which I think is a brilliant idea and pretty good if your keeping a blog or running diary.

I also use the Inline Google map pluging for wordpress to display my maps, downloadable from here.

Here’s a wee map of last years Fresh n Low Glasgow Half Marathon below

Continue reading

Google Analytics Plugin

I’ve just installed the Google Analytics Plugin which allows you to track visits to your website for free, with the proviso that you have to create an account first of course. You can find out more about it at the google page here and sign up for free here.