{"id":822,"date":"2022-09-05T11:05:35","date_gmt":"2022-09-05T11:05:35","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=822"},"modified":"2022-10-09T19:18:45","modified_gmt":"2022-10-09T19:18:45","slug":"plesk-panel-mysql-upgrade-5-1den-5-5e","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/plesk-panel-mysql-upgrade-5-1den-5-5e\/","title":{"rendered":"Plesk Panel MySQL Upgrade 5.1&#8217;den 5.5&#8217;e"},"content":{"rendered":"<p>Merhabalar, Bir\u00e7ok\u00a0<strong>Plesk panel<\/strong>\u00a0kullan\u0131c\u0131s\u0131n\u0131n\u00a0<strong>MySQL upgrade<\/strong>\u00a0ederken yanl\u0131\u015fl\u0131kla t\u00fcm verileri silmesi veya yanl\u0131\u015f upgrade i\u015flemi uygulamas\u0131 sonucunda MySQL start edememesine ili\u015fkin bilgi payla\u015faca\u011f\u0131z.<\/p>\n<p><strong>Not : L\u00fctfen \u00f6ncelikle sitelerinize ait yedekleri al\u0131n\u0131z.<\/strong><\/p>\n<p><strong>Centos Plesk MySQL 5.1&#8217;den 5.5&#8217;e Y\u00fckseltme<\/strong><\/p>\n<pre>wget -q -O - http:\/\/www.atomicorp.com\/installers\/atomic | sh\r\nyum upgrade mysql -y\r\nmysql_upgrade -uadmin -p`cat \/etc\/psa\/.psa.shadow`\r\n<\/pre>\n<p><strong>Debian Plesk MySQL 5.1&#8217;den 5.5&#8217;e Y\u00fckseltme<\/strong><\/p>\n<pre>apt-get update\r\napt-get upgrade mysql-server\r\nmysql_upgrade -uadmin -p`cat \/etc\/psa\/.psa.shadow`\r\n<\/pre>\n<p><strong>Centos 6 \u0130\u00e7in Plesk MySQL 5.5&#8217;den 5.6 &#8211; 5.7&#8217;e Y\u00fckseltme<\/strong><\/p>\n<pre>service mysqld stop\r\nmkdir \/var\/lib\/mysqlcopy\r\ncp -aR \/var\/lib\/mysql\/* \/var\/lib\/mysqlcopy\r\n\r\nnano -w \/etc\/yum.repos.d\/atomic.repo\r\nenabled = 0\r\n\r\nyum install http:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-7.noarch.rpm\r\n<\/pre>\n<p>MySQL versiyonu se\u00e7iyoruz.<\/p>\n<pre>nano -w \/etc\/yum.repos.d\/mysql-community.repo\r\n[mysql56-community]\r\nenabled=0\r\n[mysql57-community]\r\nenabled=1\r\n<\/pre>\n<p>MySQL&#8217;i Update Ediyoruz.<\/p>\n<pre>yum update mysql -y\r\n<\/pre>\n<p>Not : 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<pre>cat \/etc\/yum.conf | grep exclude \r\n\u00d6nek \u00e7\u0131kt\u0131 \r\n \r\nexclude=php-common php-cli php mysql* httpd* mod_ssl*\r\n<\/pre>\n<p>MySQL start edelim ve gerekli komutu \u00e7al\u0131\u015ft\u0131ral\u0131m<\/p>\n<pre>service mysqld start\r\nMYSQL_PWD=`cat \/etc\/psa\/.psa.shadow` mysql_upgrade -uadmin\r\n<\/pre>\n<p><strong>CentOS 7 MySQL 5.5 to 5.7 (MariaDB 10.2) Y\u00fckseltmek<\/strong><\/p>\n<pre>mysqldump -uadmin -P3306 -p\"`cat \/etc\/psa\/.psa.shadow`\"  --all-databases &gt; \/tmp\/all-database.sql\r\ncp -a \/var\/lib\/mysql\/ \/var\/lib\/mysql.bak\r\nservice mariadb stop\r\n<\/pre>\n<p>MariaDB Reposity Ekleyelim.<\/p>\n<pre>nano -w \/etc\/yum.repos.d\/MariaDB10.repo\r\n<\/pre>\n<p>&nbsp;<\/p>\n<pre># MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC\r\n# http:\/\/mariadb.org\/mariadb\/repositories\/\r\n[mariadb10.2]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.2\/centos7-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\nenabled=1\r\n\r\n[mariadb10.1]\r\nname = MariaDB\r\nbaseurl = http:\/\/yum.mariadb.org\/10.2\/centos7-amd64\r\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB\r\ngpgcheck=1\r\nenabled=0\r\n<\/pre>\n<pre>yum install mariadb -y \r\nservice mysql start\r\n<\/pre>\n<p>Bol trafikler dileriz.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Merhabalar, Bir\u00e7ok\u00a0Plesk panel\u00a0kullan\u0131c\u0131s\u0131n\u0131n\u00a0MySQL upgrade\u00a0ederken yanl\u0131\u015fl\u0131kla t\u00fcm verileri silmesi veya yanl\u0131\u015f upgrade i\u015flemi uygulamas\u0131 sonucunda MySQL start edememesine ili\u015fkin bilgi payla\u015faca\u011f\u0131z. Not : L\u00fctfen \u00f6ncelikle sitelerinize ait yedekleri al\u0131n\u0131z. Centos Plesk MySQL 5.1&#8217;den 5.5&#8217;e Y\u00fckseltme wget -q -O &#8211; http:\/\/www.atomicorp.com\/installers\/atomic | sh yum upgrade mysql -y mysql_upgrade -uadmin -p`cat \/etc\/psa\/.psa.shadow` Debian Plesk MySQL 5.1&#8217;den 5.5&#8217;e Y\u00fckseltme &hellip;<\/p>\n","protected":false},"author":1,"featured_media":1642,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-822","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/822","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=822"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/822\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/1642"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}