{"id":1598,"date":"2016-01-16T19:58:42","date_gmt":"2016-01-16T18:58:42","guid":{"rendered":"http:\/\/blog.kodono.info\/wordpress\/?p=1598"},"modified":"2016-01-17T12:30:56","modified_gmt":"2016-01-17T11:30:56","slug":"mise-a-jour-mysql-5-5-vers-5-6-sur-debian-wheezy","status":"publish","type":"post","link":"https:\/\/blog.kodono.info\/wordpress\/2016\/01\/16\/mise-a-jour-mysql-5-5-vers-5-6-sur-debian-wheezy\/","title":{"rendered":"Mise \u00e0 jour mysql 5.5 vers 5.6, sur Debian Wheezy"},"content":{"rendered":"<p><strong>1) Nouveau repo<\/strong><\/p>\n<p>On cr\u00e9e d&#8217;abord le fichier <code>\/etc\/apt\/sources.list.d\/mysql.list<\/code> avec les deux lignes ci-dessous :<br \/>\n<code>deb http:\/\/repo.mysql.com\/apt\/debian\/ wheezy mysql-5.6<br \/>\ndeb-src http:\/\/repo.mysql.com\/apt\/debian\/ wheezy mysql-5.6<\/code><\/p>\n<p><strong>2) Cl\u00e9 publique du repo<\/strong><\/p>\n<p>On cr\u00e9e un fichier <code>mysql.key<\/code> dans lequel on copie\/colle la <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/checking-gpg-signature.html\">cl\u00e9 publique de mysql<\/a>.<\/p>\n<p>Puis on l&#8217;ajoute \u00e0 apt :<br \/>\n<code>apt-key add mysql.key<\/code><\/p>\n<p><strong>3) Export \/ Backup<\/strong><\/p>\n<p>On va faire une sauvegarde de la base de donn\u00e9es et de la configuration de mysql :<br \/>\n<code>mysqldump -u root -pPASSWORD --add-drop-table --routines --events --add-drop-table --all-databases --force > data-for-upgrade.sql<br \/>\ntar cvfvz \/root\/mysql_conf.tgz \/etc\/mysql <\/code><\/p>\n<p><strong>4) Arr\u00eat du serveur<\/strong><\/p>\n<p>On stoppe mysql :<br \/>\n<code>mysqladmin -u root -pPASSWORD shutdown<\/code><\/p>\n<p><strong>5) On met \u00e0 jour apt<\/strong><\/p>\n<p><code>apt-get update<\/code><\/p>\n<p><strong>6) On installe<\/strong><\/p>\n<p>On installe la nouvelle version :<br \/>\n<code>apt-get install mysql-server-5.6<\/code><\/p>\n<p><strong>7) On v\u00e9rifie<\/strong><\/p>\n<p>Une fois fait, on lance :<br \/>\n<code>mysql_upgrade -v -u root -pPASSWORD<\/code><\/p>\n<p><strong>8) Dernier upgrade<\/strong><\/p>\n<p>On lance l&#8217;upgrade pour que tout soit \u00e0 jour :<br \/>\n<code>apt-get upgrade<\/code><\/p>\n<p><strong>9) Mise \u00e0 jour de PHP-Mysql<\/strong><\/p>\n<p>Si vous avez l&#8217;erreur <a href=\"https:\/\/www.skyminds.net\/mysql-resoudre-lerreur-mysql_connect-headers-and-client-library-minor-version-mismatch\/\">mysql_connect(): Headers and client library minor version mismatch<\/a>, il est recommand\u00e9 d&#8217;installer <code>php5-mysqlnd<\/code> :<br \/>\n<code>apt-get install php5-mysqlnd<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1) Nouveau repo On cr\u00e9e d&#8217;abord le fichier \/etc\/apt\/sources.list.d\/mysql.list avec les deux lignes ci-dessous : deb http:\/\/repo.mysql.com\/apt\/debian\/ wheezy mysql-5.6 deb-src http:\/\/repo.mysql.com\/apt\/debian\/ wheezy mysql-5.6 2) Cl\u00e9 publique du repo On cr\u00e9e un fichier mysql.key dans lequel on copie\/colle la cl\u00e9 publique de mysql. Puis on l&#8217;ajoute \u00e0 apt : apt-key add mysql.key 3) Export \/ Backup [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","hide_page_title":"","footnotes":""},"categories":[53,20],"tags":[77,161,63,155],"class_list":["post-1598","post","type-post","status-publish","format-standard","hentry","category-linux","category-niveau-expert","tag-debian","tag-linux","tag-mysql","tag-niveau-expert"],"_links":{"self":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1598","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/comments?post=1598"}],"version-history":[{"count":3,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1598\/revisions"}],"predecessor-version":[{"id":1601,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/1598\/revisions\/1601"}],"wp:attachment":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/media?parent=1598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/categories?post=1598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/tags?post=1598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}