MySQL数据库5.0.67升级至MySQL数据库5.1.62全过程
shell> ./configure --prefix=/usr/local/mysql/ --with-server-suffix=-zsd-edition --enable-assembler --enable-local-infile --enable-thread-safe-client --with-big-tables --with-charset=utf8 --with-extra-charsets=gbk,gb2312,utf8,ascii --with-readline --with-ssl --with-embedded-server --with-pthread --with-mysqld-user=mysql --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-plugins=partition,innobase,innodb_plugin > /home/zsd/mysql_setuplogs_configure.log 2>&1
编译源代码mysql数据库5.0.67shell>
groupadd mysql shell>
useradd -g mysql mysql shell>
tar zxvf
mysql-
5.0.67
.tar.gz
shell> cd
mysql-
5.0.67
shell> make > /home/zsd/mysql_setuplogs_make.log 2>&1
shell>make install > /home/zsd/mysql_setuplogs_makeinstall.log 2>&1
shell> cd /usr/local/
shell> chown -R mysql:mysql mysql
创建数据库
mkdir -p /data/3306/data
cd /data
chown -R mysql:mysql 3306
/usr/local/mysql/bin/mysql_install_db --user=mysql --basedir=
/usr/local/mysql/
--datadir=/data/3306/data
编辑my.cnf：vi
/data/3306/my.cnf
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf &/usr/local/mysql/bin/mysql -uroot -S /data/3306/mysql.sock 停止数据库5.0.67/usr/local/mysql/bin/ mysqladmin -uroot -S /data/3306/mysql.sock shutdown
cp -r /data/3307/data/* /data/3317/data
/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf &/usr/local/mysql/bin/mysql -uroot -S /data/3306/mysql.sock 停止数据库5.0.67/usr/local/mysql/bin/ mysqladmin -uroot -S /data/3306/mysql.sock shutdown
cp -r /data/3307/data/* /data/3317/data
第一步：
编译源代码msyql数据库5.1.62（已完成）
shell> cd /usr/tmp
shell> ./configure --prefix=/usr/local/mysql51/ --with-server-suffix=-zsd-edition --enable-assembler --enable-local-infile --enable-thread-safe-client --with-big-tables --with-charset=utf8 --with-extra-charsets=gbk,gb2312,utf8,ascii --with-readline --with-ssl --with-embedded-server --with-pthread --with-mysqld-user=mysql --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-plugins=partition,innobase,innodb_plugin > /home/root/mysql_setuplogs_configure_51.log 2>&1
shell>
tar zxvf
mysql-5.1.62.tar.gz
shell> cd
mysql-5.1.62
shell> make > /home/root/mysql_setuplogs_make51.log 2>&1
shell>make install > /home/root/mysql_setuplogs_makeinstall51.log 2>&1
shell> cd /usr/local/
shell> chown -R mysql:mysql mysql51
第二步：cp数据目录和my.cnf，赋予相关权限（写个脚本，晚上执行备份）
mkdir -p /data/3317/data
cp -r /data/3307/data/* /data/3317/data
cp /data/3307/my.cnf /data/3317/my.cnf
chown -R mysql:mysql /data/3317
ls -l |grep 3317（查看3317目录的权限）
编辑my.cnf：vi /data/3317/my.cnf
****************部分代码***************
[client]
port = 3317
socket = /data/3317/mysql.sock
[mysql]
no-auto-rehash
[mysqld]
user = mysql
port = 3317
socket = /data/3317/mysql.sock
basedir = /usr/local/mysql51
datadir = /data/3317/data
****************部分代码***************
第三步：启动 mysql 5.1.62服务。（明天早上执行）
/usr/local/mysql51/bin/mysqld_safe --defaults-file=/data/3317/my.cnf & （启动mysql服务）
/usr/local/mysql51/bin/mysql_upgrade -uroot
-p'hoodong_050718!!'
-S /data/3317/mysql.sock（升级mysql）
关闭mysql51 /usr/local/mysql51/bin/ mysqladmin -uroot -p'hoodong_050718!!' -S /data/3317/mysql.sock shutdown 重新启动mysql51 /usr/local/mysql51/bin/mysqld_safe --defaults-file=/data/3317/my.cnf & 查看err日志，如果，一切正常，进入数据库，查看表是否有乱码。如果都正常的话，停掉3307，切换端口，升级完毕 /usr/local/webserver/mysql/bin/mysqladmin -uroot -p'hoodong_050718!!' -S /data/3307/mysql.sock shutdown
备注小记：
err日志查看如下：tail -50 testmysql.err
报出了警告日志，这些日志均可重启服务器，修改my.cnf即可。日志如下：
120709 8:22:34 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
120709 8:22:34 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
120709 8:22:34 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release.
120709 8:22:43 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=testmysql-relay-bin' to avoid this problem.
关闭mysql51 /usr/local/mysql51/bin/ mysqladmin -uroot -p'hoodong_050718!!' -S /data/3317/mysql.sock shutdown 重新启动mysql51 /usr/local/mysql51/bin/mysqld_safe --defaults-file=/data/3317/my.cnf & 查看err日志，如果，一切正常，进入数据库，查看表是否有乱码。如果都正常的话，停掉3307，切换端口，升级完毕 /usr/local/webserver/mysql/bin/mysqladmin -uroot -p'hoodong_050718!!' -S /data/3307/mysql.sock shutdown
备注小记：
err日志查看如下：tail -50 testmysql.err
报出了警告日志，这些日志均可重启服务器，修改my.cnf即可。日志如下：
120709 8:22:34 [Warning] '--log-long-format' is deprecated and will be removed in a future release. Please use '--log-short-format' instead.
120709 8:22:34 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
120709 8:22:34 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release.
120709 8:22:43 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=testmysql-relay-bin' to avoid this problem.
