[oe] mysql 5

[gagan singh]

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 <fransmeulenbroeks at gmail.com> wrote:


From: Frans Meulenbroeks <fransmeulenbroeks at gmail.com>
Subject: [oe] mysql 5
To: openembedded-devel at lists.openembedded.org
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
Openembedded-devel at lists.openembedded.org
http://lists.linuxtogo.org/cgi-bin/mailman/listinfo/openembedded-devel