{"id":981,"date":"2015-05-29T13:45:42","date_gmt":"2015-05-29T11:45:42","guid":{"rendered":"http:\/\/www.h-hennes.fr\/blog\/?p=981"},"modified":"2015-05-29T13:45:42","modified_gmt":"2015-05-29T11:45:42","slug":"deplacer-les-fichiers-mysql-ubuntu","status":"publish","type":"post","link":"https:\/\/www.h-hennes.fr\/blog\/2015\/05\/29\/deplacer-les-fichiers-mysql-ubuntu\/","title":{"rendered":"D\u00e9placer les fichiers mysql vers un nouvel emplacement"},"content":{"rendered":"<p>Par d\u00e9faut sur les serveurs kimsufi livr\u00e9 par ovh, la partition \u00ab\u00a0\/\u00a0\u00bb allou\u00e9e au syst\u00e8me est relativement r\u00e9duite. ( 20 Go\u00a0 dans mon cas )<br \/>\nSur mon serveur cette partition \u00e9tait quasiment pleine, et une grande partie de l&rsquo;espace \u00e9tait occup\u00e9e par les fichiers des bases de donn\u00e9es.<br \/>\n( dossier \/var\/lib\/mysql\/)<\/p>\n<p>Voici donc comment proc\u00e9der pour d\u00e9placer ces fichiers et lib\u00e9rer de l&rsquo;espace pour votre syst\u00e8me.<\/p>\n<p>Nous allons d\u00e9placer les fichiers de <strong>\/var\/lib\/mysql\/<\/strong> vers <strong><em>\/home\/mysql\/<\/em><\/strong><\/p>\n<p>Pour commencer il faut arr\u00eater mysql<\/p>\n<pre lang=\"bash\">sudo service mysql stop<\/pre>\n<p>Nous pouvons ensuite d\u00e9placer les fichiers vers le nouvel emplacement ( Cette op\u00e9ration peut \u00eatre assez longue en fonction du volume de donn\u00e9es \u00e0 transf\u00e9rer)<\/p>\n<pre lang=\"bash\">sudo mv \/var\/lib\/mysql\/ \/home\/mysql\/<\/pre>\n<p>Puis mettre un lien symbolique de \/home\/mysql\/ vers \/var\/lib\/mysql\/<\/p>\n<pre lang=\"bash\">sudo ln -s \/home\/mysql \/var\/lib\/mysql<\/pre>\n<p>Il faut ensuite attribuer les droits du dossier \u00e0 l&rsquo;utilisateur mysql<\/p>\n<pre lang=\"bash\">sudo chown mysql:mysql \/home\/mysql<\/pre>\n<p>Il ne vous reste plus qu&rsquo;a red\u00e9marrer msyql<\/p>\n<pre lang=\"bash\">sudo service mysql start<\/pre>\n<p>Les fichiers de mysql sont \u00e0 pr\u00e9sent \u00e0 l&#8217;emplacement \u00ab\u00a0<strong>home\/mysql<\/strong>\u00a0\u00bb et votre partition syst\u00e8me retrouve de la place ! \ud83d\ude42<br \/>\nVous pouvez v\u00e9rifier cela avec la commande<\/p>\n<pre lang=\"bash\">df -h<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Par d\u00e9faut sur les serveurs kimsufi livr\u00e9 par ovh, la partition \u00ab\u00a0\/\u00a0\u00bb allou\u00e9e au syst\u00e8me est relativement r\u00e9duite. ( 20 Go\u00a0 dans mon cas ) Sur mon serveur cette partition \u00e9tait quasiment pleine, et une grande partie de l&rsquo;espace \u00e9tait occup\u00e9e par les fichiers des bases de donn\u00e9es. ( dossier \/var\/lib\/mysql\/) Voici donc comment proc\u00e9der [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[254],"tags":[75,257,352],"class_list":["post-981","post","type-post","status-publish","format-standard","hentry","category-serveurs-dedies","tag-mysql","tag-ubuntu","tag-varlibmysql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/981","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/comments?post=981"}],"version-history":[{"count":3,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/981\/revisions"}],"predecessor-version":[{"id":984,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/posts\/981\/revisions\/984"}],"wp:attachment":[{"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/media?parent=981"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/categories?post=981"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h-hennes.fr\/blog\/wp-json\/wp\/v2\/tags?post=981"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}