I haven't posted yet on the updated MySQL 5.0.24a version yet because I got some emails from people having trouble compiling it with my instructions. There where some errors during the ./configure phase.

Still need to verify the symptom myself, haven't had the proper time yet to do it but wanted to let you know if you might run into some issues.

The issue is not there, I guess it was a fluke. I've got it compiled and working on my testserver without any problem. I used this version to test my upgrade scenario for v1 to v2 version of the ISP in a box documentation.

Just follow the install doc for MySQL in the blog and it will work !

I'm having trouble understanding the configure commands. I'm installing MySQL 5.0.24a.

I cd'd to the source directory and copy/pasted the following:

CFLAGS="-arch ppc -isysroot /Developer/SDKs/MacOSX10.4u.sdk" \
./configure --prefix=/usr/local/mysql \
 --localstatedir=/usr/local/mysql/data \
 --libexecdir=/usr/local/mysql/bin \
 --libdir=/usr/local/mysql/lib \
 --with-server-suffix=-standard \
 --enable-thread-safe-client \
 --enable-local-infile \
 --enable-shared \
 --with-zlib-dir=bundled \
 --with-big-tables \
 --with-readline \
 --with-archive-storage-engine \
 --with-innodb \
 --without-docs \
 --without-bench \

nothing happened as it ends with a '\' so I ran the command without the ending slash and got this:

checking build system type... powerpc-apple-darwin8.7.0
checking host system type... powerpc-apple-darwin8.7.0
checking target system type... powerpc-apple-darwin8.7.0
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... no
checking for mawk... no
checking for nawk... no
checking for awk... awk
checking whether make sets $(MAKE)... no
checking "character sets"... default: latin1, collation: latin1_swedish_ci; compiled in: latin1 latin1 utf8
checking whether to compile national Unicode collations... yes
checking whether build environment is sane... yes
checking whether make sets $(MAKE)... (cached) no
checking for gawk... (cached) awk
checking for gcc... no
checking for cc... no
checking for cc... no
checking for cl... no
configure: error: no acceptable C compiler found in $PATH
See `config.log' for more details.

Could you show me what I'm doing wrong?

Ryan,

Stupid question perhaps, but do you have the developer tools installed ?


checking for gcc... no
checking for cc... no
checking for cc... no
checking for cl... no


The error message indicates you haven't ?

That must be it. Xcode 2.4 are the current developer tools?

Yes, beware it's a big download, like 900+ Mb. You can find it here:http://developer.apple.com/tools/xcode/

Thanks Richard, got the dev tools installed and had no problems with mysql.