mysql升级安装_MySQL 5.5.12安装和升级

MySQL 5.5中InnoDB作为默认的数据库存储引擎，mysql-5.1升级mysql到mysql-5.5以后，以下程序需要重新编译安装升级：

PHP 5.3.6

cacti spine

pureftp

安装

wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.12-linux2.6-x86_64.tar.gz/from/http://mysql.ntu.edu.tw/

tar -C /usr/local -xzf  mysql-5.5.12-linux2.6-x86_64.tar.gz

cd /usr/local

ln -s mysql-5.5.12-linux2.6-x86_64/ mysql

cd /usr/local/mysql

mkdir -p /usr/local/mysql/etc/

cp support-files/my-huge.cnf etc/my.cnf

sed -i 's/skip-locking/skip-external-locking/' my.cnf

sed -i 's/default-character-set/character-set-server/' my.cnf

sed -i 's/log_slow_queries/slow_query_log/' my.cnf

修改server-id = 1为服务器ip地址最后几位，或者其它数值：

cd /usr/local/mysql/etc/

vim  my.cnf

#max_allowed_packet = 1M

server-id = 8108

ma