[教程] 升级到MYSQL8.0脚本

windsage

1. #!/bin/bash
   
2. # mysql 8.0 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://www.wdlinux.cn
   
5. # Modify: windsage
   
6. 
   
7. IN_DIR="/www/wdlinux"
   
8. 
   
9. if [ ! $1 ];then
   
10.         MYS_VER="8.0.15"
    
11. else
    
12.         MYS_VER=$1
    
13. fi
    
14. 
    
15. echo "升级有风险 操作需谨慎"
    
16. echo "欢迎学习交流互助提高"
    
17. echo "qq：242013800"
    
18. echo
    
19. read -p "DO YOU REALLY WANT TO UPDATE? (Y/N): " yn
    
20. if [ "$yn" == "Y" ] || [ "$yn" == "y" ]; then
    
21.         echo "MYSQL IS NOW UPDATING!"
    
22. else
    
23.         exit
    
24. fi
    
25. echo
    
26. echo "-------------------------------------------------------------"
    
27. echo
    
28. 
    
29. 
    
30. if [ ! -f mysql-${MYS_VER}.tar.gz ];then
    
31. # 因mysql5.7需要boost，所以这个直接是包含boost的源码包
    
32.         wget -c https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-${MYS_VER}.tar.gz -O mysql-${MYS_VER}.tar.gz
    
33. fi
    
34. yum install -y cmake bison libmcrypt-devel libjpeg-devel libpng-devel freetype-devel curl-devel openssl-devel libxml2-devel zip unzip
    
35. if [ ! -d $IN_DIR/mysql-${MYS_VER} ];then
    
36. mkdir -p $IN_DIR/mysql-${MYS_VER}
    
37. # 数据库文件夹默认要求是data
    
38. mkdir -p $IN_DIR/mysql-${MYS_VER}/data
    
39. fi
    
40. 
    
41. if [ ! -d mysql-${MYS_VER} ];then
    
42. tar zxvf mysql-${MYS_VER}.tar.gz
    
43. fi
    
44. cd mysql-${MYS_VER}
    
45. echo "START CONFIGURING MYSQL"
    
46. sleep 3
    
47. make clean
    
48. cmake \
    
49. -DCMAKE_INSTALL_PREFIX=$IN_DIR/mysql-$MYS_VER \
    
50. -DSYSCONFDIR=$IN_DIR/etc \
    
51. -DDEFAULT_CHARSET=utf8 \
    
52. -DDEFAULT_COLLATION=utf8_general_ci \
    
53. -DWITH_SSL=bundled \
    
54. -DWITH_DEBUG=OFF \
    
55. -DWITH_EXTRA_CHARSETS=complex \
    
56. -DENABLED_PROFILING=ON \
    
57. -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    
58. -DWITH_MYISAM_STORAGE_ENGINE=1 \
    
59. -DWITH_MEMORY_STORAGE_ENGINE=1 \
    
60. -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    
61. -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    
62. -DENABLE_DOWNLOADS=1 \
    
63. -DWITH_BOOST=boost/boost_1_68_0/
    
64. [ $? != 0 ] && echo "NO! CONFIGURE ERROR!  :(" && exit
    
65. echo "START MAKE"
    
66. sleep 3
    
67. make
    
68. [ $? != 0 ] && echo "NO! MAKE ERROR!  :(" && exit
    
69. echo "START MAKE INSTALL"
    
70. sleep 3
    
71. make install
    
72. [ $? != 0 ] && echo "NO! MAKE INSTALL ERROR!  :(" && exit
    
73. service mysqld stop
    
74. # 建立备份文件夹，这个可以自定义设置
    
75. if [ ! -d /mnt/mysql_bk ];then
    
76. mkdir -p /mnt/mysql_bk
    
