l\u00e0 pour de l’historique<\/a>…). A mon avis, si MariaDB poursuit longtemps ses \u00e9volutions, les diff\u00e9rences feront que le processus de migration sera un peu plus compliqu\u00e9 dans le futur. Encore qu’un bon package Debian embarquera certainement LE script qui facilite la t\u00e2che. M’enfin dans le doute.<\/p>\nLancez la manip<\/h2>\n
1) Faites un backup (on sait jamais), style mysqldump --lock-tables --skip-lock-tables --all-databases -u root -p | bzip2 -9 > avant.migration.maria.sql.bz2<\/code>
\n2) Pr\u00e9parez-vous un mot de passe root pour la base, pas n\u00e9cessairement celui d’avant
\n3) Lancez aptitude install mariadb-server<\/code>
\n4) R\u00e9pondez \u00ab\u00a0yes\u00a0\u00bb bien s\u00fbr \u00e0 la proposition de reprise des bases MySQL existantes – qui, soulignons-le, ne sont pas effac\u00e9es lors de la d\u00e9sinstallation de MySQL ; ce n’est pas une purge et encore moins avec effacement des bases
\n5) C’est fini. Annoncez \u00e0 votre boss qu’il reste encore 2\/3 jours de pr\u00e9paration et d’ici l\u00e0, profitez de ce temps libre \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"Pourquoi ? Pourquoi migrer sur MariaDB ? Parce-que. Evacuez les quelques craintes Voil\u00e0, maintenant que les raisons sont donn\u00e9es, je tenais juste \u00e0 rassurer ceux qui h\u00e9siteraient \u00e0 migrer de peur qu’un truc se passe …<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,386,83],"tags":[578,40],"class_list":["post-1717","post","type-post","status-publish","format-standard","hentry","category-debian","category-dev","category-ubuntu","tag-mariadb","tag-mysql"],"yoast_head":"\n
Migration MySQL vers MariaDB - Le blog de Michauko<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migration MySQL vers MariaDB - Le blog de Michauko\" \/>\n<meta property=\"og:description\" content=\"Pourquoi ? Pourquoi migrer sur MariaDB ? Parce-que. Evacuez les quelques craintes Voil\u00e0, maintenant que les raisons sont donn\u00e9es, je tenais juste \u00e0 rassurer ceux qui h\u00e9siteraient \u00e0 migrer de peur qu’un truc se passe …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/\" \/>\n<meta property=\"og:site_name\" content=\"Le blog de Michauko\" \/>\n<meta property=\"article:published_time\" content=\"2016-02-11T07:47:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-11T07:49:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png\" \/>\n<meta name=\"author\" content=\"michauko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"michauko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/\"},\"author\":{\"name\":\"michauko\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"headline\":\"Migration MySQL vers MariaDB\",\"datePublished\":\"2016-02-11T07:47:10+00:00\",\"dateModified\":\"2016-02-11T07:49:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/\"},\"wordCount\":308,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo-Mariadb.png\",\"keywords\":[\"MariaDB\",\"mysql\"],\"articleSection\":[\"Debian\",\"dev\",\"Ubuntu\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/\",\"name\":\"Migration MySQL vers MariaDB - Le blog de Michauko\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo-Mariadb.png\",\"datePublished\":\"2016-02-11T07:47:10+00:00\",\"dateModified\":\"2016-02-11T07:49:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#primaryimage\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo-Mariadb.png\",\"contentUrl\":\"https:\\\/\\\/michauko.org\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/logo-Mariadb.png\",\"width\":246,\"height\":185},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/migration-mysql-mariadb-1717\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migration MySQL vers MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/\",\"name\":\"Le blog de Michauko\",\"description\":\"Si tu ne comprends pas le titre de l'article, passe ton chemin\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/michauko.org\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/michauko.org\\\/blog\\\/#\\\/schema\\\/person\\\/0cd9f3d9ce4dccc05df81a5b27051ea9\",\"name\":\"michauko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g\",\"caption\":\"michauko\"},\"sameAs\":[\"http:\\\/\\\/michauko.org\\\/\"],\"url\":\"https:\\\/\\\/michauko.org\\\/blog\\\/author\\\/randomized2\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migration MySQL vers MariaDB - Le blog de Michauko","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/","og_locale":"fr_FR","og_type":"article","og_title":"Migration MySQL vers MariaDB - Le blog de Michauko","og_description":"Pourquoi ? Pourquoi migrer sur MariaDB ? Parce-que. Evacuez les quelques craintes Voil\u00e0, maintenant que les raisons sont donn\u00e9es, je tenais juste \u00e0 rassurer ceux qui h\u00e9siteraient \u00e0 migrer de peur qu’un truc se passe …","og_url":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/","og_site_name":"Le blog de Michauko","article_published_time":"2016-02-11T07:47:10+00:00","article_modified_time":"2016-02-11T07:49:42+00:00","og_image":[{"url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png","type":"","width":"","height":""}],"author":"michauko","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"michauko","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#article","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/"},"author":{"name":"michauko","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"headline":"Migration MySQL vers MariaDB","datePublished":"2016-02-11T07:47:10+00:00","dateModified":"2016-02-11T07:49:42+00:00","mainEntityOfPage":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/"},"wordCount":308,"commentCount":1,"image":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png","keywords":["MariaDB","mysql"],"articleSection":["Debian","dev","Ubuntu"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/","url":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/","name":"Migration MySQL vers MariaDB - Le blog de Michauko","isPartOf":{"@id":"https:\/\/michauko.org\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#primaryimage"},"image":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#primaryimage"},"thumbnailUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png","datePublished":"2016-02-11T07:47:10+00:00","dateModified":"2016-02-11T07:49:42+00:00","author":{"@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9"},"breadcrumb":{"@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#primaryimage","url":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png","contentUrl":"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png","width":246,"height":185},{"@type":"BreadcrumbList","@id":"https:\/\/michauko.org\/blog\/migration-mysql-mariadb-1717\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/michauko.org\/blog\/"},{"@type":"ListItem","position":2,"name":"Migration MySQL vers MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/michauko.org\/blog\/#website","url":"https:\/\/michauko.org\/blog\/","name":"Le blog de Michauko","description":"Si tu ne comprends pas le titre de l'article, passe ton chemin","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/michauko.org\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/michauko.org\/blog\/#\/schema\/person\/0cd9f3d9ce4dccc05df81a5b27051ea9","name":"michauko","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c3a8969c185fd0eef3893a15408f3ef1b36a6681a066b1eb32045643c30ba65?s=96&d=mm&r=g","caption":"michauko"},"sameAs":["http:\/\/michauko.org\/"],"url":"https:\/\/michauko.org\/blog\/author\/randomized2\/"}]}},"_links":{"self":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/comments?post=1717"}],"version-history":[{"count":2,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1717\/revisions"}],"predecessor-version":[{"id":1720,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/posts\/1717\/revisions\/1720"}],"wp:attachment":[{"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/media?parent=1717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/categories?post=1717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michauko.org\/blog\/wp-json\/wp\/v2\/tags?post=1717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"logo-MariaDB\"](\"https:\/\/michauko.org\/blog\/wp-content\/uploads\/2016\/02\/logo-Mariadb.png\"){kind=logo}
Pourquoi migrer sur MariaDB ?<\/p>\n