张微波的BLOG: mysql,php升级笔记

« zhangweibo.cn居然也有人抢注 | 首页 | postfix FAQ (2) »

August 2, 2007

mysql,php升级笔记

1:mysql 5.0.45

useradd -M -o -r -d /www/mysql -s /bin/bash -c "MySQL Server" -u 27 mysql

./configure --prefix=/usr/local/mysql5 --sysconfdir=/etc --enable-assembler --with-mysqld-ldflags=-all-static --localstatedir=/www/mysql --with-big-tables --with-low-memory --with-extra-charsets=all --enable-thread-safe-client

make

make install

cp support-files/my-large.cnf /etc/my.cnf (针对512M的,不同的内存有不同的配置文件)

cp support-files/mysql.server /etc/rc.d/init.d/mysqld5

chmod 755 /etc/rc.d/init.d/mysqld

chkconfig --add mysqld

/usr/local/mysql5/bin/mysql_install_db --user=mysql

vi /etc/ld.so.conf

增加
/usr/local/mysql5/lib/mysql/

保存ldconfig

修改 /etc/profile

export PATH=$PATH:/usr/local/mysql5/bin

设置密码

mysqladmin -u root password 'password'

2:iconv

wget http://ftp.gnu.org/pub/gnu/libiconv/libiconv-1.11.tar.gz

./configure --prefix=/usr
make
make install

ldconfig

3:gd

wget http://www.libgd.org/releases/gd-2.0.35.tar.gz
./configure
make
make install

4:t1lib

./configure

make without_doc
make install

5:freetds

wget ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz

tar zvxf freetds-stable.tgz
cd freetds-0.64
./configure --prefix=/usr/local/freetds --with-tdsver=8.0 --enable-msdblib
make
make install

6:libxm2

wget ftp://xmlsoft.org/libxml2/libxml2-sources-2.6.29.tar.gz

./configure
make
make install

7:php

./configure --prefix=/usr/local/php5 --enable-exif --with-iconv=/usr --with-xml=/usr/local --with-curl=/usr --with-gdbm --with-gettext --enable-track-vars --with-calendar=shared --enable-magic-quotes --enable-trans-sid --enable-wddx --enable-ftp --enable-inline-optimization --with-gd=/usr/local --with-zlib --enable-gd-native-tt --with-t1lib=/usr/local --with-jpeg-dir=/usr --with-zlib-dir=/usr --with-ttf --with-freetype-dir=/usr --with-gd --with-png-dir=/usr --with-jpeg-dir=/usr --with-mysql=/usr/local/mysql5 --enable-force-cgi-redirect --with-apxs2=/usr/local/apache2/bin/apxs --with-mssql=/usr/local/freetds --with-pdo-mysql=/usr/local/mysql5

修改httpd.conf

AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps

修改默认首页 index.php

cp php.ini-dist /usr/local/php5/lib/php.ini

修改php.ini文件
register_globals = On

由 frank 发表于 August 2, 2007 9:29 AM