四虎影视在线影院在线观看,小s货再浪些再咬紧点h,国产精品水嫩水嫩,97精产国品一二三产区

<bdo id="pxyyf"><nobr id="pxyyf"></nobr></bdo>

<track id="pxyyf"></track><b id="pxyyf"><strike id="pxyyf"><ol id="pxyyf"></ol></strike></b>

<b id="pxyyf"></b>

<b id="pxyyf"><address id="pxyyf"></address></b><menuitem id="pxyyf"><address id="pxyyf"></address></menuitem>

<table id="pxyyf"><blockquote id="pxyyf"></blockquote></table>

標(biāo)題: [教程] 升級到MYSQL8.0腳本 [打印本頁]

---

作者: windsage    時間: 2019-3-9 16:25     標(biāo)題: 升級到MYSQL8.0腳本

1. #!/bin/bash
   
2. # mysql 8.0 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://cd-genova.com
   
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 "升級有風(fēng)險 操作需謹(jǐn)慎"
    
16. echo "歡迎學(xué)習(xí)交流互助提高"
    
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. # 數(shù)據(jù)庫文件夾默認(rèn)要求是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. # 建立備份文件夾，這個可以自定義設(shè)置
    
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. # 或者把備份的數(shù)據(jù)庫復(fù)制回來，注意不要覆蓋performance_schema
    
97. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
    
98. echo
    
99. echo "-------------------------------------------------------------"
    
100. echo "數(shù)據(jù)庫需要初始化，自動生成的密碼會存入mysql的日志，默認(rèn)在/var/log/mysql/error.log"
     
101. echo
     
102. echo "此時查看mysql日志，應(yīng)該一切正常了，但新手朋友注意了，此時你的httpd無法啟動了，需要編譯安裝php。"
     
103. echo

復(fù)制代碼

有不足的地方歡迎指出

---

作者: admin    時間: 2019-3-10 10:53

數(shù)據(jù)文件，最好不要直接復(fù)制，版本差距大時，應(yīng)該會有問題
可以使用mysqldump導(dǎo)出再導(dǎo)入

---

作者: windsage    時間: 2019-4-25 10:02

1. #!/bin/bash
   
2. # mysql 8.0 update scripts
   
3. # Author: wdlinux
   
4. # Url: http://cd-genova.com
   
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 "升級有風(fēng)險 操作需謹(jǐn)慎"
    
17. echo "歡迎學(xué)習(xí)交流互助提高"
    
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. # 數(shù)據(jù)庫文件夾默認(rèn)要求是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

復(fù)制代碼

1. service mysqld stop
   
2. # 建立備份文件夾，這個可以自定義設(shè)置
   
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. # 或者把備份的數(shù)據(jù)庫復(fù)制回來，注意不要覆蓋performance_schema
    
25. # cp -pR /mnt/mysql_bk/* /www/wdlinux/mysql/data/  
    
26. echo
    
27. echo "-------------------------------------------------------------"
    
28. echo "數(shù)據(jù)庫需要初始化，自動生成的密碼會存入mysql的日志，默認(rèn)在/var/log/mysql/error.log"
    
29. echo
    
30. echo "此時查看mysql日志，應(yīng)該一切正常了，但新手朋友注意了，此時你的httpd無法啟動了，需要編譯安裝php。"
    
31. echo

復(fù)制代碼

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

---

作者: 冬至雨    時間: 2019-5-18 12:03

這個腳本對菜鳥來說，是比較困難的

---

作者: 24447678@qq.com    時間: 2019-5-24 17:38

START CONFIGURING MYSQL
make: *** 沒有規(guī)則可以創(chuàng)建目標(biāo)“clean”。 停止。


報錯了啊

---

作者: andylau918    時間: 2019-7-10 13:44

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

---

作者: yixianbin    時間: 2019-8-9 15:36

沒有  我準(zhǔn)備試試

---

歡迎光臨 WDlinux官方論壇 (http://cd-genova.com/bbs/)

Powered by Discuz! 7.2

感谢您访问我们的网站，您可能还对以下资源感兴趣：

四虎影视在线影院在线观看,小s货再浪些再咬紧点h,国产精品水嫩水嫩,97精产国品一二三产区

<menuitem id="jvpq7"><address id="jvpq7"></address></menuitem>

<span id="jvpq7"><strike id="jvpq7"><label id="jvpq7"></label></strike></span>