77. cp -pR /www/wdlinux/mysql/var/* /mnt/mysql_bk
    
78. fi
    
79. rm -f /www/wdlinux/mysql
    
80. ln -sf $IN_DIR/mysql-$MYS_VER /www/wdlinux/mysql
    
81. sh scripts/mysql_install_db.sh --user=mysql --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/data
    
82. chown -R mysql.mysql /www/wdlinux/mysql
    
83. chown -R mysql.mysql /www/wdlinux/mysql/data
    
84. mv /www/wdlinux/mysql/data/mysql /www/wdlinux/mysql/data/mysqlo
    
85. cp support-files/mysql.server /www/wdlinux/init.d/mysqld
    
86. chmod 755 /www/wdlinux/init.d/mysqld
    
87. service mysqld restart
    
88. ln -sf $IN_DIR/mysql/lib/libmysqlclient.so.20. /usr/lib/libmysqlclient.so.20
    
89. cd ..
    
90. rm -rf mysql-${Ver}/
    
91. # rm -rf mysql-${Ver}.tar.gz
    
92. sleep 2
    
93. service mysqld restart
    
94. sleep 2
    
95. mysqld --initialize --user=mysql --console
    
96. # 或者把备份的数据库复制回来，注意不要覆盖performance_schema
    
97. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
    
98. echo
    
99. echo "-------------------------------------------------------------"
    
100. echo "数据库需要初始化，自动生成的密码会存入mysql的日志，默认在/var/log/mysql/error.log"
     
101. echo
     
102. echo "此时查看mysql日志，应该一切正常了，但新手朋友注意了，此时你的httpd无法启动了，需要编译安装php。"
     
103. echo

复制代码

有不足的地方欢迎指出

admin

数据文件，最好不要直接复制，版本差距大时，应该会有问题
可以使用mysqldump导出再导入

windsage

1. #!/bin/bash
   
2. # mysql 8.0 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://www.wdlinux.cn
   
5. # Modify: windsage
   
6. 
   
7. IN_DIR="/www/wdlinux"
   
8. 
   
9. if [ ! $1 ];then
   
10. 
    
11.         MYS_VER="8.0.15"
    
12. else
    
13.         MYS_VER=$1
    
14. fi
    
15. 
    
16. echo "升级有风险 操作需谨慎"
    
17. echo "欢迎学习交流互助提高"
    
18. echo "qq：242013800"
    
19. echo
    
20. read -p "DO YOU REALLY WANT TO UPDATE? (Y/N): " yn
    
21. if [ "$yn" == "Y" ] || [ "$yn" == "y" ]; then
    
22.         echo "MYSQL IS NOW UPDATING!"
    
23. else
    
24.         exit
    
25. fi
    
26. echo
    
27. echo "-------------------------------------------------------------"
    
28. echo
    
29. 
    
30. 
    
31. if [ ! -f mysql-boost-${MYS_VER}.tar.gz ];then
    
32. # 因mysql5.7需要boost，所以这个直接是包含boost的源码包
    
33.         wget -c https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-${MYS_VER}.tar.gz
    
34. fi
    
35. yum install -y cmake bison libmcrypt-devel libjpeg-devel libpng-devel freetype-devel curl-devel openssl-devel libxml2-devel zip unzip
    
36. if [ ! -d $IN_DIR/mysql-${MYS_VER} ];then
    
37. mkdir -p $IN_DIR/mysql-${MYS_VER}
    
38. # 数据库文件夹默认要求是data
    
39. mkdir -p $IN_DIR/mysql-${MYS_VER}/data
    
40. fi
    
41. 
    
42. if [ ! -d mysql-${MYS_VER} ];then
    
43. tar zxvf mysql-${MYS_VER}.tar.gz
    
44. fi
    
45. cd mysql-${MYS_VER}
    
46. echo "START CONFIGURING MYSQL"
    
47. sleep 3
    
48. mkdir -p build
    
49. cd  build/
    
50. make clean
    
51. cmake. \
    
52. -DCMAKE_INSTALL_PREFIX=$IN_DIR/mysql-$MYS_VER \
    
53. -DSYSCONFDIR=$IN_DIR/etc \
    
54. -DDEFAULT_CHARSET=utf8 \
    
55. -DDEFAULT_COLLATION=utf8_general_ci \
    
56. -DWITH_SSL=bundled \
    
57. -DWITH_DEBUG=OFF \
    
58. -DWITH_EXTRA_CHARSETS=complex \
    
59. -DENABLED_PROFILING=ON \
    
60. -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    
61. -DWITH_MYISAM_STORAGE_ENGINE=1 \
    
62. -DWITH_MEMORY_STORAGE_ENGINE=1 \
    
63. -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    
64. -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    
65. -DENABLE_DOWNLOADS=1 \
    
66. -DWITH_BOOST=../boost/boost_1_68_0/
    
67. [ $? != 0 ] && echo "NO! CONFIGURE ERROR!  :(" && exit
    
68. echo "START MAKE"
    
69. sleep 3
    
70. make
    
71. [ $? != 0 ] && echo "NO! MAKE ERROR!  :(" && exit
    
72. echo "START MAKE INSTALL"
    
73. sleep 3
    
74. make install
    
75. [ $? != 0 ] && echo "NO! MAKE INSTALL ERROR!  :(" && exit

复制代码

1. service mysqld stop
   
2. # 建立备份文件夹，这个可以自定义设置
   
3. if [ ! -d /mnt/mysql_bk ];then
   
4. mkdir -p /mnt/mysql_bk
   
5. cp -pR /www/wdlinux/mysql/var/* /mnt/mysql_bk
   
6. fi
   
7. rm -f /www/wdlinux/mysql
   
8. ln -sf $IN_DIR/mysql-$MYS_VER /www/wdlinux/mysql
   
9. sh scripts/mysql_install_db.sh --user=mysql --basedir=/www/wdlinux/mysql --datadir=/www/wdlinux/mysql/data
   
10. chown -R mysql.mysql /www/wdlinux/mysql
    
11. chown -R mysql.mysql /www/wdlinux/mysql/data
    
12. mv /www/wdlinux/mysql/data/mysql /www/wdlinux/mysql/data/mysqlo
    
13. cp support-files/mysql.server /www/wdlinux/init.d/mysqld
    
14. chmod 755 /www/wdlinux/init.d/mysqld
    
15. service mysqld restart
    
16. ln -sf $IN_DIR/mysql/lib/libmysqlclient.so.20. /usr/lib/libmysqlclient.so.20
    
17. cd ..
    
18. rm -rf mysql-${Ver}/
    
19. # rm -rf mysql-${Ver}.tar.gz
    
20. sleep 2
    
21. service mysqld restart
    
22. sleep 2
    
23. mysqld --initialize --user=mysql --console
    
24. # 或者把备份的数据库复制回来，注意不要覆盖performance_schema
    
25. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
    
26. echo
    
27. echo "-------------------------------------------------------------"
    
28. echo "数据库需要初始化，自动生成的密码会存入mysql的日志，默认在/var/log/mysql/error.log"
    
29. echo
    
30. echo "此时查看mysql日志，应该一切正常了，但新手朋友注意了，此时你的httpd无法启动了，需要编译安装php。"
    
31. echo

复制代码

修改了一下  解决In-source builds are not allowed

冬至雨

这个脚本对菜鸟来说，是比较困难的

24447678@qq.com

START CONFIGURING MYSQL
make: *** 没有规则可以创建目标“clean”。 停止。


报错了啊

andylau918

有站長能成功更新嗎?謝謝

yixianbin

没有  我准备试试