Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1984555
  • 博文数量: 176
  • 博客积分: 1857
  • 博客等级: 上尉
  • 技术积分: 2729
  • 用 户 组: 普通用户
  • 注册时间: 2012-04-14 22:55
个人简介

吾生有涯,而知无涯,适当止学.循序渐进,步步提升 Talk is cheap, show me the code.

文章分类

全部博文(176)

文章存档

2019年(1)

2018年(14)

2017年(20)

2016年(31)

2015年(15)

2014年(5)

2013年(10)

2012年(80)

分类: Mysql/postgreSQL

2012-07-09 09:17:19

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) |
给主人留下些什么吧!~~