{"id":2004,"date":"2026-01-09T09:39:17","date_gmt":"2026-01-09T08:39:17","guid":{"rendered":"https:\/\/www.delixirpro.com\/blog\/?p=2004"},"modified":"2026-01-09T09:41:12","modified_gmt":"2026-01-09T08:41:12","slug":"deplacer-les-fichiers-dune-base-de-donnee-mysql-mariadb","status":"publish","type":"post","link":"https:\/\/www.delixirpro.com\/blog\/2026\/01\/09\/deplacer-les-fichiers-dune-base-de-donnee-mysql-mariadb\/","title":{"rendered":"D\u00e9placer les fichiers d\u2019une base de donn\u00e9e MySQL (MariaDB)"},"content":{"rendered":"\n

Pour changer de disque les fichiers de la base de donn\u00e9es MariaDB de mani\u00e8re s\u00fbre, il faut suivre une proc\u00e9dure rigoureuse pour \u00e9viter toute perte de donn\u00e9es ou corruption. Voici les \u00e9tapes d\u00e9taill\u00e9es\u2026<\/p>\n\n\n\n

1. Identifier l’emplacement des donn\u00e9es de MySQL<\/p>\n\n\n\n

$ mariadb --silent --batch -e 'SELECT @@datadir;'<\/code><\/pre>\n\n\n\n
G\u00e9n\u00e9ralement, les donn\u00e9es sont ici : \/var\/lib\/mysql\/<\/p>\n\n\n\n
2. Arr\u00eater le serveur MySQL<\/p>\n\n\n\n
$ systemctl stop mariadb<\/code><\/pre>\n\n\n\n
V\u00e9rifier que le serveur est bien arr\u00eat\u00e9 :<\/p>\n\n\n\n
$ systemctl status mariadb<\/code><\/pre>\n\n\n\n
3. Cr\u00e9er le nouveau r\u00e9pertoire de donn\u00e9es :<\/p>\n\n\n\n
$ mkdir -p \/mnt\/nouveau_disque\/mysql_data<\/code><\/pre>\n\n\n\n
4. D\u00e9finir la propri\u00e9t\u00e9 et les permissions correctes pour le nouveau r\u00e9pertoire :<\/p>\n\n\n\n
$ sudo chown -R mysql:mysql \/mnt\/data\/mysql_data\n$ sudo chmod 755 \/mnt\/data\/mysql_data<\/code><\/pre>\n\n\n\n
5. Copier les fichiers de donn\u00e9es vers le nouveau r\u00e9pertoire<\/p>\n\n\n\n
$ rsync -av \/var\/lib\/mysql\/ \/mnt\/nouveau_disque\/mysql_data\/<\/code><\/pre>\n\n\n\n
6. Sauvegarder l\u2019ancien r\u00e9pertoire de donn\u00e9es (recommand\u00e9) :<\/p>\n\n\n\n
$ mv \/var\/lib\/mysql \/var\/lib\/mysql.bak<\/code><\/pre>\n\n\n\n
7. Modifier le fichier de configuration de MariaDB<\/p>\n\n\n\n
7.1. Editer le fichier de configuration qui contient la ligne de d\u00e9claration de stockage des donn\u00e9es :<\/p>\n\n\n\n
$ nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/code><\/pre>\n\n\n\n
7.2. Activer et modifier le ligne suivante :<\/p>\n\n\n\n
[mysqld]\ndatadir=\/mnt\/nouveau_disque\/mysql_data<\/code><\/pre>\n\n\n\n
8. Red\u00e9marrer le serveur MariaDB<\/p>\n\n\n\n
$ systemctl start mariadb<\/code><\/pre>\n\n\n\n
9. V\u00e9rifier le nouvel emplacement du r\u00e9pertoire de donn\u00e9es<\/p>\n\n\n\n
$ mariadb --silent --batch -e 'SELECT @@datadir;'<\/code><\/pre>\n\n\n\n
10. Supprimer l\u2019ancien r\u00e9pertoire de donn\u00e9es (apr\u00e8s confirmation)<\/p>\n\n\n\n
$ rm -rf \/var\/lib\/mysql.bak<\/code><\/pre>\n\n\n\n
Source : https:\/\/blog.cclaude.rocks\/post\/2025\/04\/20.deplacer-fichiers-mariadb.html<\/a><\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Pour changer de disque les fichiers de la base de donn\u00e9es MariaDB de mani\u00e8re s\u00fbre, il faut suivre une proc\u00e9dure rigoureuse pour \u00e9viter toute perte de donn\u00e9es ou corruption. Voici les \u00e9tapes d\u00e9taill\u00e9es\u2026 1....<\/p>\n","protected":false},"author":1,"featured_media":175,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[16,115],"class_list":["post-2004","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tips","tag-mariadb","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2004","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/comments?post=2004"}],"version-history":[{"count":2,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2004\/revisions"}],"predecessor-version":[{"id":2007,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/posts\/2004\/revisions\/2007"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media\/175"}],"wp:attachment":[{"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/media?parent=2004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/categories?post=2004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.delixirpro.com\/blog\/wp-json\/wp\/v2\/tags?post=2004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}