Upgrade to newer MySQL versions e.g. 5.5.27

[Marook]

If you want to upgrade your existing mySQL installation, you can upgrade to the latest version stored in your repositories. In my case, i had a ubuntu 10.04.03 LTS running MySQL Server 5.1 and i wanted to upgrade it to MySQL Server 5.5.2x.

First off all, remove your existing installation with:

Code: [Select]

apt-get remove mysql-server

Dont panic, all your files in /var/mysql still remains, but if you want make a backup in front of the removal process for a better feeling

Now you need to install the command add-apt-repository, which you will find in the package python-software-properties.

Code: [Select]

apt-get install python-software-properties

After that, we add a new repository and install the newer MySQL Server from that repos

Code: [Select]

add-apt-repository ppa:nathan-renniewaldock/ppa
apt-get update
apt-get install mysql-server-5.5

That's it!