https://wiki.lesitadom.fr/index.php?action=history&feed=atom&title=BDD_-_Sauvegarde_et_restauration 2026-07-01T03:44:12Z Historique des versions pour cette page sur le wiki MediaWiki 1.43.1 https://wiki.lesitadom.fr/index.php?title=BDD_-_Sauvegarde_et_restauration&diff=369&oldid=prev 2022-04-10T17:07:51Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="fr"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Version précédente</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version du 10 avril 2022 à 17:07</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Ligne 1 :</td> <td colspan="2" class="diff-lineno">Ligne 1 :</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Sauvegarder une base complète</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Sauvegarder une base complète</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  ~# mysqldump -u utilisateur -p passwd -B base_de_données &gt; chemin/fichier_destination.sql</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  ~# <ins style="font-weight: bold; text-decoration: none;">'''</ins>mysqldump -u<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>utilisateur<ins style="font-weight: bold; text-decoration: none;">'' '''</ins>-p<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>passwd<ins style="font-weight: bold; text-decoration: none;">'' '''</ins>-B<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>base_de_données<ins style="font-weight: bold; text-decoration: none;">'' </ins>&gt; <ins style="font-weight: bold; text-decoration: none;">''</ins>chemin<ins style="font-weight: bold; text-decoration: none;">''</ins>/<ins style="font-weight: bold; text-decoration: none;">''</ins>fichier_destination<ins style="font-weight: bold; text-decoration: none;">''</ins>.sql</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Restaurer une base complète</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Restaurer une base complète</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  ~# mysql -u utilisateur -p passwd nom_de_la_base &lt; fichier_source.sql</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  ~# <ins style="font-weight: bold; text-decoration: none;">'''</ins>mysql -u<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>utilisateur<ins style="font-weight: bold; text-decoration: none;">'' '''</ins>-p<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>passwd<ins style="font-weight: bold; text-decoration: none;">'' ''</ins>nom_de_la_base<ins style="font-weight: bold; text-decoration: none;">'' </ins>&lt; <ins style="font-weight: bold; text-decoration: none;">''</ins>fichier_source<ins style="font-weight: bold; text-decoration: none;">''</ins>.sql</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Transfert de fichiers à travers ssh</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* Transfert de fichiers à travers ssh</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  ~# scp -r -p user@serveur1:chemin_vers_dossier_source user@serveur2:chemin_vers_dossier_destination</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  ~# <ins style="font-weight: bold; text-decoration: none;">'''</ins>scp -r -p<ins style="font-weight: bold; text-decoration: none;">''' ''</ins>user<ins style="font-weight: bold; text-decoration: none;">''</ins>@<ins style="font-weight: bold; text-decoration: none;">''</ins>serveur1<ins style="font-weight: bold; text-decoration: none;">''</ins>:<ins style="font-weight: bold; text-decoration: none;">''</ins>chemin_vers_dossier_source<ins style="font-weight: bold; text-decoration: none;">'' ''</ins>user<ins style="font-weight: bold; text-decoration: none;">''</ins>@<ins style="font-weight: bold; text-decoration: none;">''</ins>serveur2<ins style="font-weight: bold; text-decoration: none;">''</ins>:<ins style="font-weight: bold; text-decoration: none;">''</ins>chemin_vers_dossier_destination<ins style="font-weight: bold; text-decoration: none;">''</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>   </div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  -r : récursivité<del style="font-weight: bold; text-decoration: none;">\\</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  -r : récursivité</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  -p : préserve les dates de modification, d&#039;accès et le mode des fichiers</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  -p : préserve les dates de modification, d&#039;accès et le mode des fichiers</div></td></tr> <!-- diff cache key wiki-wiki:diff:1.41:old-368:rev-369:php=table --> </table>

Domi https://wiki.lesitadom.fr/index.php?title=BDD_-_Sauvegarde_et_restauration&diff=368&oldid=prev 2022-04-08T15:44:14Z

<p>Page créée avec « * Sauvegarder une base complète ~# mysqldump -u utilisateur -p passwd -B base_de_données &gt; chemin/fichier_destination.sql * Restaurer une base complète ~# mysql -u… »</p> <p><b>Nouvelle page</b></p><div>* Sauvegarder une base complète<br /> <br /> ~# mysqldump -u utilisateur -p passwd -B base_de_données &gt; chemin/fichier_destination.sql<br /> <br /> * Restaurer une base complète<br /> <br /> ~# mysql -u utilisateur -p passwd nom_de_la_base &lt; fichier_source.sql<br /> <br /> * Transfert de fichiers à travers ssh<br /> <br /> ~# scp -r -p user@serveur1:chemin_vers_dossier_source user@serveur2:chemin_vers_dossier_destination<br /> <br /> -r : récursivité\\<br /> -p : préserve les dates de modification, d&#039;accès et le mode des fichiers</div>

Domi