{"id":2089,"date":"2021-11-22T20:21:22","date_gmt":"2021-11-22T20:21:22","guid":{"rendered":"https:\/\/blog.hostinger.io\/fr\/support\/2021\/11\/22\/4664708-comment-exporter-une-base-de-donnees-par-ssh-sur-cpanel-chez-hostinger\/"},"modified":"2021-11-22T20:21:22","modified_gmt":"2021-11-22T20:21:22","slug":"4664708-comment-exporter-une-base-de-donnees-par-ssh-sur-cpanel-chez-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/fr\/support\/4664708-comment-exporter-une-base-de-donnees-par-ssh-sur-cpanel-chez-hostinger\/","title":{"rendered":"Comment Exporter une Base de Donn\u00e9es par SSH sur cPanel chez Hostinger"},"content":{"rendered":"<p class=\"no-margin\">Si <b><a href=\"https:\/\/support.hostinger.fr\/fr\/articles\/5074346-comment-exporter-une-base-de-donnees-phpmyadmin-sur-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">l&rsquo;exportation d&rsquo;une base de donn&eacute;es<\/a><\/b> via phpMyAdmin ne fonctionne pas, vous pouvez exporter votre base de donn&eacute;es en utilisant <b>SSH<\/b>. Voici les &eacute;tapes &agrave; suivre :<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_35501fcd95\">&Eacute;tape 1 &ndash; Pr&eacute;paration<\/h2><p class=\"no-margin\">Tout d&rsquo;abord, vous devez rassembler les param&egrave;tres de votre base de donn&eacute;es, y compris le mot de passe.<\/p><p class=\"no-margin\">\n<\/p><h2 id=\"h_13f54752b2\">&Eacute;tape 2 &ndash; Connexion<\/h2><ul>\n<li>\n<p class=\"no-margin\">Connectez-vous &agrave; votre <b><a href=\"https:\/\/support.hostinger.fr\/fr\/articles\/5076149-comment-se-connecter-a-mon-compte-cpanel-via-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">compte d&rsquo;h&eacute;bergement via SSH<\/a><\/b>.<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Assurez-vous que vous &ecirc;tes dans le <b>r&eacute;pertoire souhait&eacute;<\/b> (la base de donn&eacute;es sera export&eacute;e dans votre r&eacute;pertoire actuel). Pour naviguer entre les r&eacute;pertoires, utilisez les commandes <b>cd<\/b> et <b>ls<\/b>.<\/p>\n<\/li>\n<\/ul><h2 id=\"h_84909f5901\">&Eacute;tape 3 &ndash; Exporter<\/h2><p class=\"no-margin\">Utilisez cette commande pour <b>exporter la base de donn&eacute;es<\/b> :<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump -u database_username -p database_name &gt; file.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Si les <b>param&egrave;tres de votre base de donn&eacute;es<\/b> sont :<\/p><ul>\n<li>\n<p class=\"no-margin\">Nom de la base de donn&eacute;es MySQL : user_database<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Nom d&rsquo;utilisateur MySQL : user_admin<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Et vous souhaitez enregistrer la base de donn&eacute;es sous le nom de <b>backup.sql<\/b>, alors la commande ressemblera &agrave; ceci :<\/p><p class=\"no-margin\">\n<\/p><pre><code>mysqldump -u user_admin -p user_database &gt; backup.sql<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Apr&egrave;s cela, vous devrez <b>entrer le mot de passe de la base de donn&eacute;es<\/b> &ndash; le processus d&rsquo;exportation commencera. L&rsquo;exportation prendra un certain temps en fonction de la taille de votre base de donn&eacute;es. Lorsqu&rsquo;elle sera termin&eacute;e, une nouvelle ligne appara&icirc;tra :<\/p><p class=\"no-margin\">\n<\/p><pre><code>-bash-4.2$<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Cette ligne signifie que le processus d&rsquo;exportation est termin&eacute;, vous verrez votre fichier de base de donn&eacute;es appara&icirc;tre dans le gestionnaire de fichiers. &#128522;<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Voil&agrave;, c&rsquo;est fait ! Vous savez maintenant comment exporter votre base de donn&eacute;es MySQL.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTES :<\/b><\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.fr\/fr\/articles\/5066973-comment-importer-une-base-de-donnees-avec-phpmyadmin-sur-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Comment importer une base de donn&eacute;es avec phpMyAdmin sur cPanel ?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.fr\/fr\/articles\/5099597-comment-importer-une-base-de-donnees-par-ssh-sur-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Comment importer une base de donn&eacute;es par SSH sur cPanel ?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.fr\/fr\/articles\/5074346-comment-exporter-une-base-de-donnees-phpmyadmin-sur-cpanel\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Comment exporter une base de donn&eacute;es avec phpMyAdmin sur cPanel ?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Exportation d&rsquo;une base de donn\u00e9es par SSH en utilisant cPanel<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[170],"tags":[],"class_list":["post-2089","post","type-post","status-publish","format-standard","hentry","category-mysql"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4664708-how-to-export-a-database-over-ssh-on-cpanel-at-hostinger\/","default":1},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4664708-comment-exporter-une-base-de-donnees-par-ssh-sur-cpanel-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4664708-bagaimana-cara-mengekspor-database-melalui-ssh-di-cpanel-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4664708-como-faco-para-exportar-um-banco-de-dados-por-ssh-no-cpanel-hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/comments?post=2089"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/posts\/2089\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/media?parent=2089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/categories?post=2089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/fr\/support\/wp-json\/wp\/v2\/tags?post=2089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}