{"id":513,"date":"2021-03-10T09:09:04","date_gmt":"2021-03-10T09:09:04","guid":{"rendered":"https:\/\/dev.sourcecode.sk\/wsczkb\/?post_type=ht_kb&#038;p=513"},"modified":"2021-07-19T15:38:53","modified_gmt":"2021-07-19T13:38:53","slug":"import-databazi-vetsich-nez-96-mb","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/","title":{"rendered":"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB"},"content":{"rendered":"\n<p>Pokud pot\u0159ebujete importovat datab\u00e1zi, jej\u00ed\u017e velikost\u00a0<strong>p\u0159esahuje 96 MB<\/strong>, v rozhran\u00ed phpMyAdmin naraz\u00edte na limit stanoven\u00fd maxim\u00e1ln\u00ed velikost\u00ed uploadovan\u00e9ho souboru (n\u00e1vod na import men\u0161\u00edch DB najdete\u00a0<a href=\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/\">zde<\/a>). V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme, jak p\u0159ekonat zm\u00edn\u011bn\u00e9 omezen\u00ed, a\u0165 u\u017e pro u\u017eivatele opera\u010dn\u00edch syst\u00e9m\u016f Windows nebo Linux.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Windows<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>Budete pot\u0159ebovat MySQL klienta, v kter\u00e9m nastav\u00edte p\u0159ipojen\u00ed k datab\u00e1zov\u00e9mu serveru a vykon\u00e1te samotn\u00fd import. Pro jednoduch\u00e9 \u00falohy \u00fapln\u011b posta\u010d\u00ed freeware program&nbsp;<em>HeidiSQL,<\/em>&nbsp;jeho\u017e aktu\u00e1ln\u00ed verzi m\u016f\u017eete z\u00edskat&nbsp;<a href=\"http:\/\/www.heidisql.com\/download.php\">zde<\/a>.&nbsp;<\/p>\n\n\n\n<p>Po \u00fasp\u011b\u0161n\u00e9 instalaci je pot\u0159ebn\u00e9 nastavit&nbsp;<strong>spojen\u00ed s datab\u00e1zov\u00fdm serverem<\/strong>.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>V\u0161echny pot\u0159ebn\u00e9 \u00fadaje najdete ve&nbsp;<em>Webadminu<\/em>&nbsp;v sekci&nbsp;<em>Datab\u00e1ze<\/em>, pro konkr\u00e9tn\u00ed hosting.&nbsp;<\/li><li>V na\u0161em p\u0159\u00edkladu se p\u0159ipoj\u00edme k datab\u00e1zi s n\u00e1zvem&nbsp;<em>velka_db<\/em>&nbsp;a u\u017eivatelem&nbsp;<em>velka_db_user<\/em>, kter\u00e1 je verz\u00ed MariaDB 5.5 (a tedy pou\u017eijeme port 3310).&nbsp;<\/li><li>Po spu\u0161t\u011bn\u00ed HeidiSQL klikn\u011bte na&nbsp;<em>New&nbsp;<\/em>\u2192<em>&nbsp;Session in root folder,<\/em>&nbsp;zadejte \u00fadaje pro p\u0159ipojen\u00ed k DB a zvolte&nbsp;<em>Open<\/em>:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png\" alt=\"\" class=\"wp-image-1291\"\/><\/figure>\n\n\n\n<p>V otev\u0159en\u00e9m okn\u011b vid\u00edte datab\u00e1zi a jej tabulky, pokud n\u011bjak\u00e9 existuj\u00ed:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/2.png\" alt=\"\" class=\"wp-image-1292\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Stla\u010dte&nbsp;<em>File&nbsp;<\/em>\u2192<em>&nbsp;Load SQL File&nbsp;<\/em>nebo kl\u00e1vesovou zkratku&nbsp;<em>Ctrl + O&nbsp;<\/em>a vyberte SQL soubor kter\u00fd chcete importovat.&nbsp;<\/li><li>V okn\u011b kter\u00e9 se zobraz\u00ed po zvolen\u00ed souboru klikn\u011bte na&nbsp;<em>Run file(s) directly<\/em>&nbsp;a sledujte jak prob\u00edh\u00e1 import na na\u0161e servery:<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Debian\/Ubuntu Linux<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>V p\u0159\u00edpad\u011b Linuxu je mo\u017en\u00e9 spustit zm\u00edn\u011bn\u00fd HeidiSQL v prost\u0159ed\u00ed Wine a postupovat podle v\u00fd\u0161e uveden\u00fdch krok\u016f. Efektivn\u011bj\u0161\u00ed (a efektn\u011bj\u0161\u00ed :)) je v\u0161ak pou\u017e\u00edt konzolov\u00e9ho klienta p\u0159\u00edmo od MySQL, kter\u00e9ho po spu\u0161t\u011bn\u00ed termin\u00e1lu nainstalujete p\u0159\u00edkazem:<\/p>\n\n\n\n<p><em>sudo apt-get install mysql-client-5.5<\/em><\/p>\n\n\n\n<p>Syntax pro import je n\u00e1sledovn\u00fd:<\/p>\n\n\n\n<p><em>mysql -h&nbsp;<strong>adresa.db.serveru<\/strong>&nbsp;-P&nbsp;<strong>port<\/strong>&nbsp;-p -u&nbsp;<strong>uzivatel_db<\/strong>&nbsp;<strong>nazov_db<\/strong>&nbsp;&lt;&nbsp;<strong>\/cesta\/k\/sql\/suboru.sql<\/strong><\/em><\/p>\n\n\n\n<p>V na\u0161em p\u0159\u00edkladu bychom tedy pou\u017eili p\u0159\u00edkaz:<\/p>\n\n\n\n<p><em>mysql -h&nbsp;<\/em><strong>mariadb55.websupport.sk<\/strong><em>&nbsp;-P&nbsp;<\/em><strong>3310<\/strong><em>&nbsp;-p -u&nbsp;<\/em><strong>velka_db_user<\/strong><strong>velka_db<\/strong><em>&nbsp;&lt;&nbsp;<\/em><strong>dbzaloha.sql<\/strong><\/p>\n\n\n\n<p>Po zadan\u00ed hesla ku datab\u00e1ze se za\u010dne import a jak\u00e9koliv chyby budou vypsan\u00e9 do konzole. Po jeho dokon\u010den\u00ed m\u016f\u017eete zkontrolovat obsah datab\u00e1ze bu\u010f p\u0159es konzolov\u00e9ho klienta nebo pomoc\u00ed phpMyAdmina.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pokud pot\u0159ebujete importovat datab\u00e1zi, jej\u00ed\u017e velikost\u00a0p\u0159esahuje 96 MB, v rozhran\u00ed phpMyAdmin naraz\u00edte na limit stanoven\u00fd maxim\u00e1ln\u00ed velikost\u00ed uploadovan\u00e9ho souboru (n\u00e1vod na import men\u0161\u00edch DB najdete\u00a0zde). V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme, jak p\u0159ekonat zm\u00edn\u011bn\u00e9 omezen\u00ed, a\u0165 u\u017e pro u\u017eivatele opera\u010dn\u00edch syst\u00e9m\u016f Windows nebo Linux. Windows Budete pot\u0159ebovat MySQL klienta, v kter\u00e9m&#8230;<\/p>\n","protected":false},"author":3,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[57],"ht-kb-tag":[],"class_list":["post-513","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaze"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy<\/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.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"Pokud pot\u0159ebujete importovat datab\u00e1zi, jej\u00ed\u017e velikost\u00a0p\u0159esahuje 96 MB, v rozhran\u00ed phpMyAdmin naraz\u00edte na limit stanoven\u00fd maxim\u00e1ln\u00ed velikost\u00ed uploadovan\u00e9ho souboru (n\u00e1vod na import men\u0161\u00edch DB najdete\u00a0zde). V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme, jak p\u0159ekonat zm\u00edn\u011bn\u00e9 omezen\u00ed, a\u0165 u\u017e pro u\u017eivatele opera\u010dn\u00edch syst\u00e9m\u016f Windows nebo Linux. Windows Budete pot\u0159ebovat MySQL klienta, v kter\u00e9m...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-19T13:38:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Odhadovan\u00e1 doba \u010dten\u00ed\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/\",\"name\":\"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/1.png\",\"datePublished\":\"2021-03-10T09:09:04+00:00\",\"dateModified\":\"2021-07-19T13:38:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/1.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.sk\\\/support\\\/app\\\/uploads\\\/2018\\\/12\\\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/import-databazi-vetsich-nez-96-mb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\",\"name\":\"Websupport Centrum n\u00e1pov\u011bdy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"cs\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy","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.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/","og_locale":"cs_CZ","og_type":"article","og_title":"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy","og_description":"Pokud pot\u0159ebujete importovat datab\u00e1zi, jej\u00ed\u017e velikost\u00a0p\u0159esahuje 96 MB, v rozhran\u00ed phpMyAdmin naraz\u00edte na limit stanoven\u00fd maxim\u00e1ln\u00ed velikost\u00ed uploadovan\u00e9ho souboru (n\u00e1vod na import men\u0161\u00edch DB najdete\u00a0zde). V tomto \u010dl\u00e1nku si uk\u00e1\u017eeme, jak p\u0159ekonat zm\u00edn\u011bn\u00e9 omezen\u00ed, a\u0165 u\u017e pro u\u017eivatele opera\u010dn\u00edch syst\u00e9m\u016f Windows nebo Linux. Windows Budete pot\u0159ebovat MySQL klienta, v kter\u00e9m...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2021-07-19T13:38:53+00:00","og_image":[{"url":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/","name":"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png","datePublished":"2021-03-10T09:09:04+00:00","dateModified":"2021-07-19T13:38:53+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/#primaryimage","url":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png","contentUrl":"https:\/\/www.websupport.sk\/support\/app\/uploads\/2018\/12\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi-vetsich-nez-96-mb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Import datab\u00e1z\u00ed v\u011bt\u0161\u00edch ne\u017e 96 MB"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.cz\/podpora\/#website","url":"https:\/\/www.websupport.cz\/podpora\/","name":"Websupport Centrum n\u00e1pov\u011bdy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.cz\/podpora\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"cs"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/513\/revisions"}],"predecessor-version":[{"id":3824,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/513\/revisions\/3824"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=513"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}