foucist

Prosper202 does much better on MySQL 5.1.  Here’s how to install that:

This is a bit of a hack, so first make sure you install mysql:

# sudo pacman -S mysql

Next, you want ABS (which has all of the package build information so you can compile your own version of an already existing package).

# sudo pacman -S abs

# sudo abs

# cp -R /var/abs/extra/mysql ~/

# cd ~/mysql

# wget http://www.foucist.com/wp-content/uploads/2008/11/pkgbuild

# mv pkgbuild PKGBUILD

# makepkg -s

# if it fails, rm -rf src/  and pacman -S base-devel and try again

# sudo pacman -Uf mysql-5.1.30-1-i686.pkg.tar.gz   (the -f forces it to overwrite the existing mysql files)

# sudo /etc/rc.d/mysqld restart

# mysql –version  (should show client version 5.1.30)

# mysql   (should show Server version: 5.1.30)

ta da!