Debian Lenny, Virtualmin & MySQL 5.1
If you need the latest MySQL version for having cached prepared statements, you may need to follow a process of replacing your existing server:
Edit /etc/apt/sources.list
Add the following:
deb http://packages.dotdeb.org lenny all
Do an update of the packages:
apt-get update
Watch it fail and run (replacing key with the one output from above):
gpg --keyserver pgpkeys.mit.edu --recv-key E9C74FEEA2098A6E gpg -a --export E9C74FEEA2098A6E | apt-key add -
The a test install:
apt-get -s install mysql-server-5.1
Shows that: 2 upgraded, 4 newly installed, 3 to remove and 11 not upgraded.
You should probably stop the server if it is presently running:
/etc/init.d/mysql stop
Now run:
apt-get install mysql-server-5.1
It's possible we may need to also upgrade php5-mysql but looking at what might get updated there could be issues:
apt-get -s install php5-mysql
Stating: 8 upgraded, 0 newly installed, 0 to remove and 6 not upgraded.
In my case this will probably break the existing self-compiled php5-gd module. I have ignored this step.
Remove/comment the line from the /etc/apt/sources.list
Do an update of the packages:
apt-get update
Examine running server using phpmyadmin or mysql -v
References:
http://www.monkeedev.co.uk/blog/2009/03/23/installing-mysql-51-on-debian-and-ubuntu-using-apt/http://howtoforge.com/a-short-introduction-to-apt-pinning