{"id":9449,"date":"2022-10-21T14:29:37","date_gmt":"2022-10-21T12:29:37","guid":{"rendered":"https:\/\/www.websupport.cz\/podpora\/?post_type=ht_kb&p=9449"},"modified":"2022-10-21T14:50:10","modified_gmt":"2022-10-21T12:50:10","slug":"zalozeni-sprava-databaze","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/","title":{"rendered":"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze"},"content":{"rendered":"\n

N\u00e1vod vhodn\u00fd pro za\u010d\u00e1te\u010dn\u00edky<\/strong><\/p>\n\n\n\n

Pro spr\u00e1vn\u00fd chod webu je v mnoh\u00fdch p\u0159\u00edpadech (jako nap\u0159. pro WordPress) nutn\u00e9 z\u0159\u00eddit datab\u00e1zi. Mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed datab\u00e1zov\u00e9 syst\u00e9my pat\u0159\u00ed MySQL a jej\u00ed ekvivalent MariaDB. Jedn\u00e1 se o rychl\u00fd a stabiln\u00ed datab\u00e1zov\u00fd syst\u00e9m. Nab\u00edz\u00ed bohat\u00fd a velmi u\u017eite\u010dn\u00fd soubor funkc\u00ed a je podporov\u00e1n PHP i CGI skripty.<\/p>\n\n\n\n

V\u00edce o specifikac\u00edch MariaDB datab\u00e1ze se m\u016f\u017eete do\u010d\u00edst \u010dl\u00e1nku MariaDB.<\/a><\/p>\n\n\n\n

Datab\u00e1zi si m\u016f\u017eete vyto\u0159it pod jak\u00fdmkoli bal\u00ed\u010dkem The Hostingu<\/strong>.<\/p>\n\n\n\n

Jak datab\u00e1zi zalo\u017eit?<\/h2>\n\n\n\n

Pro zalo\u017een\u00ed datab\u00e1ze sta\u010d\u00ed jednodu\u0161e p\u0159ej\u00edt do WebAdminu, kde m\u016f\u017eete datab\u00e1zi jednodu\u0161e vytvo\u0159it n\u011bkolika kroky. Datab\u00e1zi m\u016f\u017eete vytvo\u0159it jen pokud m\u00e1te dom\u00e9nu p\u0159i\u0159azenou k The Hostingu<\/strong><\/a>.<\/p>\n\n\n\n

1. V sekci Slu\u017eby vyberte dom\u00e9nu p\u0159i\u0159azenou jako web a klikn\u011bte na ni<\/p>\n\n\n\n

2. Po lev\u00e9 stran\u011b vyberte Datab\u00e1ze a n\u00e1sledn\u011b vyberte Seznam<\/p>\n\n\n\n

3. Novou datab\u00e1zi zalo\u017e\u00edte vybr\u00e1n\u00edm modr\u00e9ho tla\u010d\u00edtka Vytvo\u0159it novou datab\u00e1zi<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4. Pro z\u0159\u00edzen\u00ed datab\u00e1ze mus\u00edte \u00fav\u00e9st ve\u0161ker\u00e9 pot\u0159ebn\u00e9 \u00fadaje. Pokud nev\u00edte, co \u00fadaje znamenaj\u00ed, ponechte p\u0159edvolen\u00e9.<\/p>\n\n\n\n

5. Nastavte heslo k datab\u00e1zi \u010di p\u0159\u00edpadn\u011b zm\u011b\u0148te n\u00e1zev datab\u00e1ze. Tyto \u00fadaje pak slou\u017e\u00ed k p\u0159ihl\u00e1\u0161en\u00ed do datab\u00e1ze. Heslo nen\u00ed mo\u017en\u00e9 pozd\u011bji znovu zobrazit, jen zm\u011bnit.<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Datab\u00e1ze bude z\u0159\u00edzena a funk\u010dn\u00ed do 15 minut po vytvo\u0159en\u00ed. <\/strong><\/p>\n\n\n\n

Jak datab\u00e1zi spravovat?<\/h2>\n\n\n\n

K p\u0159ihl\u00e1\u0161en\u00ed do datab\u00e1ze m\u016f\u017eete pou\u017e\u00edt rozhran\u00ed phpMyAdmin, na kter\u00e9 se m\u016f\u017eete p\u0159ihl\u00e1sit p\u0159es odkaz: https:\/\/dbadmin.websupport.cz\/<\/a><\/strong>. K p\u0159ihl\u00e1\u0161en\u00ed pou\u017eijete \u00fadaje vytvo\u0159en\u00e9 p\u0159i z\u0159\u00edzen\u00ed datab\u00e1ze – alternativn\u011b je naleznete v p\u0159ehledu datab\u00e1ze<\/a><\/strong>, kde si i m\u016f\u017eete zm\u011bnit heslo.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Jakmile se p\u0159ihl\u00e1s\u00edte, m\u00e1te k dispocizi p\u0159ehled datab\u00e1ze a v\u0161ech jej\u00edch tabulek (a) a m\u016f\u017eete ji naplnit daty, nap\u0159. p\u0159es mo\u017enost importu<\/a><\/strong> (b). V kontroln\u00edm panelu vlevo naho\u0159e (c) m\u00e1te z\u00e1kladn\u00ed mo\u017enosti pro vr\u00e1cen\u00ed se na domovskou str\u00e1nku, odhl\u00e1\u0161en\u00ed se z datab\u00e1ze, mo\u017enosti \u010di refresh. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Ve\u0161ker\u00e9 dal\u0161\u00ed funkce pro phpMyAdmin m\u016f\u017eete naj\u00edt v manu\u00e1lu pro phpMyAdmin<\/a>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Pro spr\u00e1vn\u00fd chod webu je v mnoh\u00fdch p\u0159\u00edpadech (jako nap\u0159. pro WordPress) nutn\u00e9 z\u0159\u00eddit datab\u00e1zi. Mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed datab\u00e1zov\u00e9 syst\u00e9my pat\u0159\u00ed MySQL a jej\u00ed ekvivalent MariaDB. Jedn\u00e1 se o rychl\u00fd a stabiln\u00ed datab\u00e1zov\u00fd syst\u00e9m. Nab\u00edz\u00ed bohat\u00fd a velmi u\u017eite\u010dn\u00fd soubor funkc\u00ed a je podporov\u00e1n PHP i CGI skripty. V\u00edce o specifikac\u00edch…<\/p>\n","protected":false},"author":5,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[57,15],"ht-kb-tag":[224,227,221],"class_list":["post-9449","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databaze","ht_kb_category-hosting","ht_kb_tag-sprava-databaze","ht_kb_tag-vytvoreni-databaze","ht_kb_tag-zalozeni-databaze"],"yoast_head":"\nZalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze - 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\/zalozeni-sprava-databaze\/\" \/>\n<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze - Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"og:description\" content=\"Pro spr\u00e1vn\u00fd chod webu je v mnoh\u00fdch p\u0159\u00edpadech (jako nap\u0159. pro WordPress) nutn\u00e9 z\u0159\u00eddit datab\u00e1zi. Mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed datab\u00e1zov\u00e9 syst\u00e9my pat\u0159\u00ed MySQL a jej\u00ed ekvivalent MariaDB. Jedn\u00e1 se o rychl\u00fd a stabiln\u00ed datab\u00e1zov\u00fd syst\u00e9m. Nab\u00edz\u00ed bohat\u00fd a velmi u\u017eite\u010dn\u00fd soubor funkc\u00ed a je podporov\u00e1n PHP i CGI skripty. V\u00edce o specifikac\u00edch...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Centrum n\u00e1pov\u011bdy\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-21T12:50:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-seznam-800x401.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\\\/zalozeni-sprava-databaze\\\/\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/\",\"name\":\"Zalo\u017een\u00ed\\\/spr\u00e1va datab\u00e1ze - Websupport Centrum n\u00e1pov\u011bdy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/10\\\/database-seznam-800x401.png\",\"datePublished\":\"2022-10-21T12:29:37+00:00\",\"dateModified\":\"2022-10-21T12:50:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/#breadcrumb\"},\"inLanguage\":\"cs\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"cs\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/10\\\/database-seznam.png\",\"contentUrl\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/app\\\/uploads\\\/2022\\\/10\\\/database-seznam.png\",\"width\":2556,\"height\":1281},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/kb\\\/zalozeni-sprava-databaze\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.cz\\\/podpora\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Zalo\u017een\u00ed\\\/spr\u00e1va datab\u00e1ze\"}]},{\"@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":"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze - 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\/zalozeni-sprava-databaze\/","og_locale":"cs_CZ","og_type":"article","og_title":"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze - Websupport Centrum n\u00e1pov\u011bdy","og_description":"Pro spr\u00e1vn\u00fd chod webu je v mnoh\u00fdch p\u0159\u00edpadech (jako nap\u0159. pro WordPress) nutn\u00e9 z\u0159\u00eddit datab\u00e1zi. Mezi nejroz\u0161\u00ed\u0159en\u011bj\u0161\u00ed datab\u00e1zov\u00e9 syst\u00e9my pat\u0159\u00ed MySQL a jej\u00ed ekvivalent MariaDB. Jedn\u00e1 se o rychl\u00fd a stabiln\u00ed datab\u00e1zov\u00fd syst\u00e9m. Nab\u00edz\u00ed bohat\u00fd a velmi u\u017eite\u010dn\u00fd soubor funkc\u00ed a je podporov\u00e1n PHP i CGI skripty. V\u00edce o specifikac\u00edch...","og_url":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/","og_site_name":"Websupport Centrum n\u00e1pov\u011bdy","article_modified_time":"2022-10-21T12:50:10+00:00","og_image":[{"url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-seznam-800x401.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\/zalozeni-sprava-databaze\/","url":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/","name":"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze - Websupport Centrum n\u00e1pov\u011bdy","isPartOf":{"@id":"https:\/\/www.websupport.cz\/podpora\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/#primaryimage"},"image":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/#primaryimage"},"thumbnailUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-seznam-800x401.png","datePublished":"2022-10-21T12:29:37+00:00","dateModified":"2022-10-21T12:50:10+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/#breadcrumb"},"inLanguage":"cs","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/"]}]},{"@type":"ImageObject","inLanguage":"cs","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/#primaryimage","url":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-seznam.png","contentUrl":"https:\/\/www.websupport.cz\/podpora\/app\/uploads\/2022\/10\/database-seznam.png","width":2556,"height":1281},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.cz\/podpora\/kb\/zalozeni-sprava-databaze\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.cz\/podpora\/"},{"@type":"ListItem","position":2,"name":"Zalo\u017een\u00ed\/spr\u00e1va datab\u00e1ze"}]},{"@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\/9449","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":11,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/9449\/revisions"}],"predecessor-version":[{"id":9503,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb\/9449\/revisions\/9503"}],"wp:attachment":[{"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/media?parent=9449"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-category?post=9449"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.cz\/podpora\/wp-json\/wp\/v2\/ht-kb-tag?post=9449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}