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.
阅读(1438) | 评论(0) | 转发(0) |