I just installed Ubuntu 12.04 at work, which runs very well. Unfortunately, for work reasons, I need to use mysql version 5.1. I can't find a clean way of installing it. I must install it the usual way because we have scripts that rely on the ubuntu standard installation paths and directories. I would avoid to downgrade my distro (and I have no time to do it). Can you please point out a good way of doing this?
Your best bet is to keep using the release of Ubuntu that your scripts expect. Perhaps you can make use of LXC containers to get this done in a lightweight manner. If your scripts are meant for lucid:
This will create an empty shell container (like a VM, but using the kernel for isolation instead of true virtualization) and bind it to the lxcbr virtual network. It will have your home dir mounted and your user copied in so you can ssh in w/ any keys from
You can start it then with 'sudo lxc-start -n my-lucid-box' and login and install mysql-5.1, which will now be listening on the container's IP (usually in some 10.x.x.x range).
The best part about this is the container is isolated from your working system (except /home/youruser, be careful there!), so when you're done, just lxc-destroy -n my-lucid-box and its all gone (don't worry, it won't remove your home dir).