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 🙂