{"id":1226,"date":"2019-09-12T10:54:28","date_gmt":"2019-09-12T10:54:28","guid":{"rendered":"http:\/\/blog.inetmar.com\/?p=1226"},"modified":"2024-07-29T16:19:02","modified_gmt":"2024-07-29T13:19:02","slug":"plesk-panel-mysql-upgrade-5-1den-5-5e","status":"publish","type":"post","link":"https:\/\/www.inetmar.com\/blog\/plesk-panel-mysql-upgrade-5-1den-5-5e\/","title":{"rendered":"Plesk Panel MySQL Upgrade 5.1’den 5.5’e"},"content":{"rendered":"

Fiziksel veya VDS sunucular\u0131nda plesk panel kullananlar i\u00e7in var olan MySQL s\u00fcr\u00fcm\u00fcn\u00fcn y\u00fckseltilmesi ile ilgili bilgi payla\u015faca\u011f\u0131z. MySQL versiyonu y\u00fckseltme i\u015flemine ba\u015flamadan \u00f6nce mutlaka sitelerinizin veritaban\u0131 yedeklerini alman\u0131z\u0131 \u00f6neririz.<\/p>\n

Centos Plesk MySQL 5.1’den 5.5’e Y\u00fckseltme<\/strong>
\nwget -q -O – https:\/\/www.atomicorp.com\/installers\/atomic | sh
\nyum upgrade mysql -y
\nmysql_upgrade -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/p><\/blockquote>\n

\"\"<\/p>\n

Debian Plesk MySQL 5.1’den 5.5’e Y\u00fckseltme<\/strong>
\napt-get update
\napt-get upgrade mysql-server
\nmysql_upgrade -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/p><\/blockquote>\n

\"\"<\/p>\n

Centos 6 \u0130\u00e7in Plesk MySQL 5.5’den 5.6 – 5.7’e Y\u00fckseltme<\/strong>
\nservice mysqld stop
\nmkdir \/var\/lib\/mysqlcopy
\ncp -aR \/var\/lib\/mysql\/* \/var\/lib\/mysqlcopy<\/p>\n

nano -w \/etc\/yum.repos.d\/atomic.repo
\nenabled = 0<\/p>\n

yum install https:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-7.noarch.rpm<\/p>\n

MySQL versiyonu se\u00e7iyoruz.<\/strong>
\nnano -w \/etc\/yum.repos.d\/mysql-community.repo
\n[mysql56-community]\nenabled=0
\n[mysql57-community]\nenabled=1<\/p>\n

MySQL’i Update Ediyoruz.<\/strong>
\nyum update mysql -y<\/p>\n

Not :<\/strong> E\u011fer MySQL g\u00fcncellemesi bulunamad\u0131 \u015feklinde hata al\u0131n\u0131rsa a\u015fa\u011f\u0131daki i\u015flemlerin yap\u0131lmas\u0131 gerekmektedir. E\u011fer exclude k\u0131sm\u0131nda mySQL g\u00f6r\u00fcyorsan\u0131z ilgili dosyay\u0131 d\u00fczenleyerek mysql yazan k\u0131sm\u0131 kald\u0131rman\u0131z \/ silmeniz gerekmektedir.<\/p>\n

cat \/etc\/yum.conf | grep exclude
\n\u00d6nek \u00e7\u0131kt\u0131
\nexclude=php-common php-cli php mysql* httpd* mod_ssl*<\/p>\n

MySQL start edelim ve gerekli komutu \u00e7al\u0131\u015ft\u0131ral\u0131m<\/strong>
\nservice mysqld start
\nMYSQL_PWD=`cat \/etc\/psa\/.psa.shadow` mysql_upgrade -uadmin<\/p><\/blockquote>\n

\"\"<\/p>\n

CentOS 7 MySQL 5.5 to 5.7 (MariaDB 10.2) Y\u00fckseltmek
\n<\/strong>mysqldump -uadmin -P3306 -p”`cat \/etc\/psa\/.psa.shadow`” –all-databases > \/tmp\/all-database.sql
\ncp -a \/var\/lib\/mysql\/ \/var\/lib\/mysql.bak
\nservice mariadb stop<\/p>\n

MariaDB Reposity Ekleyelim.<\/strong>
\nnano -w \/etc\/yum.repos.d\/MariaDB10.repo<\/p>\n

# MariaDB 10.1 CentOS repository list – created 2016-01-18 09:58 UTC
\n# https:\/\/mariadb.com\/kb\/en\/mariadb-package-repository-setup-and-usage\/
\n[mariadb10.2]\nname = MariaDB
\nbaseurl = https:\/\/archive.mariadb.org\/mariadb-10.2\/yum\/centos7-amd64\/
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\nenabled=1<\/p>\n[mariadb10.1]\nname = MariaDB
\nbaseurl = https:\/\/archive.mariadb.org\/mariadb-10.2\/yum\/centos7-amd64\/
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\nenabled=0<\/p>\n

yum install mariadb -y<\/p>\n

service mysql start<\/p><\/blockquote>\n

 <\/p>\n

\"\"<\/p>\n

Kesintisiz sunucu<\/a> hizmetleri ile i\u015f \u00fcretkenli\u011finizi art\u0131r\u0131n.<\/p>\n","protected":false},"excerpt":{"rendered":"

Fiziksel veya VDS sunucular\u0131nda plesk panel kullananlar i\u00e7in var olan MySQL s\u00fcr\u00fcm\u00fcn\u00fcn y\u00fckseltilmesi ile ilgili bilgi payla\u015faca\u011f\u0131z. MySQL versiyonu y\u00fckseltme i\u015flemine ba\u015flamadan \u00f6nce mutlaka sitelerinizin veritaban\u0131 yedeklerini alman\u0131z\u0131 \u00f6neririz. Centos Plesk MySQL 5.1’den 5.5’e Y\u00fckseltme...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1226","post","type-post","status-publish","format-standard","hentry","category-plesk"],"_links":{"self":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/comments?post=1226"}],"version-history":[{"count":22,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1226\/revisions"}],"predecessor-version":[{"id":9812,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/posts\/1226\/revisions\/9812"}],"wp:attachment":[{"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/media?parent=1226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/categories?post=1226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inetmar.com\/blog\/wp-json\/wp\/v2\/tags?post=1226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}