Great work Frans There is mysql 5.0.67 version with almost finished recipe for OE. http://209.85.229.132/search?q=cache:P0cKZWGWiMwJ:projects.linuxtogo.org/pipermail/openembedded-devel/2008-September/006249.html+mysql+5.0+OE&cd=3&hl=en&ct=clnk&gl=uk The issue comes up as I was trying to run mythtv on beagle board Sql 5.0 was minimum requirement for mythtv .21 .I somehow managed to get mysql 5.0.67 get cross complied and run with mythtv .21 on beagle board. But I suspect my work around (skipping some runtime tests at two places during cross compilation) was not a proper fix so keep to myself. Perhaps some OE experts can port that recipe properly on OE. Regards Gagan
--- On Fri, 11/6/09, Frans Meulenbroeks <[email protected]> wrote: From: Frans Meulenbroeks <[email protected]> Subject: [oe] mysql 5 To: [email protected] Date: Friday, November 6, 2009, 3:06 AM 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 _______________________________________________ Openembedded-devel mailing list [email protected] http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel
