mysql-3.23.43 builds

["Gerrit P. Haase" <gp at familiehaase dot de>]

Hallo Cygwinners,

Create a group cyg_mysql and a user mysql with NT's user-management.
Add them in the right files (/etc/group & /etc/passwd), rename user
cyg_mysql to mysql, then build from the sources (patch is attached).

Put the attached patch and the source package (http://www.mysql.com)
in your build tree (e.g. /src/database):

$ tar zxvf mysql-3.23.43.tar.gz

$ cd mysql-3.23.43

$ patch -p0 < ../mysql.patch
patching file `extra/resolveip.c'

NOTE: you may change '--prefix=/usr' to another location
      and add '-mpentiumpro' before '-felide-constructors'
      to CXXFLAGS.

$ CFLAGS="-O3" \
> CXX=gcc \
> CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
> ./configure \
> --prefix=/usr \
> --enable-assembler \
> --with-mysqld-ldflags=-all-static \
> --with-mysqld-user=mysql \
> --with-berkeley-db \
> --with-innodb \
> 2>&1 | tee log.configure

$ make 2>&1 | tee log.make

$ make test 2>&1 | tee log.test
       NOTE:
       there is a problem with communication through
       sockets here, see attached test.log for infos.
       This test fails!!!
       any socket specialists out there to give a
       hint? I have no idea.

$ make install 2>&1 | tee log.make

$ make init-db 2>&1 | tee log.init

$ cd /usr ; /usr/bin/safe_mysqld &

$ cd sql-bench
$ ./run-all-tests
Benchmark DBD suite: 2.14
Date of test:        2001-10-29  2:08:35
Running tests on:    CYGWIN_NT-4.0 1.3.3(0.46/3/2) i686
Arguments:
Comments:
Limits from:
Server version:      MySQL 3.23.43

alter-table:

(It is still running...)

NOTE:
These sql-bench-tests requires the Perl modules DBI & DBD::mysql
to be installed:

$ perl -MCPAN -eshell
cpan> install DBI
cpan> install DBD::mysql
cpan> quit


Ciao,

Gerrit P. Haase                          mailto:gp@familiehaase.de
-- 
=^..^=

mysql.patch

log.test

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/