linux mysql从5.1升级到5.3的安装方法 - linux运维

tar xvf cmake-2.8.7.tar.gz

cd cmake-2.8.7/

./configure

gmake

make install

tar zxvf mysql-5.5.43.tar.gz

cd mysql-5.5.43/

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \

-DWITH_READLINE=1 \

-DWITH_SSL=system \

-DWITH_ZLIB=system \

-DENABLED_LOCAL_INFILE=1 \

-DEXTRA_CHARSETS=all \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DWITH_EMBEDDED_SERVER=1

make

/etc/init.d/mysql stop

mv /usr/local/mysql/ /usr/local/mysql.old

make install

cp -a /usr/local/mysql.old/var/* /usr/local/mysql/data

chown -R mysql.mysql /usr/local/mysql/data

chgrp -R mysql /usr/local/mysql/.

mv /etc/init.d/mysql /etc/init.d/mysql.old -f

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

chmod 755 /etc/init.d/mysql

cat > /etc/ld.so.conf.d/mysql.conf<<EOF

/usr/local/mysql/lib

/usr/local/lib

EOF

ldconfig

rm -f /usr/lib/mysql

rm -f /usr/include/mysql

rm -f /usr/bin/mysql

rm -f /usr/bin/myisamchk

rm -f /usr/bin/mysqldump

ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql

ln -s /usr/local/mysql/bin/myisamchk /usr/bin/myisamchk

ln -s /usr/local/mysql/bin/mysqldump /usr/bin/mysqldump

ln -s /usr/local/mysql/lib /usr/lib/mysql

ln -s /usr/local/mysql/include /usr/include/mysql

/etc/init.d/mysql start