{"id":3782,"date":"2021-07-19T15:34:17","date_gmt":"2021-07-19T13:34:17","guid":{"rendered":"https:\/\/www.websupport.cz\/podpora\/?post_type=ht_kb&p=3782"},"modified":"2022-10-21T14:50:00","modified_gmt":"2022-10-21T12:50:00","slug":"import-databazi","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/","title":{"rendered":"Import datab\u00e1z\u00ed"},"content":{"rendered":"\n

P\u0159i importovan\u00ed datab\u00e1z\u00ed se textov\u00fd soubor s instrukcemi na vytvo\u0159en\u00ed tabulek a v\u0161emi \u00fadaji (v\u011bt\u0161inou s p\u0159\u00edponou .SQL) nahraje do jin\u00e9 datab\u00e1ze. Podobn\u011b jako p\u0159i jin\u00fdch operac\u00edch s SQL, i zde je dobr\u00fdm pomocn\u00edkem rozhran\u00ed PhpMyAdmin.<\/p>\n\n\n\n

  1. P\u0159ihlaste se do\u00a0PhpMyAdmin<\/a><\/strong>*.<\/li>
  2. V lev\u00e9m menu, hned pod ikonami, vyberte po\u017eadovanou datab\u00e1zi (zv\u00fdrazn\u011bn\u00ed 1)<\/li>
  3. V horn\u00ed \u010d\u00e1sti obrazovky vyberte z\u00e1lo\u017eku\u00a0Import<\/strong>.<\/li>
  4. Vyberte SQL-soubor, kter\u00fd chcete importovat (zv\u00fdrazn\u011bn\u00ed 2).<\/li>
  5. Dokon\u010d\u00edte kliknut\u00edm na tla\u010d\u00edtko\u00a0Import<\/strong> (zv\u00fdrazn\u011bn\u00ed 3).<\/li><\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    * adresy\u00a0k p\u0159ihl\u00e1\u0161en\u00ed do PhpMyadmin pro n\u011bkter\u00e9 konkr\u00e9tn\u00ed servery\u00a0<\/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

    Import datab\u00e1ze je omezen velikost\u00ed datab\u00e1ze<\/strong>. Jak nahr\u00e1t velk\u00e9 datab\u00e1ze ( > 96 MB) se dozv\u00edte v jin\u00e9m \u010dl\u00e1nku<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

    P\u0159i importovan\u00ed datab\u00e1z\u00ed se textov\u00fd soubor s instrukcemi na vytvo\u0159en\u00ed tabulek a v\u0161emi \u00fadaji (v\u011bt\u0161inou s p\u0159\u00edponou .SQL) nahraje do jin\u00e9 datab\u00e1ze. Podobn\u011b jako p\u0159i jin\u00fdch operac\u00edch s SQL, i zde je dobr\u00fdm pomocn\u00edkem rozhran\u00ed PhpMyAdmin. P\u0159ihlaste se do\u00a0PhpMyAdmin*. V lev\u00e9m menu, hned pod ikonami, vyberte po\u017eadovanou datab\u00e1zi (zv\u00fdrazn\u011bn\u00ed 1)…<\/p>\n","protected":false},"author":5,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[57,15],"ht-kb-tag":[],"class_list":["post-3782","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaze","ht_kb_category-hosting"],"yoast_head":"\nImport datab\u00e1z\u00ed - 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\/\" \/>\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 - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"P\u0159i importovan\u00ed datab\u00e1z\u00ed se textov\u00fd soubor s instrukcemi na vytvo\u0159en\u00ed tabulek a v\u0161emi \u00fadaji (v\u011bt\u0161inou s p\u0159\u00edponou .SQL) nahraje do jin\u00e9 datab\u00e1ze. Podobn\u011b jako p\u0159i jin\u00fdch operac\u00edch s SQL, i zde je dobr\u00fdm pomocn\u00edkem rozhran\u00ed PhpMyAdmin. P\u0159ihlaste se do\u00a0PhpMyAdmin*. V lev\u00e9m menu, hned pod ikonami, vyberte po\u017eadovanou datab\u00e1zi (zv\u00fdrazn\u011bn\u00ed 1)...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-21T12:50:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import-800x410.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=\"1 minuta\" \/>\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\/\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/\",\"name\":\"Import datab\u00e1z\u00ed - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import-800x410.png\",\"datePublished\":\"2021-07-19T13:34:17+00:00\",\"dateModified\":\"2022-10-21T12:50:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage\",\"url\":\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import.png\",\"contentUrl\":\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import.png\",\"width\":2553,\"height\":1309},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.websupport.cz\/podpora\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import datab\u00e1z\u00ed\"}]},{\"@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 - 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\/","og_locale":"cs_CZ","og_type":"article","og_title":"Import datab\u00e1z\u00ed - Websupport Centrum n\u00e1pov\u011bdy","og_description":"P\u0159i importovan\u00ed datab\u00e1z\u00ed se textov\u00fd soubor s instrukcemi na vytvo\u0159en\u00ed tabulek a v\u0161emi \u00fadaji (v\u011bt\u0161inou s p\u0159\u00edponou .SQL) nahraje do jin\u00e9 datab\u00e1ze. Podobn\u011b jako p\u0159i jin\u00fdch operac\u00edch s SQL, i zde je dobr\u00fdm pomocn\u00edkem rozhran\u00ed PhpMyAdmin. P\u0159ihlaste se do\u00a0PhpMyAdmin*. V lev\u00e9m menu, hned pod ikonami, vyberte po\u017eadovanou datab\u00e1zi (zv\u00fdrazn\u011bn\u00ed 1)...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2022-10-21T12:50:00+00:00","og_image":[{"url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import-800x410.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Odhadovan\u00e1 doba \u010dten\u00ed":"1 minuta"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/","name":"Import datab\u00e1z\u00ed - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import-800x410.png","datePublished":"2021-07-19T13:34:17+00:00","dateModified":"2022-10-21T12:50:00+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#primaryimage","url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import.png","contentUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-import.png","width":2553,"height":1309},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/import-databazi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Import datab\u00e1z\u00ed"}]},{"@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\/3782","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\/5"}],"version-history":[{"count":6,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/3782\/revisions"}],"predecessor-version":[{"id":9527,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/3782\/revisions\/9527"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=3782"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=3782"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=3782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}