{"id":259,"date":"2023-07-03T12:15:03","date_gmt":"2023-07-03T12:15:03","guid":{"rendered":"https:\/\/blog.hostinger.io\/lt\/support\/2023\/07\/03\/4536328-kaip-eksportuoti-duomenu-baze-per-ssh-hostinger-platformoje\/"},"modified":"2023-07-03T12:15:03","modified_gmt":"2023-07-03T12:15:03","slug":"4536328-kaip-eksportuoti-duomenu-baze-per-ssh-hostinger-platformoje","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/lt\/support\/4536328-kaip-eksportuoti-duomenu-baze-per-ssh-hostinger-platformoje\/","title":{"rendered":"Kaip Eksportuoti Duomen\u0173 Baz\u0119 Per SSH Hostinger Platformoje?"},"content":{"rendered":"<p class=\"no-margin\">Jei duomen&#371; baz&#279;s nepavyko <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/4529011-how-to-export-a-phpmyadmin-database\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">eksportuoti per phpMyAdmin<\/a><\/b>, pabandykite tai padaryti naudodami SSH. Nor&#279;dami su&#382;inoti, kaip tai padaryti, sekite &#382;emiau nurodytais &#382;ingsniais.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_c386cd338b\">1 &#382;ingsnis. Pasiruo&scaron;imas<\/h1><p class=\"no-margin\">Pirmiausia turite surinkti duomen&#371; baz&#279;s parametrus, &#303;skaitant ir slapta&#382;od&#303;. Jei nesate tikri d&#279;l savo duomen&#371; baz&#279;s slapta&#382;od&#382;io, <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/1583522-how-can-i-recover-mysql-password\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">pakeiskite j&#303;<\/a><\/b>.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_bfa8b35e51\">2 &#382;ingsnis. Prisijungimas<\/h1><ul>\n<li>\n<p class=\"no-margin\">Prisijunkite prie savo <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/1583245-how-can-i-log-in-to-my-account-via-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">hostingo paskyros per SSH<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Atidarykite <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/5973000-how-to-open-the-website-s-root-directory-via-ssh\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">pagrindin&#303; (angl. root) katalog&#261; (public_html)<\/a><\/b><\/p>\n<\/li>\n<\/ul><h1 id=\"h_3b63ffeab0\">3 &#382;ingsnis. Eksportas<\/h1><p class=\"no-margin\">Nor&#279;dami <b>eksportuoti duomen&#371; baz&#281;<\/b>, naudokite &scaron;i&#261; komand&#261;:<\/p><pre><code>mysqldump -u database_username -p database_name &gt; file.sql<\/code><\/pre><p class=\"no-margin\">Jei j&#363;s&#371; <b>duomen&#371; baz&#279;s parametrai<\/b> yra tokie:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b>MySQL duomen&#371; baz&#279;s pavadinimas<\/b>: u123456789_database<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>MySQL vartotojo vardas<\/b>: u123456789_admin<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b>Eksportuotos duomen&#371; baz&#279;s atsargin&#279;s kopijos failas<\/b>: backup.sql<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Tuomet komanda atrodys taip:<\/p><pre><code>mysqldump -u u123456789_admin -p u123456789_database &gt; backup.sql<\/code><\/pre><p class=\"no-margin\">Po to<b> &#303;veskite duomen&#371; baz&#279;s slapta&#382;od&#303; <\/b>ir eksportavimo procesas bus prad&#279;tas. <\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Kai viskas bus atlikta, pasirodys nauja eilut&#279;:<\/p><pre><code>-bash-4.2$<\/code><\/pre><p class=\"no-margin\">Tur&#279;kite omenyje, kad priklausomai nuo j&#363;s&#371; duomen&#371; baz&#279;s dyd&#382;io eksportavimas gali &scaron;iek tiek u&#382;trukti.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Viskas! Dabar &#382;inote, kaip eksportuoti MySQL duomen&#371; baz&#281; per SSH &#128522;<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>VERTA &#381;INOTI<\/b>:<\/p><ul>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/lt\/support\/1884149-kaip-importuoti-duomenu-baze-per-phpmyadmin\" target=\"_blank\" class=\"intercom-content-link\">Kaip importuoti duomen&#371; baz&#281; per phpMyAdmin?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"\/lt\/support\/4536306-kaip-importuoti-duomenu-baze-per-ssh\" target=\"_blank\" class=\"intercom-content-link\">Kaip importuoti duomen&#371; baz&#281; per SSH?<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/4529011-how-to-export-a-phpmyadmin-database\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Kaip eksportuoti duomen&#371; baz&#281; per phpMyAdmin?<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 baz\u0117s eksportavimas per SSH<\/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":[217],"tags":[],"class_list":["post-259","post","type-post","status-publish","format-standard","hentry","category-duomenu-bazes-importavimas"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4536328-how-to-export-a-database-over-ssh-in-hostinger\/","default":1},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4536328-bagaimana-cara-mengekspor-database-phpmyadmin-di-hostinger\/","default":0},{"locale":"lt-LT","link":"https:\/\/www.hostinger.com\/lt\/support\/4536328-kaip-eksportuoti-duomenu-baze-per-ssh-hostinger-platformoje\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4536328-como-faco-para-exportar-um-banco-de-dados-por-ssh-no-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4536328------ssh--hostinge\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/posts\/259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/comments?post=259"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/posts\/259\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/media?parent=259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/categories?post=259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/tags?post=259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}