[oe] mysql 5

[Frans Meulenbroeks]

Hi,

Over the last few days I created a recipe for mysql 5.1.40 based upon
the mysql 4.1.22 recipe, the nslu2 optware patches
(http://trac.nslu2-linux.org/optware/browser/trunk/sources/mysql5?rev=8339&order=date&desc=1)
and help on irc.

I think the work is done, so I have committed my changes. (commit 35cc93da88)
The package is called mysql5 and resides in the mysql directory

For now it has DEFAULT_PREFERENCE = "-1" for a number of reasons:

- I am not a mysql wiz so I would suggest someone else tests this too
(it works for the use case I have (mythtv))
- I would appeciate it if someone would review the recipe
- if one generates mysql5 the pacakges are named differently from the
ones from mysql 4 (mysql5 package names start with mysql5)
  HOWEVER a lot of filenames are the same. mysql5 requires
mysql5-native so if you build mysql5, some mysql4 files in staging
will be overwritten
- and last but not least: MYSQL5 DATABASES ARE INCOMPATIBLE WITH MYSQL4!
Apparently it is not possible to convert databases directly from 4 to
5.1, so I decided just to discard my databases.
According to the folks in #mysql the solution is to upgrade from 5 via
5.0 to 5.1.
If someone feels attracted to making a 5.0 recipe, be my guest (I've
already spent more time on this than I planned to, then again I also
learned more than I hoped for :-) )

I would like to ask your opinion on this. If possible I would like to
remove the DEFAULT_PREFERENCE in a week or so as mythtv 0.22 needs
mysql5 (and they are different packages)
Maybe it is possible to issue a big warning if someone moves from 4 to
5, but I do not really know how to detect this properly (especially
not in the case someone explicitly uninstalls mysql before installing
mysql5).

Your feedback is appreciated!
Frans

PS: for now the pid file of mysql is in /var/lib/mysql dir, if someone
feels it should live elsewhere let me know (or fix it after
discussion)
(it cannot be in /var/run as the pid file is written by user mysql who
has no write privileges in that dir, and, at least under angstrom,
/var/run links to /var/volatile/run and is created during boot so
/var/run/mysql is also not really an option)