{"id":3513,"date":"2019-03-18T08:10:30","date_gmt":"2019-03-18T08:10:30","guid":{"rendered":"https:\/\/www.domenca.com\/podpora\/?post_type=kb&#038;p=3513"},"modified":"2019-03-18T10:55:29","modified_gmt":"2019-03-18T10:55:29","slug":"uvoz-velike-mysql-baze-na-streznik","status":"publish","type":"kb","link":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/","title":{"rendered":"Uvoz velike MySQL baze na stre\u017enik"},"content":{"rendered":"<span class=\"mkb-shortcode-container\">\t\t<div class=\"mkb-warning\">\n\t\t\t<div class=\"mkb-warning__icon\">\n\t\t\t\t<i class=\"fa fa-exclamation-triangle fa-lg\"><\/i>\n\t\t\t<\/div>\n\t\t\t<div class=\"mkb-warning__content\">\n\t\t\t\tPred uvozom predlagamo, da si ustvarite varnostno kopijo podatkovne baze.\t\t\t<\/div>\n\t\t<\/div>\n\t<\/span>\n<div><\/div>\n<p>Uvoz MySQL podatkovne baze, ki vsebuje ogromno podatkov, preko aplikacije phpMyAdmin ne bo mogo\u010d, saj so na stre\u017enikih nastavljene \u010dasovne omejitve izvajanja PHP skript. Ve\u010d o tehni\u010dnih zna\u010dilnostih si lahko ogledate na <a class=\"theme markdown__link\" href=\"https:\/\/www.domenca.com\/podpora\/kb\/tehnicne-znacilnosti-cpanel-gostovanj-pri-nas\/\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/www.domenca.com\/podpora\/kb\/tehnicne-znacilnosti-cpanel-gostovanj-pri-nas\/<\/a>.<\/p>\n<p>V tem primeru lahko SQL datoteko uvozite preko aplikacije <span class=\"highlightme\">Terminal<\/span>, ki je na voljo v cPanel nadzorni plo\u0161\u010di ali pa preko <a href=\"https:\/\/www.domovanje.com\/podpora\/kb\/dostop-do-ukazne-vrstice-prek-ssh\/\" target=\"_blank\" rel=\"noopener\">SSH protokola<\/a>.<\/p>\n<p>Najprej je potrebno SQL datoteko nalo\u017eiti na va\u0161 paket gostovanja. Datoteko nalo\u017eite z uporabo aplikacije <span class=\"highlightme\">File manager<\/span> v cPanel nadzorni plo\u0161\u010di ali pa preko FTP protokola.<br \/>\nDatoteko lahko nalo\u017eite v poljuben direktorij, sicer pa priporo\u010damo kar \u201croot\u201d direktorij va\u0161ega paketa gostovanja.<\/p>\n<p>V cPanel nadzorni plo\u0161\u010di v razdelku &#8220;Advanced&#8221; kliknite na ikono <span class=\"highlightme\">Terminal<\/span>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-3514\" src=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-1024x149.png\" alt=\"\" width=\"640\" height=\"93\" srcset=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-1024x149.png 1024w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-300x44.png 300w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-768x111.png 768w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1.png 1378w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>Preden lahko dostopate do aplikacije Terminal, morate prebrati in sprejeti opozorilo. Kliknite gumb \u201c<span class=\"highlightme\">I understand and want to proceed<\/span>\u201c.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3413\" src=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/01\/memory_limit_wp_2.jpg\" alt=\"\" width=\"844\" height=\"297\" srcset=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/01\/memory_limit_wp_2.jpg 844w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/01\/memory_limit_wp_2-300x106.jpg 300w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/01\/memory_limit_wp_2-768x270.jpg 768w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/><\/p>\n<p>Za uvoz datoteke lahko uporabimo spodnji ukaz, kjer namesto \u201cUSERNAME\u201d vpi\u0161emo uporabnika, ki ima dostop do MySQL podatkovne baze. Namesto \u201cDATABASE\u201d vpi\u0161emo ime MySQL baze, v katero \u017eelimo uvoziti podatke. Datoteka \u201cbaza.sql\u201d pa je datoteka, ki smo jo nalo\u017eili v \u201croot\u201d direktorij paketa gostovanja.<\/p>\n<p><span class=\"highlightme\">mysql -u <em>USERNAME<\/em> -p <em>DATABASE<\/em> &lt; <em>baza<\/em>.sql<\/span><\/p>\n<p>Ob vnosu in potrditvi ukaza je potrebno le \u0161e vnesti geslo od uporabnika, ki ste ga zapisali v zgornjem ukazu (uporabnik mora biti dodeljen vpisani MySQL podatkovni bazi).<br \/>\n\u010cas trajanja uvoza je odvisen od velikost podatkovne baze, ki jo \u017eelite uvoziti. Po uspe\u0161nem uvozu sicer ne boste prejeli nobenega obvestila, vendar vas bo le vrnilo nazaj na mo\u017enost vpisa novega ukaza.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3515\" src=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza2.png\" alt=\"\" width=\"863\" height=\"581\" srcset=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza2.png 863w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza2-300x202.png 300w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza2-768x517.png 768w\" sizes=\"auto, (max-width: 863px) 100vw, 863px\" \/><\/p>\n<p>Uspe\u0161nost uvoza lahko nato preverite v aplikciji phpMyAdmin v nadzorni plo\u0161\u010di cPanel.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3516\" src=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza3-1024x395.png\" alt=\"\" width=\"704\" height=\"272\" srcset=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza3-1024x395.png 1024w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza3-300x116.png 300w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza3-768x297.png 768w, https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza3.png 1567w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/p>\n<span class=\"mkb-shortcode-container\">\t\t<div class=\"mkb-info\">\n\t\t\t<div class=\"mkb-info__icon\">\n\t\t\t\t<i class=\"fa fa-info-circle fa-lg\"><\/i>\n\t\t\t<\/div>\n\t\t\t<div class=\"mkb-info__content\">\n\t\t\t\tKo kon\u010date s postopkom uvoza MySQL baze, nalo\u017eeno datoteko odstranite s stre\u017enika.\t\t\t<\/div>\n\t\t<\/div>\n\t<\/span>\n","protected":false},"excerpt":{"rendered":"<p>Uvoz MySQL podatkovne baze, ki vsebuje ogromno podatkov, preko aplikacije phpMyAdmin ne bo mogo\u010d, saj so na stre\u017enikih nastavljene \u010dasovne omejitve izvajanja PHP skript. Ve\u010d o tehni\u010dnih zna\u010dilnostih si lahko ogledate na https:\/\/www.domenca.com\/podpora\/kb\/tehnicne-znacilnosti-cpanel-gostovanj-pri-nas\/. V tem primeru lahko SQL datoteko uvozite preko aplikacije Terminal, ki je na voljo v cPanel nadzorni plo\u0161\u010di ali pa preko SSH [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[90],"kbtag":[],"class_list":["post-3513","kb","type-kb","status-publish","hentry","kbtopic-podatkovne-baze"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com<\/title>\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.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/\" \/>\n<meta property=\"og:locale\" content=\"sl_SI\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com\" \/>\n<meta property=\"og:description\" content=\"Uvoz MySQL podatkovne baze, ki vsebuje ogromno podatkov, preko aplikacije phpMyAdmin ne bo mogo\u010d, saj so na stre\u017enikih nastavljene \u010dasovne omejitve izvajanja PHP skript. Ve\u010d o tehni\u010dnih zna\u010dilnostih si lahko ogledate na https:\/\/www.domenca.com\/podpora\/kb\/tehnicne-znacilnosti-cpanel-gostovanj-pri-nas\/. V tem primeru lahko SQL datoteko uvozite preko aplikacije Terminal, ki je na voljo v cPanel nadzorni plo\u0161\u010di ali pa preko SSH [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/\" \/>\n<meta property=\"og:site_name\" content=\"Podpora domenca.com\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-18T10:55:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-1024x149.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/\",\"url\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/\",\"name\":\"Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/baza1-1024x149.png\",\"datePublished\":\"2019-03-18T08:10:30+00:00\",\"dateModified\":\"2019-03-18T10:55:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/#breadcrumb\"},\"inLanguage\":\"sl-SI\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sl-SI\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/baza1.png\",\"contentUrl\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/wp-content\\\/uploads\\\/2019\\\/03\\\/baza1.png\",\"width\":1378,\"height\":200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/kb\\\/uvoz-velike-mysql-baze-na-streznik\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uvoz velike MySQL baze na stre\u017enik\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/\",\"name\":\"Podpora domenca.com\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sl-SI\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#organization\",\"name\":\"Podpora domenca.com\",\"url\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sl-SI\",\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-dmc_podpora_2025.png\",\"contentUrl\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/cropped-dmc_podpora_2025.png\",\"width\":395,\"height\":82,\"caption\":\"Podpora domenca.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.domenca.com\\\/podpora\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com","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.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/","og_locale":"sl_SI","og_type":"article","og_title":"Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com","og_description":"Uvoz MySQL podatkovne baze, ki vsebuje ogromno podatkov, preko aplikacije phpMyAdmin ne bo mogo\u010d, saj so na stre\u017enikih nastavljene \u010dasovne omejitve izvajanja PHP skript. Ve\u010d o tehni\u010dnih zna\u010dilnostih si lahko ogledate na https:\/\/www.domenca.com\/podpora\/kb\/tehnicne-znacilnosti-cpanel-gostovanj-pri-nas\/. V tem primeru lahko SQL datoteko uvozite preko aplikacije Terminal, ki je na voljo v cPanel nadzorni plo\u0161\u010di ali pa preko SSH [&hellip;]","og_url":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/","og_site_name":"Podpora domenca.com","article_modified_time":"2019-03-18T10:55:29+00:00","og_image":[{"url":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-1024x149.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/","url":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/","name":"Uvoz velike MySQL baze na stre\u017enik - Podpora domenca.com","isPartOf":{"@id":"https:\/\/www.domenca.com\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/#primaryimage"},"image":{"@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/#primaryimage"},"thumbnailUrl":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1-1024x149.png","datePublished":"2019-03-18T08:10:30+00:00","dateModified":"2019-03-18T10:55:29+00:00","breadcrumb":{"@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/#breadcrumb"},"inLanguage":"sl-SI","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/"]}]},{"@type":"ImageObject","inLanguage":"sl-SI","@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/#primaryimage","url":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1.png","contentUrl":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2019\/03\/baza1.png","width":1378,"height":200},{"@type":"BreadcrumbList","@id":"https:\/\/www.domenca.com\/podpora\/kb\/uvoz-velike-mysql-baze-na-streznik\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.domenca.com\/podpora\/"},{"@type":"ListItem","position":2,"name":"Uvoz velike MySQL baze na stre\u017enik"}]},{"@type":"WebSite","@id":"https:\/\/www.domenca.com\/podpora\/#website","url":"https:\/\/www.domenca.com\/podpora\/","name":"Podpora domenca.com","description":"","publisher":{"@id":"https:\/\/www.domenca.com\/podpora\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.domenca.com\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sl-SI"},{"@type":"Organization","@id":"https:\/\/www.domenca.com\/podpora\/#organization","name":"Podpora domenca.com","url":"https:\/\/www.domenca.com\/podpora\/","logo":{"@type":"ImageObject","inLanguage":"sl-SI","@id":"https:\/\/www.domenca.com\/podpora\/#\/schema\/logo\/image\/","url":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2025\/03\/cropped-dmc_podpora_2025.png","contentUrl":"https:\/\/www.domenca.com\/podpora\/wp-content\/uploads\/2025\/03\/cropped-dmc_podpora_2025.png","width":395,"height":82,"caption":"Podpora domenca.com"},"image":{"@id":"https:\/\/www.domenca.com\/podpora\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kb\/3513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/comments?post=3513"}],"version-history":[{"count":5,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kb\/3513\/revisions"}],"predecessor-version":[{"id":3528,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kb\/3513\/revisions\/3528"}],"wp:attachment":[{"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/media?parent=3513"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kbtopic?post=3513"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.domenca.com\/podpora\/wp-json\/wp\/v2\/kbtag?post=3513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}