Upgrading to MySQL 5 [Part 2]

In the earlier post Upgrading to MySQL 5 [Part 1] I have simply reviewed how powerful version 5 is. In this part I will explain how in a typical scenario a DBA can upgrade an existing MySQL4 to MySQL5.

The process normally involves the following steps:

a) shutdown MySQL4 db (/etc/init.d/mysql stop)

b) backup the following files just in case:
- /usr/bin/mysql*
- /etc/mysql/*
- /var/lib/mysql/*

c) download MySQL5 (the non-RPM x86 package) and untar/unzip to ./mysql5. Then install as follows:
- mkdir /usr/local/mysql
- cp -R ./mysql5/* /usr/local/mysql
- cp -R /var/lib/mysql/* /usr/local/mysql/data/
- chown -R mysql:mysql /usr/local/mysql/*

d) startup MySQL5 db:
- cd /usr/local/mysql/bin
- ./mysqld_safe

e) connect to database and confirm that it's ok:
- cd /usr/local/mysql/bin
- ./mysql -u root -p

f) delete backups/old binaries from /usr/bin/

g) smile

RHCP tribute band concert

It was a blast last Sunday on Campus Fest with the Red Hot Chili Peppers tribute band. As expected, their bassist was funkifying on a musicman bass and slapped the hell our of it. In fact as soon as i arrived home i throwed away the 5 string bass, and grabbed again my good old Musicman.


At the moment I'm revising the old school database design tips and I've just stumbled across some interesting links regarding normalization which I would like to share with some fellow techie readers:


And for the more adventurous:

Oracle XE on Debian

I am currently installting Oracle Express Edition on Debian - piece of cake. Take a look here for more info. ORACLE_HOME will be in a place similar to /usr/lib/oracle/xe/


Are you kidding? I still haven't taken any vacation leave this year...Reflects the hopeless environment at work. So what's my hiatus all about? Who cares anyways? hehe..

Will definitely update this blog more and more especially now that my band will have a couple of gigs in the upcoming months. Our last gig at Imqabba was a blast although I must say that the organizers of the Arts Festival and the mayor were disorganized and acted unprofessionally with respect to our band. To mention a few - our time slot was moved from 19:30 to 19:00, reduced from one hour to forty five minutes, interrupted between each song by the compere` of a parallel event in the same Arts Festival, and to put the cherry on the cake, lack of sound equipment - so we had to use just our amplification equipment to deliver sound to the people watching us (for music and gig lovers, the sound engineers dealing with the PA system wasn't aware that there was going to be a band, hence lack of cabling necessary to plug us to the PA). A typical Maltese paprata. Considering all these misfortunes, we managed to deliver a decent professional show...

Msg Shite

At the moment i'm playing around the latest MSN messenger, branded as 'Live Messenger'...Nine out of ten people will not connect anymore to MSN, at least according to my little research. I have found out that if you are having troubles connecting, like me, add these 2 lines to C:/WINDOWS/system32/drivers/etc/hosts file and you ll be able to sign in. messenger.hotmail.com dp.msnmessenger.skadns.net