« Using 802.11g Card on 802.11b Access Point | Main | Review of Apple's Music Service »

April 28, 2003

MySQL Binary Distribution Problem

Today I'm building a package for MySQL 4.0.12 (to upgrade our machines in the next little bit). Typically I prefer to compile MySQL from source, but each time I go to get the source code I am convinced that MySQL doesn't want me to compile, but use a binary.

For maximum stability and performance, we recommend that you use the binaries we provide.

Looking around a little I see that the standard release includes support for InnoDB tables, and decide to heed their warning and use the binary distribution.

I notice on install that there is no libexec dir, however the mysqld_safe script tries to execute mysqld in that dir.

> sudo /etc/init.d/mysql start > The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. > cd /usr/local/mysql > sudo ./bin/mysqld_safe > The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe

It appears that the mysqld_safe does some checking to see where the execution is being called from and sets the data dir and bin dir. It's somewhat puzzling to me that the distribution has no libexec dir but the mysqld_safe script seems to default to that dir unless you pass in a different directory as a parameter.

So not a big deal, I can pass in --bindir=/usr/local/mysql/bin and override the default.

Posted by mike at April 28, 2003 11:19 AM