I've just installed mysql on gentoo (in order to migrate my server from a windows machine to linux), but gentoo automatically emerge 4.1.20. However, I installed the latest release on my Windows machine in February, which was 5.0.18. How can I get this version of mysql installed in gentoo.

I have mediawiki, so I need to be able to import the databases from the old server to the new server and data files between mysql versions are incompatible. Thanks.

- Ryan

MySQL 4.1.20 is the latest stable version in the Gentoo repository that's why. To use one of the testing versions, currently 4.1.21 and 5.0.22, edit /etc/portage/package.keywords. Add this... Then re-emerge mysql...That should give you mysql-5.0.22.

You'll need to use the correct testing branch. That is, replace amd64 with your processor type. The ~ means use testing. Also, once 5.0.22 moves to the stable branch, you'll need to remove that line from package.keywords. Until then, updates and recompilations with new USE flags will continue to use 5.0.22.

OK, cool that worked.

Now I have a new problem: I now have the upgraded version of mysql and I rebooted my machine and now I get the following error when attempting to start apache:

Apache2 has detected a syntax error in your configuration files:
Syntax error on line 5 of /etc/apache2/modules.d/70_mod_php5.conf: Cannot load /usr/lib/apache2/modules/libphp5.so into server: libmysqlclient.so.14: cannot open shared object file: No such file or directory.

I've checked for this libphp5.so file, and sure enough, it does exist. Everything was working before, so I odn't know why my php5 configuration has crapped out since I haven't changed it (only mysql configuration have I changed)

OK, I re-emerged php and that solved the problem