{"id":2466,"date":"2019-03-03T23:37:06","date_gmt":"2019-03-03T22:37:06","guid":{"rendered":"https:\/\/www.techmedia.pl\/blog\/?p=2466"},"modified":"2019-03-04T01:00:35","modified_gmt":"2019-03-04T00:00:35","slug":"aktualizacja-mysql-5-6-do-5-7-w-ubuntu-16-04","status":"publish","type":"post","link":"https:\/\/www.techmedia.pl\/blog\/aktualizacja-mysql-5-6-do-5-7-w-ubuntu-16-04\/","title":{"rendered":"Aktualizacja MySQL 5.6 do 5.7 w Ubuntu 16.04"},"content":{"rendered":"<p>Przed aktualizacj\u0105 koniecznie nale\u017cy wykona\u0107 kopi\u0119 wszystkich baz danych.<\/p>\n<pre>root@server:\/# <strong>mysqldump -u root -p --all-databases &gt; all_databases.sql<\/strong><\/pre>\n<p>Aktualnie posiadan\u0105 wersj\u0119 sprawdzimy poleceniem:<\/p>\n<pre>root@server:\/# <b>mysql -V<\/b><\/pre>\n<p>lub<!--more--><\/p>\n<pre>root@server:\/# <b>mysql --version\r\n<\/b><\/pre>\n<p>W pierwszym kroku aktualizujemy system:<\/p>\n<pre>root@server:\/# <b>apt-get update\r\n<\/b>root@server:\/# <b>apt-get upgrade\r\n<\/b><\/pre>\n<p>Nast\u0119pnie now\u0105 wersj\u0119 serwera baz danych instalujemy poleceniem:<\/p>\n<pre>root@server:\/# <strong>apt-get install mysql-server<\/strong><\/pre>\n<p>W trakcie instalacji zostanie odinstalowana z systemu poprzednia wersja serwera baz danych i zainstalowana najnowsza.<br \/>\nSprawdzenie tabel na ich zgodno\u015b\u0107 z posiadan\u0105 wersj\u0105 serwera baz danych wykonamy poleceniem:<\/p>\n<pre>root@server:\/# <b>mysql_upgrade -u root -p<\/b><\/pre>\n<p>lub z wymuszeniem sprawdzania:<\/p>\n<pre>root@server:\/# <b>mysql_upgrade --force -u root -p<\/b><\/pre>\n<p>Je\u017celi w logach mamy podobne do poni\u017cszych wpisy:<\/p>\n<pre>[ERROR] Function 'innodb' already exists\r\n[Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.\r\n[ERROR] Function 'federated' already exists\r\n[Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.\r\n[ERROR] Function 'blackhole' already exists\r\n[Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.\r\n[ERROR] Function 'archive' already exists\r\n[Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.<\/pre>\n<p>Nale\u017cy z tabeli &#8222;<span style=\"color: #ff0000;\"><em>plugin<\/em><\/span>&#8221; w bazie danych o nazwie &#8222;<span style=\"color: #ff0000;\"><em>mysql<\/em><\/span>&#8221; usun\u0105\u0107 odpowiednie pluginy:<\/p>\n<pre>DELETE FROM mysql.plugin WHERE name='innodb';\r\nDELETE FROM mysql.plugin WHERE name='federated';\r\nDELETE FROM mysql.plugin WHERE name='blackhole';\r\nDELETE FROM mysql.plugin WHERE name='archive';<\/pre>\n<p>Je\u017celi mamy problem ze startem serwera baz danych podczas startu systemu, wystarczy wykona\u0107 poni\u017csze polecenie:<\/p>\n<pre>root@server:\/# <strong>update-rc.d mysql defaults<\/strong><\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Przed aktualizacj\u0105 koniecznie nale\u017cy wykona\u0107 kopi\u0119 wszystkich baz danych. root@server:\/# mysqldump -u root -p &#8211;all-databases &gt; all_databases.sql Aktualnie posiadan\u0105 wersj\u0119 sprawdzimy poleceniem: root@server:\/# mysql -V lub<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,15],"tags":[62,161,106],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/2466"}],"collection":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/comments?post=2466"}],"version-history":[{"count":10,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/2466\/revisions"}],"predecessor-version":[{"id":2476,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/2466\/revisions\/2476"}],"wp:attachment":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/media?parent=2466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/categories?post=2466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/tags?post=2466"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/yst_prominent_words?post=2466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}