牛刀小试MySQL学习-MySQL升级

MySQL数据库5.0.67升级至MySQL数据库5.1.62全过程

编译源代码mysql数据库5.0.67shell> groupadd mysql shell> useradd -g mysql mysql shell> tar zxvf mysql-5.0.67.tar.gzshell> cd mysql-5.0.67

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 

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

第一步：编译源代码msyql数据库5.1.62（已完成）

shell> cd /usr/tmp

shell> tar zxvf mysql-5.1.62.tar.gzshell> cd mysql-5.1.62

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> 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.