Upgrade WordPress 2.7 in 3 Simple Steps

Posted on in Categories GNU/Open source, Howto, Linux, Shell scripting, Sys admin, Tips, UNIX last updated December 11, 2008

Wordpress version 2.7 has been released and can be upgraded easily using UNIX / Linux shell prompt. A few assumptions:

  1. Wordpress database name: wptheosblog
  2. Wordpress directory name: /var/www/html/theos.in
  3. Wordpress domain name: theos.in
  4. Operating system: Linux
WARNING! If you are not comfortable with UNIX shell prompt (IF YOU ARE new to a UNIX/Linux os), please follow traditional way of upgrading wordpress and DO NOT use the three Steps described here.

Back up and print WordPress blog with OpenOffice.org Base

Posted on in Categories Download of the day, Howto, Linux, Linux desktop, MySQL last updated November 1, 2007

This sounds like a good idea to me. Never thought one can use OpenOffice to import MySQL database and do all sort of crazy things. I can even build PDF file of all top posts and provide it as download option for a small fee. From the article:

If you are running a blog (or any Web publishing system, for that matter) that relies on a database back end, you will sooner or later face the problem of backing up the content stored in the database. One way to go about it is to build a backup tool using OpenOffice.org Base. Since Base can pull data from a MySQL or any ODBC-compliant data source, you can create a simple database that connects to the blog’s back end and extracts content from it, which you can then export in different formats.

Read more