This is reminder to myself (but if it’s usefull, then feel free).
Forgot the name of the database (Duh!) 😀
mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 887
Server version: 5.1.63-0ubuntu0.10.04.1 (Ubuntu)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
| Database |
| information_schema |
| billy_wordpress |
| mysql |
3 rows in set (0.01 sec)
Backup wordpress MySQL database
mysqldump -u root -p billy_wordpress > wordpress.sql
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
I’ve just donated $10 for the Google Analytics Plugin, one of the better plugins for WordPress in my opinion and well worth the cash.
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 http://svn.automattic.com/wordpress/tags/2.5/[/code]
Spent a bit of time today upgrading my WordPress plugins
- I’ve upgraded Google XML from 3.0.2 to 3.0.3
- 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 🙂
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 http://svn.automattic.com/wordpress/tags/2.3.3/[/code]
It then updated the following files:
Updated to revision 6736.
Job done, lunch time for me 🙂