{"id":260,"date":"2023-07-03T09:14:34","date_gmt":"2023-07-03T09:14:34","guid":{"rendered":"https:\/\/blog.hostinger.io\/lt\/support\/2023\/07\/03\/4536306-kaip-importuoti-duomenu-baze-per-ssh-hostinger-platformoje\/"},"modified":"2023-07-03T09:14:34","modified_gmt":"2023-07-03T09:14:34","slug":"4536306-kaip-importuoti-duomenu-baze-per-ssh-hostinger-platformoje","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/lt\/support\/4536306-kaip-importuoti-duomenu-baze-per-ssh-hostinger-platformoje\/","title":{"rendered":"Kaip Importuoti Duomen\u0173 Baz\u0119 Per SSH Hostinger Platformoje?"},"content":{"rendered":"<p class=\"no-margin\">phpMyAdmin leid&#382;ia <b><a href=\"\/lt\/support\/1884149-kaip-importuoti-duomenu-baze-per-phpmyadmin\" target=\"_blank\" class=\"intercom-content-link\">importuoti duomen&#371; bazes<\/a><\/b> iki <b>256 MB<\/b> (kartais net &scaron;iek tiek ma&#382;esnio dyd&#382;io, jei duomen&#371; baz&#281; sudaro daug eilu&#269;i&#371;). Jei duomen&#371; baz&#279;s nepavyko importuoti naudojant phpMyAdmin, vietoj to galite naudoti <b>SSH<\/b>. Kaip tai padaryti, su&#382;inosite sekdami toliau nurodytais &#382;ingsniais.<\/p><p class=\"no-margin\">\n<\/p><h1 id=\"h_18c4d6b82d\">1 &#382;ingsnis. Pasiruo&scaron;imas<\/h1><ul>\n<li>\n<p class=\"no-margin\">&#302;kelkite duomen&#371; baz&#281; &#303; savo svetain&#279;s <b>public_html<\/b> aplank&#261;. Tai padarysite <b><a href=\"\/lt\/support\/1869164-kaip-ikelti-atsargine-kopija-naudojant-ftp\" target=\"_blank\" class=\"intercom-content-link\">per FTP<\/a><\/b> arba naudodami <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/1869114-how-to-upload-backup-with-file-manager\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Fail&#371; tvarkykl&#281;<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\"><b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/1583542-how-can-i-create-a-new-mysql-database\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">Sukurkite nauj&#261; duomen&#371; baz&#281;<\/a><\/b> arba <b><a href=\"https:\/\/support.hostinger.com\/en\/articles\/4536290-how-to-delete-all-database-tables-in-phpmyadmin\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">i&scaron;valykite t&#261;, &#303; kuri&#261; planuojate importuoti numatyt&#261; duomen&#371; baz&#281;<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">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>\n<\/li>\n<\/ul><h1 id=\"h_a3ddf9736b\">2 &#382;ingsnis. Prisijungimas per SSH<\/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\"><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\">Atidarykite pagrindin&#303; (angl. root) katalog&#261; (public_html)<\/a><\/b><\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Jei matote duomen&#371; baz&#279;s atsargin&#279;s kopijos fail&#261; &ndash; eikite prie kito &#382;ingsnio<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">Jei nematote atsargin&#279;s kopijos failo, eikite &#303; <b><a href=\"\/lt\/support\/4548688-pagrindiniai-veiksmai-failu-tvarkykleje\" target=\"_blank\" class=\"intercom-content-link\">Fail&#371; tvarkykl&#281;<\/a><\/b> ir dar kart&#261; patikrinkite, ar failas tikrai &#303;keltas ir patalpintas <b>public_html<\/b> aplanke<\/p>\n<\/li>\n<\/ul><h1 id=\"h_04a7825a97\">3 &#382;ingsnis. Duomen&#371; baz&#279;s importavimas<\/h1><p class=\"no-margin\">Jei duomen&#371; baz&#279; yra suglaudinto formato (<b>.sql.gz<\/b>), naudokite &scaron;i&#261; komand&#261;, kad j&#261; <b>i&scaron;skleistum&#279;te<\/b> &#303; .sql format&#261;:<\/p><pre><code>gzip -d database_name.gz.sql<\/code><\/pre><p class=\"no-margin\">Nepamir&scaron;kite pakeisti duomen&#371; baz&#279;s pavadinimo (<b>database_name<\/b>) tikruoju savo duomen&#371; baz&#279;s pavadinimu.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Nor&#279;dami <b>importuoti duomen&#371; baz&#281;<\/b>, naudokite &scaron;i&#261; komand&#261;:<\/p><pre><code>mysql -u database_username -p database_name &lt; file.sql<\/code><\/pre><p class=\"no-margin\">Jei j&#363;s&#371; duomen&#371; baz&#279;s parametrai 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>&#302;keltas duomen&#371; baz&#279;s failas<\/b>: database.sql<\/p>\n<\/li>\n<\/ul><p class=\"no-margin\">Tuomet komanda atrodys taip:<\/p><pre><code>mysql -u u123456789_admin -p u123456789_database &lt; database.sql<\/code><\/pre><p class=\"no-margin\">Po to &#303;veskite <b>duomen&#371; baz&#279;s slapta&#382;od&#303;<\/b> ir importavimo 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 importavimas gali &scaron;iek tiek u&#382;trukti.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Viskas! Dabar &#382;inote, kaip importuoti MySQL duomen&#371; baz&#281; per SSH &#128522;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 baz\u0117s importavimas per SSH naudojant hPanel valdymo skyd\u0105<\/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-260","post","type-post","status-publish","format-standard","hentry","category-duomenu-bazes-importavimas"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4536306-how-to-import-a-database-over-ssh-in-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4536306-como-importar-una-base-de-datos-por-ssh-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4536306-comment-importer-une-base-de-donnees-via-ssh-chez-hostinger\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4536306-bagaimana-cara-mengimpor-database-melalui-ssh-di-hostinger\/","default":0},{"locale":"lt-LT","link":"https:\/\/www.hostinger.com\/lt\/support\/4536306-kaip-importuoti-duomenu-baze-per-ssh-hostinger-platformoje\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4536306-como-importar-um-banco-de-dados-por-ssh-na-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4536306------ssh--hostinger\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/posts\/260","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=260"}],"version-history":[{"count":0,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/posts\/260\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/media?parent=260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/categories?post=260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/lt\/support\/wp-json\/wp\/v2\/tags?post=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}