For Programmers: Free Programming Magazines  


Home > Archive > PHP Installation > February 2006 > Re: [PHP-INSTALL] --with-mysqli and --with-mysql (fwd)









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: [PHP-INSTALL] --with-mysqli and --with-mysql (fwd)
php@karsites.net

2006-02-14, 6:59 pm


Here is how I did it. Using the mysql-standard-5.0.18.tar.gz
static binary distribution for linux.

You have to use the same libraries when compiling the mysql
& mysqli modules. This will happen, as long as you use the
same paths to the MySQL installed files.

For the Linux Non RPM binaries, they are:

--with-mysql=shared,/usr/local/mysql
--with-mysqli=shared,/usr/local/mysql/bin/mysql_config

Almost identical, so obviously you will be using the same
client libraries.


#! /bin/sh
#
# Created by configure

'./configure' \
'--with-apxs2=/usr/local/apache-2.0.55/bin/apxs' \
'--prefix=/usr/local/php-5.1.2' \
'--with-mysql=shared,/usr/local/mysql/' \
'--with-mysql-sock=/var/lib/mysql/mysql.sock' \
'--with-zlib-dir=/usr/include' \
'--with-mysqli=shared,/usr/local/mysql/bin/mysql_config' \
"$@"

HTH

Keith

In theory, theory and practice are the same;
In practice they are not.

On Tue, 14 Feb 2006, JupiterHost.Net wrote:

> To: php-install@lists.php.net
> From: JupiterHost.Net <mlists@jupiterhost.net>
> Subject: [PHP-INSTALL] --with-mysqli and --with-mysql
>
> Howdy list,
>
> http://us2.php.net/manual/en/ref.mysqli.php under "Installation" is says:
> "If you would like to install the mysql extension along with the mysqli
> extension you have to use the same client library to avoid any conflicts."
>
> So, assuming PHP5 and MySQL > 4.1.3:
>
> These are the two ways to do both --with-mysql and --with-mysqli correct:
>
> a) --with-mysql --with-mysqli=/path/to/mysql_config
> b) --with-mysql=/usr --with-mysqli=/usr
>
> If not, whats the proper way to do --with-mysqli with:
>
> a) -with-mysql
> b) --with-mysql=DIR
>
> I asked php-db@lists.php.net but was met with crickets :)
>
> TIA!

JupiterHost.Net

2006-02-14, 6:59 pm



php@karsites.net wrote:

> Here is how I did it. Using the mysql-standard-5.0.18.tar.gz
> static binary distribution for linux.
>
> You have to use the same libraries when compiling the mysql
> & mysqli modules. This will happen, as long as you use the
> same paths to the MySQL installed files.
>
> For the Linux Non RPM binaries, they are:
>
> --with-mysql=shared,/usr/local/mysql
> --with-mysqli=shared,/usr/local/mysql/bin/mysql_config
>
> Almost identical, so obviously you will be using the same
> client libraries.
>
>
> #! /bin/sh
> #
> # Created by configure
>
> './configure' \
> '--with-apxs2=/usr/local/apache-2.0.55/bin/apxs' \
> '--prefix=/usr/local/php-5.1.2' \
> '--with-mysql=shared,/usr/local/mysql/' \
> '--with-mysql-sock=/var/lib/mysql/mysql.sock' \
> '--with-zlib-dir=/usr/include' \
> '--with-mysqli=shared,/usr/local/mysql/bin/mysql_config' \
> "$@"
>
> HTH
>
> Keith


Thanks Keith :)

> In theory, theory and practice are the same;
> In practice they are not.


Where is that quote from, its nice :)
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com