Building MySQL Embedded for Amarok 2

[Soren Harward]

On Tuesday 23 September 2008 18:12:49 Ian Monroe wrote:
> I haven't actually tested this instructions. Lets use this thread to
> help each other build MySQL embedded. :)

I already have a full client/server installation of MySQL on my Gentoo x86 
machine, and Gentoo applies a whole bunch of its own patches to the MySQL 
tree before compiling it.  Here's what I did to make a MySQLe library which 
is as close as possible to the rest of the MySQL system.

1) cd /usr/portage/dev-db/mysql/

2) ebuild mysql-5.0.60-r1.ebuild unpack

3) cd /var/tmp/portage/dev-db/mysql-5.0.60-r1/work/mysql

4) Patched the source tree with the patches supplied in the 
supplementary_scripts directory.  I had run into problems with MAX_KEY_LENGTH 
while working on the non-embedded MySQL server yesterday.  Patching the 
source is an acceptable short-term fix, but the key length in Amarok's 
database schema is definitely something we need to address soon since we're 
going to be using distro-provided MySQL builds.

5) CFLAGS=" [my other CFLAGS] -fPIC" CXXFLAGS=" [my other CXXFLAGS] -fPIC" \
./configure --prefix=/usr --datadir=/usr/share --sysconfdir=/etc/mysql \
--libexecdir=/usr/sbin --localstatedir=/var/lib/mysql \
--without-docs --without-man --without-server \
--with-embedded-server --without-innodb --without-bench \
--without-berkeley-db --without-row-based-replication \
--without-readline --disable-shared --with-charset=utf8 \
--without-debug --with-pthread --without-openssl --without-query-cache \
--without-geometry --with-pic

6) make

7) cp libmysqld/libmysqld.a /usr/lib/mysql/

8) Built Amarok

-- 
Soren Harward
stharward at gmail.com