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) _______________________________________________ Openembedded-devel mailing list [email protected] http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel
