Produit
Catégorie
Auteur
Référence
Prix
entre et
arrow Home » Tutoriaux » Changer le répertoire de stockage mysql

Changer le répertoire de stockage mysql

Apache / PHP / MySQL - 05 Aug 2008 - blag
Comment modifier l'emplacement des données


Il arrive bien souvent que l'emplacement de stockage mysql par défaut ne conviennent pas.

Imaginons que l'on veuille mettre les fichiers de la base de données dans /home/mysql

Tout d'abord nous allons stopper mysql


Code
/etc/init.d/mysql stop


Nous allons éditer le fichier des paramètres mysql (my.cnf)


Code
nano /etc/mysql/my.cnf


et modifier la ligne


Code
datadir                = /var/lib/mysql

par

Code
datadir                = /home/mysql


ctrl+O pour sauvegarder et ctrl+X pour quitter

L'essentiel de la manipulation consiste à conserver les droits à l'identique sur les fichiers, d'où l'utilisation de l'option -a de la commande copie de fichier sous linux (cp)


Code
cp -a /var/lib/mysql /home


Si vous ne pouvez pas copier directement les fichiers vous pouvez les archiver avec la commande tar, les droits seront conservés.

On se place dans le répertoire où se trouve le répertoire de stockage mysql


Code
cd /var/lib


On compresse tout ce que contient le répertoire de stockage mysql


Code
tar -czvf /home/mysql.tgz mysql


On va se placer à l'endroit où l'on veut déplacer le répertoire de stockage mysql


Code
cd /home


On décompresse le répertoire de stockage mysql archivé précédemment


Code
tar -xzvf mysql.tgz


On redémarre mysql


Code
/etc/init.d/mysql start


Voilà c'est terminé, les fichiers de stockage de mysql ont été déplacés avec les mêmes droits.
Précédent : IP fail-over sous Gentoo OVHSuivant : Installer Webmin sur Debian


5.6 /10 (1046 votes)


Commentaires

breitling watches replica uk
Fri 04 Aug 2017 19:43 - louboutinwedges

<a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a> | <a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a> | replica watches india online shopping
buy casio replica watches in india
new breitling emergency for sale
<strong><a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


listino prezzi orologi omega seamaster
Fri 04 Aug 2017 19:43 - louboutinwedges

fake watches | replica watches | fake watches
replica omega watches
replica watches
<strong><a href="https://igirlbag.com/newindex"> fake watches</a></strong> | <strong><a href="https://igirlbag.com/newindex">replica watches</a></strong> | <strong><a href="https://igirlbag.com/newindex"> fake watches</a></strong><br>
<strong><a href="https://igirlbag.com/newindex"> fake watches</a></strong> | <strong><a href="https://igirlbag.com/newindex">replica watches</a></strong> | <strong><a href="https://igirlbag.com/newindex"> fake watches</a></strong><br>
<strong><a href="https://igirlbag.com/newindex"> replica omega watches</a></strong><br>
<strong><a href="https://igirlbag.com/newindex">replica watches</a></strong><br>


breitling avenger skyland ref. a13380
Fri 04 Aug 2017 19:43 - louboutinwedges

<a href="http://rauluribe.com/newindex">breitling avenger skyland ref. a13380</a> | buy fake luxury watches online india | breitling bentley 6.75 replica
omega seamaster watches prices second hand
<a href="http://rauluribe.com/newindex">breitling bentley gt</a>
<strong><a href="http://rauluribe.com/newindex">breitling avenger skyland ref. a13380</a></strong> | <strong><a href="http://rauluribe.com/newindex">buy fake luxury watches online india</a></strong> | <strong><a href="http://rauluribe.com/newindex">breitling bentley 6.75 replica</a></strong><br>
<strong><a href="http://rauluribe.com/newindex">breitling avenger skyland ref. a13380</a></strong> | <strong><a href="http://rauluribe.com/newindex">buy fake luxury watches online india</a></strong> | <strong><a href="http://rauluribe.com/newindex">breitling bentley 6.75 replica</a></strong><br>
<strong><a href="http://rauluribe.com/newindex">omega seamaster watches prices second hand</a></strong><br>
<strong><a href="http://rauluribe.com/newindex">breitling bentley gt</a></strong><br>


rolex watches price in india lowest
Fri 04 Aug 2017 19:43 - louboutinwedges

rolex watches price in india lowestrolex cosmograph daytona everose gold replicareplica watches india online shopping
buy casio replica watches in india
new breitling emergency for sale
<ul><li><strong><a href="http://www.notarydmv.com/newindex">rolex watches price in india lowest</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<ul><li><strong><a href="http://www.notarydmv.com/newindex">rolex watches price in india lowest</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


louis vuitton christian louboutin prix
Fri 04 Aug 2017 19:43 - louboutinwedges

Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek
Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek

<strong><a href="http://www.philippepatekclock.top/it/news/">Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek </a></strong><br>
<strong><a href="http://www.philippepatekclock.top/it/news/">Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek </a></strong><br>
<br>
<strong><a href="http://www.philippepatekclock.top/it/news/">Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek </a></strong><br>
<strong><a href="http://www.philippepatekclock.top/it/news/">Orologi da uomo Replica Patek Replica Patek Ladies 'Orologi Replica Patek orologi da tasca Professionale Patek Philippe Orologi da uomo Replica Patek </a></strong><br>
<br>


rolex cosmograph daytona everose gold replica
Fri 04 Aug 2017 19:43 - louboutinwedges

rolex cosmograph daytona everose gold replica | rolex cosmograph daytona everose gold replica | replica watches india online shopping
<a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a>
<a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a>
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


orologi da tasca Professionale Patek Philippe copia patek
Fri 04 Aug 2017 19:43 - louboutinwedges

<a href="http://www.patekphilippeprice.top/it/news/"> orologi da tasca Professionale Patek Philippe copia patek uomini orologi </a> | copia patek uomini orologi copia patek | signore di orologi copia patek
<strong><a href="http://www.patekphilippeprice.top/it/news/"> orologi da tasca Professionale Patek Philippe copia patek uomini orologi </a></strong> | <strong><a href="http://www.patekphilippeprice.top/it/news/">copia patek uomini orologi copia patek</a></strong> | <strong><a href="http://www.patekphilippeprice.top/it/news/"> signore di orologi copia patek</a></strong><br>
<strong><a href="http://www.patekphilippeprice.top/it/news/"> orologi da tasca Professionale Patek Philippe copia patek uomini orologi </a></strong> | <strong><a href="http://www.patekphilippeprice.top/it/news/">copia patek uomini orologi copia patek</a></strong> | <strong><a href="http://www.patekphilippeprice.top/it/news/"> signore di orologi copia patek</a></strong><br>


louis vuitton christian louboutin prix
Fri 04 Aug 2017 19:43 - louboutinwedges

<a href="http://www.choudoufudaily.com/newindex">luxury replica watches south africa</a>luxury replica watches south africarolex
watches online cheap rate
breitling chronomat 44 gmt ab0420
<ul><li><strong><a href="http://www.choudoufudaily.com/newindex">luxury replica watches south africa</a></strong></li><li><strong><a href="http://www.choudoufudaily.com/newindex">luxury replica watches south africa</a></strong></li><li><strong><a href="http://www.choudoufudaily.com/newindex">rolex</a></strong></li></ul><br>
<ul><li><strong><a href="http://www.choudoufudaily.com/newindex">luxury replica watches south africa</a></strong></li><li><strong><a href="http://www.choudoufudaily.com/newindex">luxury replica watches south africa</a></strong></li><li><strong><a href="http://www.choudoufudaily.com/newindex">rolex</a></strong></li></ul><br>
<strong><a href="http://www.choudoufudaily.com/newindex">watches online cheap rate</a></strong><br>
<strong><a href="http://www.choudoufudaily.com/newindex">breitling chronomat 44 gmt ab0420</a></strong><br>


