Installing MySQL 5.1 on Ubuntu

I wanted to use PARTITIONING introduced in MySQL 5.1 to handle some 2 Million records (and growing everyday) in a table. Ubuntu 8.10 does not have MySQL 5.1 available if you do apt-get the latest version available is 5.0

So this is what I did, its easy and this might help somebody.

nano /etc/apt/sources.list

I prefer nano editor but you can use any editor of your choice. Add these new lines at the end of the end of the file.

deb http://ppa.launchpad.net/monty/ubuntu gutsy main universe restricted multiverse
deb http://ppa.launchpad.net/smurf/ubuntu gutsy main universe restricted multiverse

(These packages were targeted for 7.10 so I will recommend using them and removing them from this list once you got the latest MySQL version)

Now run the following commands

apt-get update
apt-get upgrade

Note that you may need to do sudo prefix to these commands if you are using a non-root account. Now lets do the one last step, Installing MySQL 5.1

apt-get install mysql-server-5.1

Update: I have got another source to get even latest minor version of MySQL 5.1, just follow the above steps, then start over again and add following lines to “/etc/apt/sources.list” instead of the one above.

deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all

It worked for me on Ubuntu 8.10, im sure it will work for just any server version.

I am not a linux guru so if someone has a better option to upgrade to MySQL 5.1 or the latest version, please let me know.

6 thoughts on “Installing MySQL 5.1 on Ubuntu

Leave a Reply