{"id":1290,"date":"2018-12-10T21:22:56","date_gmt":"2018-12-10T20:22:56","guid":{"rendered":"https:\/\/www.websupport.sk\/podpora\/?post_type=ht_kb&p=1290"},"modified":"2024-01-30T17:12:58","modified_gmt":"2024-01-30T16:12:58","slug":"import-databaz-vacsich-ako-256-mb","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/","title":{"rendered":"Import datab\u00e1z"},"content":{"rendered":"\n

Pri importovan\u00ed datab\u00e1z sa textov\u00fd s\u00fabor s in\u0161trukciami na vytvorenie tabuliek a v\u0161etk\u00fdmi \u00fadajmi (zvy\u010dajne s pr\u00edpomou .SQL) nahr\u00e1 do inej datab\u00e1zy. Podobne ako pri in\u00fdch oper\u00e1ci\u00e1ch s SQL, aj tu je dobr\u00fdm pomocn\u00edkom rozhranie PhpMyAdmin.<\/p>\n\n\n\n

    \n
  1. Prihl\u00e1ste sa do PhpMyAdmin<\/strong>*.<\/li>\n\n\n\n
  2. V \u013eavom menu, hne\u010f pod ikonami, vyberte po\u017eadovan\u00fa datab\u00e1zu.<\/li>\n\n\n\n
  3. Kliknite na ikonu SQL<\/strong> v \u013eavej \u010dasti obrazovky a vyberte z\u00e1lo\u017eku Importova\u0165 s\u00fabory.<\/strong><\/li>\n\n\n\n
  4. Vyberte SQL-s\u00fabor, ktor\u00fd chcete importova\u0165.<\/li>\n\n\n\n
  5. Dokon\u010dite kliknut\u00edm na tla\u010didlo Vykonaj.<\/strong><\/li>\n<\/ol>\n\n\n\n

    * adresy k prihl\u00e1seniu do PhpMyadmin <\/em><\/p>\n\n\n\n

    https:\/\/db101.websupport.sk\/<\/a>  (MariaDB10.1)<\/p>\n\n\n\n

    https:\/\/db55.websupport.sk\/<\/a> (MariaDB5.5)<\/p>\n\n\n\n

    https:\/\/db57.websupport.sk\/<\/a> (MySQL5.7)<\/p>\n\n\n\n

    https:\/\/db51.websupport.sk\/<\/a> (MySQL5.1)<\/p>\n\n\n\n

    https:\/\/dbpg.websupport.sk\/<\/a> (PostreSQL9.0 a 10.0)<\/p>\n\n\n\n

    https:\/\/db103.websupport.sk\/<\/a> (MariaDB10.3)<\/p>\n\n\n\n

    h<\/a>ttps:\/\/db80.websupport.sk\/<\/a> (MySQL8.0)<\/p>\n\n\n\n

    <\/p>\n\n\n\n

    Import datab\u00e1z v\u00e4\u010d\u0161\u00edch ako 256 MB<\/h2>\n\n\n\n

    Pokia\u013e potrebujete importova\u0165 datab\u00e1zu, ktorej ve\u013ekos\u0165 presahuje 256 MB<\/strong>, v rozhran\u00ed phpMyAdmin naraz\u00edte na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru (n\u00e1vod na import men\u0161\u00edch DB n\u00e1jdete tu<\/a>). V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme ako prekona\u0165 spom\u00ednan\u00e9 obmedzenie, \u010di u\u017e pre pou\u017e\u00edvate\u013eov opera\u010dn\u00fdch syst\u00e9mov Windows alebo Linux.<\/p>\n\n\n

    Windows<\/strong><\/h3>\n\n\n

    Budete potrebova\u0165 MySQL klienta, v ktorom nastav\u00edte pripojenie k datab\u00e1zov\u00e9mu serveru a vykon\u00e1te samotn\u00fd import. Pre jednoduch\u00e9 \u00falohy \u00faplne posta\u010d\u00ed freeware program HeidiSQL,<\/em> ktor\u00e9ho aktu\u00e1lnu verziu m\u00f4\u017eete z\u00edska\u0165 tu<\/a>. <\/p>\n\n\n\n

    \n\n\n\n

    Po \u00faspe\u0161nej in\u0161tal\u00e1cii je potrebn\u00e9 nastavi\u0165 spojenie s datab\u00e1zov\u00fdm serverom<\/strong>. <\/p>\n\n\n\n

      \n
    • V\u0161etky potrebn\u00e9 \u00fadaje n\u00e1jdete vo Webadmine<\/em> v sekcii Datab\u00e1zy<\/em>, pre konkr\u00e9tny hosting. <\/li>\n\n\n\n
    • V na\u0161om pr\u00edklade sa pripoj\u00edme ku datab\u00e1ze s n\u00e1zvom velka_db<\/em> a pou\u017e\u00edvate\u013eom velka_db_user<\/em>, ktor\u00e1 je verzie MariaDB 5.5 (a teda pou\u017eijeme port 3310). <\/li>\n\n\n\n
    • Po spusten\u00ed HeidiSQL kliknite na New <\/em>\u2192 Session in root folder,<\/em> zadajte \u00fadaje pre pripojenie k DB a zvo\u013ete Open<\/em>:<\/li>\n<\/ul>\n\n\n\n
      \"\"<\/figure>\n\n\n\n

      V otvorenom okne vid\u00edte datab\u00e1zu a jej tabu\u013eky, ak nejak\u00e9 existuj\u00fa:<\/p>\n\n\n\n

      \"\"<\/figure>\n\n\n\n
        \n
      • Stla\u010dte File <\/em>\u2192 Load SQL File <\/em>alebo kl\u00e1vesov\u00fa skratku Ctrl + O <\/em>a vyberte SQL s\u00fabor ktor\u00fd chcete importova\u0165. <\/li>\n\n\n\n
      • V okne ktor\u00e9 sa zobraz\u00ed po zvolen\u00ed s\u00faboru kliknite na Run file(s) directly<\/em> a sledujte ako prebieha import na na\u0161e servery:<\/li>\n<\/ul>\n\n\n\n
        \n\n\n\n

        Debian\/Ubuntu Linux<\/strong><\/h3>\n\n\n\n

        V pr\u00edpade Linuxu je mo\u017en\u00e9 spusti\u0165 spom\u00ednan\u00fd HeidiSQL v prostred\u00ed Wine a postupova\u0165 pod\u013ea vy\u0161\u0161ie uveden\u00fdch krokov. Efekt\u00edvnej\u0161ie (a efektnej\u0161ie) je v\u0161ak pou\u017ei\u0165 konzolov\u00e9ho klienta priamo od MySQL, ktor\u00e9ho po spusten\u00ed termin\u00e1lu nain\u0161talujete pr\u00edkazom:<\/p>\n\n\n\n

        sudo apt-get install mysql-client-5.5<\/em><\/p>\n\n\n\n

        Syntax pre import je nasledovn\u00e1:<\/p>\n\n\n\n

        mysql -h adresa.db.servera<\/strong> -P port<\/strong> -p -u pouzivatel_db<\/strong> nazov_db<\/strong> < \/cesta\/ku\/sql\/suboru.sql<\/strong><\/em><\/p>\n\n\n\n

        V na\u0161om pr\u00edklade by sme teda pou\u017eili pr\u00edkaz:<\/p>\n\n\n\n

        mysql -h <\/em>mariadb55.websupport.sk<\/strong> -P <\/em>3310<\/strong> -p -u <\/em>velka_db_user<\/strong>velka_db<\/strong> < <\/em>dbzaloha.sql<\/strong><\/p>\n\n\n\n

        Po zadan\u00ed hesla ku datab\u00e1ze sa za\u010dne import a ak\u00e9ko\u013evek chyby bud\u00fa vyp\u00edsan\u00e9 do konzoly. Po jeho dokon\u010den\u00ed m\u00f4\u017eete skontrolova\u0165 obsah datab\u00e1zy bu\u010f cez konzolov\u00e9ho klienta alebo pomocou phpMyAdmina.<\/p>\n\n\n\n

        <\/p>\n\n\n\n

        Import PSQL datab\u00e1zy v Debian\/Ubuntu Linux<\/strong><\/p>\n\n\n\n

        psql -U <db_user> <db_name> -W <password> -h postgresql.websupport.sk -P 5432 < dump.sql<\/p>\n\n\n\n

        Datab\u00e1zov\u00fd server a port si viete zmeni\u0165 pod\u013ea inform\u00e1cie V\u00e1\u0161ho webadminu v sekcii datab\u00e1zy po rozkliknut\u00ed konkr\u00e9tnej datab\u00e1zy a zmeni\u0165 si potrebn\u00e9 \u00fadaje na Va\u0161u datab\u00e1zu.<\/p>\n","protected":false},"excerpt":{"rendered":"

        Pri importovan\u00ed datab\u00e1z sa textov\u00fd s\u00fabor s in\u0161trukciami na vytvorenie tabuliek a v\u0161etk\u00fdmi \u00fadajmi (zvy\u010dajne s pr\u00edpomou .SQL) nahr\u00e1 do inej datab\u00e1zy. Podobne ako pri in\u00fdch oper\u00e1ci\u00e1ch s SQL, aj tu je dobr\u00fdm pomocn\u00edkom rozhranie PhpMyAdmin. * adresy k prihl\u00e1seniu do PhpMyadmin  https:\/\/db101.websupport.sk\/  (MariaDB10.1) https:\/\/db55.websupport.sk\/ (MariaDB5.5) https:\/\/db57.websupport.sk\/ (MySQL5.7) https:\/\/db51.websupport.sk\/ (MySQL5.1) https:\/\/dbpg.websupport.sk\/ (PostreSQL9.0 a 10.0) https:\/\/db103.websupport.sk\/ (MariaDB10.3) https:\/\/db80.websupport.sk\/ (MySQL8.0)…<\/p>\n","protected":false},"author":29,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[41],"ht-kb-tag":[],"class_list":["post-1290","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databazy"],"yoast_head":"\nImport datab\u00e1z - Websupport centrum podpory<\/title>\n<meta name=\"description\" content=\"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/\" \/>\n<meta property=\"og:locale\" content=\"sk_SK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import datab\u00e1z - Websupport centrum podpory\" \/>\n<meta property=\"og:description\" content=\"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport centrum podpory\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-30T16:12:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Predpokladan\u00fd \u010das \u010d\u00edtania\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 min\u00faty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/\",\"name\":\"Import datab\u00e1z - Websupport centrum podpory\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/app\\\/uploads\\\/sites\\\/2\\\/2018\\\/12\\\/1.png\",\"datePublished\":\"2018-12-10T20:22:56+00:00\",\"dateModified\":\"2024-01-30T16:12:58+00:00\",\"description\":\"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/#breadcrumb\"},\"inLanguage\":\"sk-SK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sk-SK\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/app\\\/uploads\\\/sites\\\/2\\\/2018\\\/12\\\/1.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/app\\\/uploads\\\/sites\\\/2\\\/2018\\\/12\\\/1.png\",\"width\":888,\"height\":589},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/kb\\\/import-databaz-vacsich-ako-256-mb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import datab\u00e1z\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/\",\"name\":\"Websupport centrum podpory\",\"description\":\"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.sk\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sk-SK\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import datab\u00e1z - Websupport centrum podpory","description":"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/","og_locale":"sk_SK","og_type":"article","og_title":"Import datab\u00e1z - Websupport centrum podpory","og_description":"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.","og_url":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/","og_site_name":"Websupport centrum podpory","article_modified_time":"2024-01-30T16:12:58+00:00","og_image":[{"url":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Predpokladan\u00fd \u010das \u010d\u00edtania":"3 min\u00faty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/","url":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/","name":"Import datab\u00e1z - Websupport centrum podpory","isPartOf":{"@id":"https:\/\/www.websupport.sk\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/1.png","datePublished":"2018-12-10T20:22:56+00:00","dateModified":"2024-01-30T16:12:58+00:00","description":"Pre import datab\u00e1zy presahuj\u00facej 96 MB naraz\u00edte v phpMyAdmin na limit stanoven\u00fd maxim\u00e1lnou ve\u013ekos\u0165ou uploadovan\u00e9ho s\u00faboru. Vysporiadame sa s nim v n\u00e1vode.","breadcrumb":{"@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/#breadcrumb"},"inLanguage":"sk-SK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/"]}]},{"@type":"ImageObject","inLanguage":"sk-SK","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/#primaryimage","url":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/1.png","contentUrl":"https:\/\/www.websupport.sk\/podpora\/app\/uploads\/sites\/2\/2018\/12\/1.png","width":888,"height":589},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.sk\/podpora\/kb\/import-databaz-vacsich-ako-256-mb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.sk\/podpora\/"},{"@type":"ListItem","position":2,"name":"Import datab\u00e1z"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.sk\/podpora\/#website","url":"https:\/\/www.websupport.sk\/podpora\/","name":"Websupport centrum podpory","description":"Radi v\u00e1m pom\u00f4\u017eeme s va\u0161im probl\u00e9mom","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.sk\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sk-SK"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/users\/29"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1290\/revisions"}],"predecessor-version":[{"id":26603,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb\/1290\/revisions\/26603"}],"wp:attachment":[{"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/media?parent=1290"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=1290"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.sk\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}