Kopio omega kellot
Fri 04 Aug 2017 19:43 - louboutinwedges

relojes Omegala réplica de relojes relojes rolex
<ul><li><strong><a href="http://www.rolexoutlet.top/es/news/"> relojes Omega</a></strong></li><li><strong><a href="http://www.rolexoutlet.top/es/news/">la réplica de relojes</a></strong></li><li><strong><a href="http://www.rolexoutlet.top/es/news/"> relojes rolex</a></strong></li></ul><br>
<ul><li><strong><a href="http://www.rolexoutlet.top/es/news/"> relojes Omega</a></strong></li><li><strong><a href="http://www.rolexoutlet.top/es/news/">la réplica de relojes</a></strong></li><li><strong><a href="http://www.rolexoutlet.top/es/news/"> relojes rolex</a></strong></li></ul><br>


Rolex montres pour les hommes
Fri 04 Aug 2017 19:43 - louboutinwedges

moncler vestes | Moncler manteaux | moncler vestes
<strong><a href="http://www.monclerhomme.top/fr/news/"> moncler vestes</a></strong> | <strong><a href="http://www.monclerhomme.top/fr/news/">Moncler manteaux</a></strong> | <strong><a href="http://www.monclerhomme.top/fr/news/"> moncler vestes</a></strong><br>
<strong><a href="http://www.monclerhomme.top/fr/news/"> moncler vestes</a></strong> | <strong><a href="http://www.monclerhomme.top/fr/news/">Moncler manteaux</a></strong> | <strong><a href="http://www.monclerhomme.top/fr/news/"> moncler vestes</a></strong><br>


rolex cosmograph daytona everose gold replica
Fri 04 Aug 2017 20:15 - louboutinwedges

rolex cosmograph daytona everose gold replica | rolex cosmograph daytona everose gold replica | replica watches india online shopping
buy casio replica watches in india
new breitling emergency for sale
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong> | <strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


billiga rolex klockor
Fri 04 Aug 2017 20:15 - louboutinwedges

rolex watches price in india lowest
rolex cosmograph daytona everose gold replica
<a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a>

buy casio replica watches in india
new breitling emergency for sale
<strong><a href="http://www.notarydmv.com/newindex">rolex watches price in india lowest</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<br>
<strong><a href="http://www.notarydmv.com/newindex">rolex watches price in india lowest</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong><br>
<br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


breitling watches replica uk
Fri 04 Aug 2017 20:15 - louboutinwedges

<a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a>replica watches india online shopping
<a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a>
new breitling emergency for sale
<ul><li><strong><a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<ul><li><strong><a href="http://www.notarydmv.com/newindex">breitling watches replica uk</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


Los granos de cristal de Pandora
Fri 04 Aug 2017 20:16 - louboutinwedges

Los granos de cristal de Pandora | <a href="http://www.braceletpandorajewelry.top/es/news/">
Los granos de cristal de Pandora
</a>

<strong><a href="http://www.braceletpandorajewelry.top/es/news/">
Los granos de cristal de Pandora
</a></strong> | <strong><a href="http://www.braceletpandorajewelry.top/es/news/">
Los granos de cristal de Pandora
</a></strong><br>
<strong><a href="http://www.braceletpandorajewelry.top/es/news/">
Los granos de cristal de Pandora
</a></strong> | <strong><a href="http://www.braceletpandorajewelry.top/es/news/">
Los granos de cristal de Pandora
</a></strong><br>


old fashioned mens watches
Fri 04 Aug 2017 20:16 - louboutinwedges

