{"id":7107,"date":"2019-02-26T14:24:24","date_gmt":"2019-02-26T13:24:24","guid":{"rendered":"http:\/\/blog.capdata.fr\/?p=7107"},"modified":"2019-09-13T10:51:26","modified_gmt":"2019-09-13T09:51:26","slug":"deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/","title":{"rendered":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107&#038;title=D%C3%A9placer%20le%20r%C3%A9pertoire%20de%20donn%C3%A9es%20%28datadir%29%20MySQL%20vers%20un%20nouvel%20emplacement%20sur%20Debian\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=D%C3%A9placer%20le%20r%C3%A9pertoire%20de%20donn%C3%A9es%20%28datadir%29%20MySQL%20vers%20un%20nouvel%20emplacement%20sur%20Debian&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p>L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure pour d\u00e9placer et modifier le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouveau r\u00e9pertoire sur Debian 8.<\/p>\n<p>Cet article est une suite de celui sur la resynchronisation d&#8217;un Slave MySQL : <a href=\"http:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/blog.capdata.fr\/index.php\/replication-mysql-resynchronisation-dun-slave-mysql<\/a>.<\/p>\n<p>En effet, suite \u00e0 la resynchronisation du Slave MySQL avec le Master, notre client nous a demand\u00e9 de faire en sorte que le r\u00e9pertoire de donn\u00e9es sur le Slave soit le m\u00eame que sur le Master.<\/p>\n<p>Le Master avait son r\u00e9pertoire de donn\u00e9es (datadir) sur \/opt\/mysql alors que le Slave avait le sien sur le r\u00e9pertoire par d\u00e9faut, \/var\/lib\/mysql.<\/p>\n<p>Nous allons donc faire en sorte que les donn\u00e9es et le r\u00e9pertoire de donn\u00e9es correspondent au r\u00e9pertoire \/opt\/mysql sur le Slave.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Voici donc la proc\u00e9dure pour d\u00e9placer les donn\u00e9es MySQL vers le nouvel emplacement et modifier la valeur du r\u00e9pertoire de donn\u00e9es (datadir) dans la configuration MySQL sur le Slave.<br \/>\n<\/strong><\/p>\n<p>&nbsp;<\/p>\n<h3>Slave (obelix)<\/h3>\n<ul>\n<li>Connaitre le r\u00e9pertoire du datadir :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p*******\r\nmysql&gt; select @@datadir;\r\n+-----------------+\r\n| @@datadir |\r\n+-----------------+\r\n| \/var\/lib\/mysql\/ |\r\n+-----------------+\r\n<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Arr\u00eater le service MySQL :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo \/etc\/init.d\/mysql stop\r\n\r\nsudo \/etc\/init.d\/mysql status<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Si la taille du r\u00e9pertoire de donn\u00e9es n&#8217;est pas trop volumineuse, on peut copier directement le r\u00e9pertoire de donn\u00e9es MySQL vers le nouvel emplacement (sinon compresser le r\u00e9pertoire et le copier) :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo cp -R -p \/var\/lib\/mysql \/opt<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Renommer l&#8217;ancien r\u00e9pertoire en backup :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo mv \/var\/lib\/mysql \/var\/lib\/mysql.bak<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Modifier la configuration du datadir dans le fichier de configuration MySQL situ\u00e9 dans \/etc\/mysql\/my.cnf pour correspondre \u00e0 \/opt\/mysql :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">capdata@obelix:~$ cat \/etc\/mysql\/my.cnf | grep datadir\r\ndatadir = \/var\/lib\/mysql <\/pre>\n<p>Remplacer \/var\/lib\/mysql par \/opt\/mysql :<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\"> sudo vi \/etc\/mysql\/my.cnf\r\n\r\ndatadir = \/opt\/mysql <\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>Sur Debian, si AppArmor est install\u00e9, il faut modifier la configuration des r\u00e8gles de contr\u00f4le d&#8217;acc\u00e8s pour AppArmor (associe un profil de s\u00e9curit\u00e9 \u00e0 chaque programme pour restreindre les capacit\u00e9s) :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">capdata@obelix:~$ cat \/etc\/apparmor.d\/usr.sbin.mysqld | grep \/var\/lib\/mysql\r\n\/var\/lib\/mysql\/ r,\r\n\/var\/lib\/mysql\/** rwk,<\/pre>\n<p>Remplacer \/var\/lib\/mysql par \/opt\/mysql :<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo vi \/etc\/apparmor.d\/usr.sbin.mysqld\r\n\/opt\/mysql\/ r,\r\n\/opt\/mysql\/** rwk,<\/pre>\n<p>Si le package est install\u00e9, red\u00e9marrer le service AppArmor :<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo \/etc\/init.d\/apparmor reload<\/pre>\n<p>&nbsp;<\/p>\n<p><strong>ATTENTION, BIEN VERIFIER QUE LE FICHIER DE CONF \/ETC\/MYSQL\/MY.CNF N&#8217;A PLUS LES DROITS EN ECRITURE (777) POUR LES AUTRES CAR SINON LE SERVICE MYSQL NE VOUDRA PAS D\u00c9MARRER.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Red\u00e9marrer le service MySQL :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo \/etc\/init.d\/mysql start<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>V\u00e9rifier le status MySQL :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">sudo \/etc\/init.d\/mysql status<\/pre>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysqladmin -uroot -p******* status<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>V\u00e9rifier c\u00f4t\u00e9 base de la bonne prise en compte du nouveau r\u00e9pertoire de donn\u00e9es (datadir) :<\/li>\n<\/ul>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">mysql -uroot -p***********\r\nmysql&gt; select @@datadir;\r\n+-------------+\r\n| @@datadir   |\r\n+-------------+\r\n| \/opt\/mysql\/ |\r\n+-------------+\r\n1 row in set (0.00 sec)\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Et voila, votre r\u00e9pertoire de donn\u00e9es (datadir) MySQL a bien \u00e9t\u00e9 d\u00e9plac\u00e9 et est positionn\u00e9 vers son nouvel emplacement !<\/p>\n<p>A bient\u00f4t pour de nouveaux articles sur MySQL.<\/p>\n<p>Erwan Ollitrault<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107&#038;title=D%C3%A9placer%20le%20r%C3%A9pertoire%20de%20donn%C3%A9es%20%28datadir%29%20MySQL%20vers%20un%20nouvel%20emplacement%20sur%20Debian\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=D%C3%A9placer%20le%20r%C3%A9pertoire%20de%20donn%C3%A9es%20%28datadir%29%20MySQL%20vers%20un%20nouvel%20emplacement%20sur%20Debian&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F7107\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure pour d\u00e9placer et modifier le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouveau r\u00e9pertoire sur Debian 8. Cet article est une suite de celui sur la resynchronisation d&#8217;un Slave MySQL :&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":7803,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[306,305,307],"class_list":["post-7107","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-datadir","tag-deplacement","tag-repertoire-de-donnees"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG<\/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:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure pour d\u00e9placer et modifier le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouveau r\u00e9pertoire sur Debian 8. Cet article est une suite de celui sur la resynchronisation d&#8217;un Slave MySQL :&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-26T13:24:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T09:51:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/changedatadir.png\" \/>\n\t<meta property=\"og:image:width\" content=\"676\" \/>\n\t<meta property=\"og:image:height\" content=\"244\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Capdata team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Capdata team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\"},\"author\":{\"name\":\"Capdata team\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\"},\"headline\":\"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian\",\"datePublished\":\"2019-02-26T13:24:24+00:00\",\"dateModified\":\"2019-09-13T09:51:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\"},\"wordCount\":599,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"datadir\",\"deplacement\",\"repertoire de donnees\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\",\"name\":\"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2019-02-26T13:24:24+00:00\",\"dateModified\":\"2019-09-13T09:51:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9\",\"name\":\"Capdata team\",\"sameAs\":[\"https:\/\/www.capdata.fr\"],\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG","og_description":"L&#8217;objectif de cet article est de d\u00e9crire la proc\u00e9dure pour d\u00e9placer et modifier le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouveau r\u00e9pertoire sur Debian 8. Cet article est une suite de celui sur la resynchronisation d&#8217;un Slave MySQL :&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2019-02-26T13:24:24+00:00","article_modified_time":"2019-09-13T09:51:26+00:00","og_image":[{"width":676,"height":244,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2019\/02\/changedatadir.png","type":"image\/png"}],"author":"Capdata team","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Capdata team","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/"},"author":{"name":"Capdata team","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9"},"headline":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian","datePublished":"2019-02-26T13:24:24+00:00","dateModified":"2019-09-13T09:51:26+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/"},"wordCount":599,"commentCount":1,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["datadir","deplacement","repertoire de donnees"],"articleSection":["MySQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/","url":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/","name":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2019-02-26T13:24:24+00:00","dateModified":"2019-09-13T09:51:26+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/deplacer-le-repertoire-de-donnees-datadir-mysql-vers-un-nouvel-emplacement-sur-debian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9placer le r\u00e9pertoire de donn\u00e9es (datadir) MySQL vers un nouvel emplacement sur Debian"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/bfd9395c8ba4fa125792a543377035e9","name":"Capdata team","sameAs":["https:\/\/www.capdata.fr"],"url":"https:\/\/blog.capdata.fr\/index.php\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=7107"}],"version-history":[{"count":25,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7107\/revisions"}],"predecessor-version":[{"id":7324,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/7107\/revisions\/7324"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/7803"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=7107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=7107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=7107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}