<a href="https://www.txdecor.com/newindex">omega watches uk forum</a> | omega watches uk forum | breitling superocean heritage chronograph 44
michael kors watches mens uk sale
breitling bentley barnato 42
<strong><a href="https://www.txdecor.com/newindex">omega watches uk forum</a></strong> | <strong><a href="https://www.txdecor.com/newindex">omega watches uk forum</a></strong> | <strong><a href="https://www.txdecor.com/newindex">breitling superocean heritage chronograph 44</a></strong><br>
<strong><a href="https://www.txdecor.com/newindex">omega watches uk forum</a></strong> | <strong><a href="https://www.txdecor.com/newindex">omega watches uk forum</a></strong> | <strong><a href="https://www.txdecor.com/newindex">breitling superocean heritage chronograph 44</a></strong><br>
<strong><a href="https://www.txdecor.com/newindex">michael kors watches mens uk sale</a></strong><br>
<strong><a href="https://www.txdecor.com/newindex">breitling bentley barnato 42</a></strong><br>


sitio web de Michael Kors
Fri 04 Aug 2017 20:16 - louboutinwedges

sitio web de Michael Kors
Michael Kors
Michael Kors Outlet

<strong><a href="http://www.michaelkors2u.cn/es/news/"> sitio web de Michael Kors</a></strong><br>
<strong><a href="http://www.michaelkors2u.cn/es/news/">Michael Kors </a></strong><br>
<strong><a href="http://www.michaelkors2u.cn/es/news/"> Michael Kors Outlet </a></strong><br>
<br>
<strong><a href="http://www.michaelkors2u.cn/es/news/"> sitio web de Michael Kors</a></strong><br>
<strong><a href="http://www.michaelkors2u.cn/es/news/">Michael Kors </a></strong><br>
<strong><a href="http://www.michaelkors2u.cn/es/news/"> Michael Kors Outlet </a></strong><br>
<br>


christian louboutin burlesque shoes for sale
Fri 04 Aug 2017 20:16 - louboutinwedges

Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre
Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre

<strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong><br>
<strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong><br>
<br>
<strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong><br>
<strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong><br>
<br>


replica rolex montres
Fri 04 Aug 2017 20:16 - louboutinwedges

replica rolex montres
rolex replica
replica rolex montres

montres rolex
montres rolex pas cher
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> replica rolex montres</a></strong><br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/">rolex replica</a></strong><br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> replica rolex montres</a></strong><br>
<br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> replica rolex montres</a></strong><br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/">rolex replica</a></strong><br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> replica rolex montres</a></strong><br>
<br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> montres rolex</a></strong><br>
<strong><a href="http://www.datejustrolexwatches.top/fr/news/"> montres rolex pas cher</a></strong><br>


rolex cosmograph daytona everose gold replica
Fri 04 Aug 2017 20:16 - louboutinwedges

rolex cosmograph daytona everose gold replicarolex cosmograph daytona everose gold replicareplica watches india online shopping
<a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a>
new breitling emergency for sale
<ul><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<ul><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">rolex cosmograph daytona everose gold replica</a></strong></li><li><strong><a href="http://www.notarydmv.com/newindex">replica watches india online shopping</a></strong></li></ul><br>
<strong><a href="http://www.notarydmv.com/newindex">buy casio replica watches in india</a></strong><br>
<strong><a href="http://www.notarydmv.com/newindex">new breitling emergency for sale</a></strong><br>


Replica Relojes Patek Hombre Replica Patek Ladies 'Relo
Fri 04 Aug 2017 20:17 - louboutinwedges

Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre <a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a>
<ul><li><strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong></li><li><strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong></li></ul><br>
<ul><li><strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong></li><li><strong><a href="http://www.fakepatekphilipewatches.top/es/news/">Replica Relojes Patek Hombre Replica Patek Ladies 'Relojes Relojes de bolsillo Replica Patek Profesional patek Philippe Replica Relojes Patek Hombre </a></strong></li></ul><br>


Postez un commentaire !
Vous devez être inscrit(e) et connecté(e) pour ajouter un article !