{"id":28568,"date":"2024-02-29T15:03:45","date_gmt":"2024-02-29T13:03:45","guid":{"rendered":"https:\/\/hostkoss.com\/b\/?p=28568"},"modified":"2024-07-13T12:46:41","modified_gmt":"2024-07-13T09:46:41","slug":"dump-mysql-database","status":"publish","type":"post","link":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/","title":{"rendered":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL a pre\u010do je to potrebn\u00e9"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-\u0449\u043e-\u0442\u0430\u043a\u0435-\u0434\u0430\u043c\u043f-\u0431\u0430\u0437\u0438-\u0434\u0430\u043d\u0438\u0445-mysql\">\u010co je to v\u00fdpis datab\u00e1zy MySQL?<\/h2>\n\n\n\n<p><strong>V\u00fdpis datab\u00e1zy MySQL<\/strong> je k\u00f3pia \u00fadajov v datab\u00e1ze MySQL. M\u00f4\u017ee sa pou\u017ei\u0165 na op\u00e4tovn\u00e9 vytvorenie rovnakej datab\u00e1zy na inom po\u010d\u00edta\u010di alebo serveri.<\/p>\n\n\n\n<p><strong>Existuje mnoho d\u00f4vodov, pre\u010do<\/strong> by ste mohli chcie\u0165 vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL. M\u00f4\u017eete chcie\u0165 presun\u00fa\u0165 svoje datab\u00e1zy z jedn\u00e9ho servera na druh\u00fd, alebo m\u00f4\u017eete chcie\u0165 presun\u00fa\u0165 svoje datab\u00e1zy medzi r\u00f4znymi prostrediami, ako s\u00fa v\u00fdvojov\u00e9 a produk\u010dn\u00e9 servery, alebo m\u00f4\u017eete chcie\u0165 vytvori\u0165 z\u00e1lohy svojich datab\u00e1z.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-\u044f\u043a-\u0437\u0440\u043e\u0431\u0438\u0442\u0438-\u0434\u0430\u043c\u043f-\u0431\u0430\u0437\u0438-\u0434\u0430\u043d\u0438\u0445-\u0443-phpmyadmin\">Ako vyp\u00edsa\u0165 datab\u00e1zu v phpMyAdmin<\/h2>\n\n\n\n<p><strong>Prv\u00fdm krokom<\/strong> pri vytv\u00e1ran\u00ed v\u00fdpisu datab\u00e1zy je n\u00e1js\u0165 datab\u00e1zu, ktor\u00fa chcete vytvori\u0165. M\u00f4\u017eete to urobi\u0165 prech\u00e1dzan\u00edm bo\u010dn\u00e9ho panela na \u013eavej strane.<\/p>\n\n\n\n<p><strong>Pos\u00favan\u00edm sa nadol<\/strong> vyh\u013eadajte po\u017eadovan\u00fa datab\u00e1zu a vyberte ju. Po v\u00fdbere po\u017eadovanej datab\u00e1zy sa vr\u00e1\u0165te na hlavn\u00fa str\u00e1nku a kliknite na tla\u010didlo<strong>Exportova\u0165<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"780\" height=\"410\" src=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_.jpg\" alt=\"hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com\" class=\"wp-image-28569\" srcset=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_.jpg 780w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_-300x158.jpg 300w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_-768x404.jpg 768w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_-100x53.jpg 100w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-hostkoss.com_-700x368.jpg 700w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/figure>\n\n\n\n<p><strong>Ak chcete exportova\u0165 \u00fadaje<\/strong>, potrebujete typ s\u00faboru, ktor\u00fd phpMyAdmin podporuje. Najbe\u017enej\u0161ie typy s\u00faborov s\u00fa<strong>.sql a .sqlite.<\/strong><\/p>\n\n\n\n<p><strong>Vyberte niektor<\/strong> \u00fa z nich a potom kliknite na tla\u010didlo <strong>\u00cds\u0165<\/strong>.<\/p>\n\n\n\n<p><strong>Teraz v\u00e1s phpMyAdmin<\/strong> vyzve, aby ste ur\u010dili miesto, kam m\u00e1 s\u00fabor ulo\u017ei\u0165, ako aj jeho n\u00e1zov. Zadajte tieto \u00fadaje a pred kliknut\u00edm na tla\u010didlo<strong>&#8220;\u00c1no<\/strong>&#8221; znova kliknite na tla\u010didlo &#8220;<strong>\u00cds\u0165<\/strong>&#8220;, \u010d\u00edm potvrd\u00edte, \u017ee chcete, aby <strong>phpMyAdmin <\/strong>pokra\u010doval v exporte \u00fadajov z tejto datab\u00e1zy.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-\u044f\u043a-\u0432\u0456\u0434\u043d\u043e\u0432\u0438\u0442\u0438-\u0431\u0430\u0437\u0443-\u0434\u0430\u043d\u0438\u0445-mysql-\u0437-\u0434\u0430\u043c\u043f\u0430\">Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu<\/h2>\n\n\n\n<p><strong>Ak chcete obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu<\/strong>, najprv vyberte po\u017eadovan\u00fa datab\u00e1zu v bo\u010dnom paneli aplik\u00e1cie phpMyAdmin a prejdite na kartu Import v hornom menu.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"780\" height=\"410\" src=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_.jpg\" alt=\"hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com\" class=\"wp-image-28570\" srcset=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_.jpg 780w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_-300x158.jpg 300w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_-768x404.jpg 768w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_-100x53.jpg 100w, https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/11\/hostkoss-blog-dump-MySQL-database-phpMyAdmin-Import-hostkoss.com_-700x368.jpg 700w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/figure>\n\n\n\n<p><strong>Zobraz\u00ed sa dlh\u00fd zoznam mo\u017enost\u00ed importu.<\/strong> Vyberte polo\u017eku &#8220;Dump file&#8221; a kliknite na tla\u010didlo &#8220;Choose file&#8221; (Vybra\u0165 s\u00fabor). Vyberte s\u00fabor v\u00fdpisu a kliknite na tla\u010didlo<strong>Nahra\u0165<\/strong>. Budete m\u00f4c\u0165 vidie\u0165, \u017ee bol \u00faspe\u0161ne nahran\u00fd. Teraz sta\u010d\u00ed vybra\u0165 cie\u013eov\u00fa datab\u00e1zu a klikn\u00fa\u0165 na tla\u010didlo<strong>&#8220;Go&#8221; (Prejs\u0165<\/strong>) a je to.<\/p>\n\n\n\n<p><strong>Pre\u010d\u00edtajte si tie\u017e:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/hostkoss.com\/b\/sk\/log\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u010co s\u00fa s\u00fabory denn\u00edka<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/hostkoss.com\/b\/sk\/ram-swap\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u010co je to garantovan\u00e1 pam\u00e4\u0165 a SWAP?<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/hostkoss.com\/b\/sk\/database\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u010co je to datab\u00e1za a pre\u010do je d\u00f4le\u017eit\u00e1 pre podnikanie<\/a><\/strong><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/hostkoss.com\/b\/sk\/centos-vs-ubuntu\/\" target=\"_blank\" rel=\"noreferrer noopener\">V\u00fdber najlep\u0161ieho opera\u010dn\u00e9ho syst\u00e9mu pre v\u00e1\u0161 server: CentOS vs Ubuntu<\/a><\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-\u0437\u0430\u043f\u0438\u0442\u0430\u043d\u043d\u044f-\u0442\u0430-\u0432\u0456\u0434\u043f\u043e\u0432\u0456\u0434\u0456-\u043f\u0440\u043e-\u0431\u0430\u0437\u0438-\u0434\u0430\u043d\u0438\u0445-mysql\">Ot\u00e1zky a odpovede o datab\u00e1zach MySQL<\/h2>\n\n\n\n<div class=\"schema-faq wp-block-yoast-faq-block\"><div class=\"schema-faq-section\" id=\"faq-question-1720799195990\"><strong class=\"schema-faq-question\">Ako\u00a0<strong>\u010dasto by som mal vymaz\u00e1va\u0165 datab\u00e1zu MySQL<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>Odpor\u00fa\u010da sa vytv\u00e1ra\u0165 pravideln\u00e9 z\u00e1lohy, napr\u00edklad denne alebo t\u00fd\u017edenne, aby sa zabezpe\u010dila minim\u00e1lna strata \u00fadajov v pr\u00edpade nepredv\u00eddan\u00fdch udalost\u00ed.<\/em><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1720799216460\"><strong class=\"schema-faq-question\"><strong>Je mo\u017en\u00e9 vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL bez preru\u0161enia datab\u00e1zy<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>\u00c1no, pr\u00edkaz mysqldump zvy\u010dajne nezamyk\u00e1 tabu\u013eky po\u010das procesu z\u00e1lohovania, \u010do umo\u017e\u0148uje pokra\u010dova\u0165 v pr\u00e1ci s datab\u00e1zou bez preru\u0161enia.<\/em><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1720799228719\"><strong class=\"schema-faq-question\">Mus\u00edm\u00a0<strong>s\u00fabory v\u00fdpisu datab\u00e1zy MySQL \u0161ifrova\u0165<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>\u0160ifrovanie s\u00faborov v\u00fdpisu datab\u00e1zy prid\u00e1va \u010fal\u0161iu \u00farove\u0148 zabezpe\u010denia, najm\u00e4 pri ukladan\u00ed z\u00e1loh na extern\u00e9 alebo cloudov\u00e9 \u00falo\u017eisko.<\/em><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1720799239910\"><strong class=\"schema-faq-question\">M\u00f4\u017eem\u00a0<strong>obnovi\u0165 v\u00fdpis datab\u00e1zy MySQL na inom serveri<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>\u00c1no, v\u00fdpis datab\u00e1zy MySQL m\u00f4\u017eete obnovi\u0165 na \u013eubovo\u013enom serveri s nain\u0161talovanou datab\u00e1zou MySQL, ak s\u00fa \u0161trukt\u00fara datab\u00e1zy a pou\u017e\u00edvate\u013esk\u00e9 pr\u00e1va kompatibiln\u00e9.<\/em><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1720799253069\"><strong class=\"schema-faq-question\">Existuj\u00fa\u00a0<strong>nejak\u00e9 obmedzenia t\u00fdkaj\u00face sa ve\u013ekosti skl\u00e1dok datab\u00e1zy MySQL<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>Hoci skump datab\u00e1zy MySQL m\u00f4\u017ee by\u0165 ve\u013ek\u00fd, pri pl\u00e1novan\u00ed pravideln\u00fdch skumpov by ste mali bra\u0165 do \u00favahy mno\u017estvo \u00falo\u017en\u00e9ho priestoru a trvanie z\u00e1lohovania.<\/em><\/p> <\/div> <div class=\"schema-faq-section\" id=\"faq-question-1720799265246\"><strong class=\"schema-faq-question\"><strong>Ak\u00e9 opatrenia by som mal prija\u0165 pri ukladan\u00ed s\u00faborov v\u00fdpisov datab\u00e1z MySQL<\/strong>?<\/strong> <p class=\"schema-faq-answer\"><em>Z\u00e1lo\u017en\u00e9 s\u00fabory ukladajte na bezpe\u010dn\u00e9 miesta, najlep\u0161ie do offline alebo \u0161ifrovan\u00e9ho \u00falo\u017eiska, aby ste zabr\u00e1nili neopr\u00e1vnen\u00e9mu pr\u00edstupu alebo \u00faniku \u00fadajov.<\/em><\/p> <\/div> <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u010co je to v\u00fdpis datab\u00e1zy MySQL? V\u00fdpis datab\u00e1zy MySQL je k\u00f3pia \u00fadajov v datab\u00e1ze MySQL. M\u00f4\u017ee sa pou\u017ei\u0165 na op\u00e4tovn\u00e9 vytvorenie rovnakej datab\u00e1zy na inom&#8230;<\/p>\n","protected":false},"author":1,"featured_media":28557,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1969],"tags":[],"class_list":["post-28568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.4 (Yoast SEO v25.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?<\/title>\n<meta name=\"description\" content=\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?\" \/>\n<meta property=\"og:description\" content=\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"hostkoss blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/hostkoss\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-29T13:03:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-13T09:46:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1-700x368.webp\" \/>\n<meta name=\"author\" content=\"Andrii Kostashchuk\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?\" \/>\n<meta name=\"twitter:description\" content=\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1-700x368.webp\" \/>\n<meta name=\"twitter:creator\" content=\"@hostkoss\" \/>\n<meta name=\"twitter:site\" content=\"@hostkoss\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Andrii Kostashchuk\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\"},\"author\":{\"name\":\"Andrii Kostashchuk\",\"@id\":\"https:\/\/hostkoss.com\/b\/#\/schema\/person\/29139467da980461cf9aabb9db0582a1\"},\"headline\":\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL a pre\u010do je to potrebn\u00e9\",\"datePublished\":\"2024-02-29T13:03:45+00:00\",\"dateModified\":\"2024-07-13T09:46:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\"},\"wordCount\":671,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hostkoss.com\/b\/#organization\"},\"image\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp\",\"articleSection\":[\"U\u017eito\u010dn\u00e9 \u010dl\u00e1nky o datab\u00e1zach MySQL pre v\u00fdvoj\u00e1rov\"],\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\",\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\",\"name\":\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?\",\"isPartOf\":{\"@id\":\"https:\/\/hostkoss.com\/b\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp\",\"datePublished\":\"2024-02-29T13:03:45+00:00\",\"dateModified\":\"2024-07-13T09:46:41+00:00\",\"description\":\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?\",\"breadcrumb\":{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#breadcrumb\"},\"mainEntity\":[{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990\"},{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460\"},{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719\"},{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910\"},{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069\"},{\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246\"}],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage\",\"url\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp\",\"contentUrl\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp\",\"width\":780,\"height\":410,\"caption\":\"blog-dump-MySQL-datab\u00e1za\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0411\u043b\u043e\u0433\",\"item\":\"https:\/\/hostkoss.com\/b\/uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"U\u017eito\u010dn\u00e9 \u010dl\u00e1nky o datab\u00e1zach MySQL pre v\u00fdvoj\u00e1rov\",\"item\":\"https:\/\/hostkoss.com\/b\/sk\/category\/mysql-database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL a pre\u010do je to potrebn\u00e9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hostkoss.com\/b\/#website\",\"url\":\"https:\/\/hostkoss.com\/b\/\",\"name\":\"hostkoss blog\",\"description\":\"\u041d\u0430\u0448 \u0431\u043b\u043e\u0433 \u2014 \u044d\u0442\u043e \u043c\u0435\u0441\u0442\u043e, \u0433\u0434\u0435 \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0439\u0442\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0441\u0442\u0438 \u0438 \u0442\u0435\u043d\u0434\u0435\u043d\u0446\u0438\u0438 \u043e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0445\u043e\u0441\u0442\u0438\u043d\u0433\u0430. \u0417\u0430\u0445\u043e\u0434\u0438\u0442\u0435 \u0432 \u0431\u043b\u043e\u0433 hostkoss.com\",\"publisher\":{\"@id\":\"https:\/\/hostkoss.com\/b\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hostkoss.com\/b\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hostkoss.com\/b\/#organization\",\"name\":\"hostkoss\",\"url\":\"https:\/\/hostkoss.com\/b\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostkoss.com\/b\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/10\/150-150-hostkoss.com-logo.jpg\",\"contentUrl\":\"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/10\/150-150-hostkoss.com-logo.jpg\",\"width\":150,\"height\":150,\"caption\":\"hostkoss\"},\"image\":{\"@id\":\"https:\/\/hostkoss.com\/b\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/hostkoss\/\",\"https:\/\/x.com\/hostkoss\",\"https:\/\/www.instagram.com\/hostkoss\/\",\"https:\/\/www.pinterest.com\/hostkoss\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hostkoss.com\/b\/#\/schema\/person\/29139467da980461cf9aabb9db0582a1\",\"name\":\"Andrii Kostashchuk\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/hostkoss.com\/b\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/793d8b2906bf106c9777e9654119c73d983a8cd5ea20cb823e728ed35aac23b7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/793d8b2906bf106c9777e9654119c73d983a8cd5ea20cb823e728ed35aac23b7?s=96&d=mm&r=g\",\"caption\":\"Andrii Kostashchuk\"},\"description\":\"\u0410\u043d\u0434\u0440\u0435\u0439 \u0438\u043c\u0435\u0435\u0442 \u043e\u043f\u044b\u0442 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430 \u0440\u0430\u0437\u043d\u044b\u0445 \u044f\u0437\u044b\u043a\u0430\u0445 \u043f\u043e\u0434 \u0440\u0430\u0437\u043d\u044b\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b \u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u044b. \u0411\u043e\u043b\u0435\u0435 8 \u043b\u0435\u0442 \u043f\u043e\u0441\u0432\u044f\u0442\u0438\u043b \u0441\u0444\u0435\u0440\u0435 \u0432\u0435\u0431, \u0440\u0430\u0431\u043e\u0442\u0430\u044f \u0441 \u0440\u0430\u0437\u043d\u044b\u043c\u0438 CMS, \u0442\u0430\u043a\u0438\u043c\u0438 \u043a\u0430\u043a: Opencart, Drupal, Joomla, \u0438 \u043a\u043e\u043d\u0435\u0447\u043d\u043e \u0436\u0435 \u043d\u0430\u0438\u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0439 \u0432 \u043d\u0430\u0448\u0438 \u0434\u043d\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043a\u043e\u043d\u0442\u0435\u043d\u0442\u043e\u043c WordPress.\",\"sameAs\":[\"https:\/\/hostkoss.com\/b\"],\"url\":\"https:\/\/hostkoss.com\/b\/author\/andrii-kostashchuk\/\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990\",\"position\":1,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990\",\"name\":\"Ako\u00a0\u010dasto by som mal vymaz\u00e1va\u0165 datab\u00e1zu MySQL?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>Odpor\u00fa\u010da sa vytv\u00e1ra\u0165 pravideln\u00e9 z\u00e1lohy, napr\u00edklad denne alebo t\u00fd\u017edenne, aby sa zabezpe\u010dila minim\u00e1lna strata \u00fadajov v pr\u00edpade nepredv\u00eddan\u00fdch udalost\u00ed.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460\",\"position\":2,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460\",\"name\":\"Je mo\u017en\u00e9 vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL bez preru\u0161enia datab\u00e1zy?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>\u00c1no, pr\u00edkaz mysqldump zvy\u010dajne nezamyk\u00e1 tabu\u013eky po\u010das procesu z\u00e1lohovania, \u010do umo\u017e\u0148uje pokra\u010dova\u0165 v pr\u00e1ci s datab\u00e1zou bez preru\u0161enia.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719\",\"position\":3,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719\",\"name\":\"Mus\u00edm\u00a0s\u00fabory v\u00fdpisu datab\u00e1zy MySQL \u0161ifrova\u0165?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>\u0160ifrovanie s\u00faborov v\u00fdpisu datab\u00e1zy prid\u00e1va \u010fal\u0161iu \u00farove\u0148 zabezpe\u010denia, najm\u00e4 pri ukladan\u00ed z\u00e1loh na extern\u00e9 alebo cloudov\u00e9 \u00falo\u017eisko.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910\",\"position\":4,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910\",\"name\":\"M\u00f4\u017eem\u00a0obnovi\u0165 v\u00fdpis datab\u00e1zy MySQL na inom serveri?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>\u00c1no, v\u00fdpis datab\u00e1zy MySQL m\u00f4\u017eete obnovi\u0165 na \u013eubovo\u013enom serveri s nain\u0161talovanou datab\u00e1zou MySQL, ak s\u00fa \u0161trukt\u00fara datab\u00e1zy a pou\u017e\u00edvate\u013esk\u00e9 pr\u00e1va kompatibiln\u00e9.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069\",\"position\":5,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069\",\"name\":\"Existuj\u00fa\u00a0nejak\u00e9 obmedzenia t\u00fdkaj\u00face sa ve\u013ekosti skl\u00e1dok datab\u00e1zy MySQL?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>Hoci skump datab\u00e1zy MySQL m\u00f4\u017ee by\u0165 ve\u013ek\u00fd, pri pl\u00e1novan\u00ed pravideln\u00fdch skumpov by ste mali bra\u0165 do \u00favahy mno\u017estvo \u00falo\u017en\u00e9ho priestoru a trvanie z\u00e1lohovania.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Question\",\"@id\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246\",\"position\":6,\"url\":\"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246\",\"name\":\"Ak\u00e9 opatrenia by som mal prija\u0165 pri ukladan\u00ed s\u00faborov v\u00fdpisov datab\u00e1z MySQL?\",\"answerCount\":1,\"acceptedAnswer\":{\"@type\":\"Answer\",\"text\":\"<em>Z\u00e1lo\u017en\u00e9 s\u00fabory ukladajte na bezpe\u010dn\u00e9 miesta, najlep\u0161ie do offline alebo \u0161ifrovan\u00e9ho \u00falo\u017eiska, aby ste zabr\u00e1nili neopr\u00e1vnen\u00e9mu pr\u00edstupu alebo \u00faniku \u00fadajov.<\/em>\",\"inLanguage\":\"en-US\"},\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?","description":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?","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:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?","og_description":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?","og_url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/","og_site_name":"hostkoss blog","article_publisher":"https:\/\/facebook.com\/hostkoss\/","article_published_time":"2024-02-29T13:03:45+00:00","article_modified_time":"2024-07-13T09:46:41+00:00","og_image":[{"url":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1-700x368.webp","type":"","width":"","height":""}],"author":"Andrii Kostashchuk","twitter_card":"summary_large_image","twitter_title":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?","twitter_description":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?","twitter_image":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1-700x368.webp","twitter_creator":"@hostkoss","twitter_site":"@hostkoss","twitter_misc":{"Written by":"Andrii Kostashchuk","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#article","isPartOf":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/"},"author":{"name":"Andrii Kostashchuk","@id":"https:\/\/hostkoss.com\/b\/#\/schema\/person\/29139467da980461cf9aabb9db0582a1"},"headline":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL a pre\u010do je to potrebn\u00e9","datePublished":"2024-02-29T13:03:45+00:00","dateModified":"2024-07-13T09:46:41+00:00","mainEntityOfPage":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/"},"wordCount":671,"commentCount":0,"publisher":{"@id":"https:\/\/hostkoss.com\/b\/#organization"},"image":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp","articleSection":["U\u017eito\u010dn\u00e9 \u010dl\u00e1nky o datab\u00e1zach MySQL pre v\u00fdvoj\u00e1rov"],"inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/","url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/","name":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL? \u010co je MySQL?","isPartOf":{"@id":"https:\/\/hostkoss.com\/b\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp","datePublished":"2024-02-29T13:03:45+00:00","dateModified":"2024-07-13T09:46:41+00:00","description":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL na adrese phpMyAdmin\u2753\ufe0f Ako obnovi\u0165 datab\u00e1zu MySQL z v\u00fdpisu\u2753 a pre\u010do by ste to mali urobi\u0165?","breadcrumb":{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#breadcrumb"},"mainEntity":[{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990"},{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460"},{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719"},{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910"},{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069"},{"@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246"}],"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#primaryimage","url":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp","contentUrl":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2024\/02\/hostkoss-blog-dump-MySQL-database-hostkoss.com_-1.webp","width":780,"height":410,"caption":"blog-dump-MySQL-datab\u00e1za"},{"@type":"BreadcrumbList","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0411\u043b\u043e\u0433","item":"https:\/\/hostkoss.com\/b\/uk\/"},{"@type":"ListItem","position":2,"name":"U\u017eito\u010dn\u00e9 \u010dl\u00e1nky o datab\u00e1zach MySQL pre v\u00fdvoj\u00e1rov","item":"https:\/\/hostkoss.com\/b\/sk\/category\/mysql-database\/"},{"@type":"ListItem","position":3,"name":"Ako vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL a pre\u010do je to potrebn\u00e9"}]},{"@type":"WebSite","@id":"https:\/\/hostkoss.com\/b\/#website","url":"https:\/\/hostkoss.com\/b\/","name":"hostkoss blog","description":"\u041d\u0430\u0448 \u0431\u043b\u043e\u0433 \u2014 \u044d\u0442\u043e \u043c\u0435\u0441\u0442\u043e, \u0433\u0434\u0435 \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0439\u0442\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0435 \u043d\u043e\u0432\u043e\u0441\u0442\u0438 \u0438 \u0442\u0435\u043d\u0434\u0435\u043d\u0446\u0438\u0438 \u043e \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0438 \u0441\u0430\u0439\u0442\u043e\u0432 \u0432 \u043e\u0431\u043b\u0430\u0441\u0442\u0438 \u0445\u043e\u0441\u0442\u0438\u043d\u0433\u0430. \u0417\u0430\u0445\u043e\u0434\u0438\u0442\u0435 \u0432 \u0431\u043b\u043e\u0433 hostkoss.com","publisher":{"@id":"https:\/\/hostkoss.com\/b\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hostkoss.com\/b\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/hostkoss.com\/b\/#organization","name":"hostkoss","url":"https:\/\/hostkoss.com\/b\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostkoss.com\/b\/#\/schema\/logo\/image\/","url":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/10\/150-150-hostkoss.com-logo.jpg","contentUrl":"https:\/\/hostkoss.com\/b\/wp-content\/uploads\/2022\/10\/150-150-hostkoss.com-logo.jpg","width":150,"height":150,"caption":"hostkoss"},"image":{"@id":"https:\/\/hostkoss.com\/b\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/hostkoss\/","https:\/\/x.com\/hostkoss","https:\/\/www.instagram.com\/hostkoss\/","https:\/\/www.pinterest.com\/hostkoss\/"]},{"@type":"Person","@id":"https:\/\/hostkoss.com\/b\/#\/schema\/person\/29139467da980461cf9aabb9db0582a1","name":"Andrii Kostashchuk","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/hostkoss.com\/b\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/793d8b2906bf106c9777e9654119c73d983a8cd5ea20cb823e728ed35aac23b7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/793d8b2906bf106c9777e9654119c73d983a8cd5ea20cb823e728ed35aac23b7?s=96&d=mm&r=g","caption":"Andrii Kostashchuk"},"description":"\u0410\u043d\u0434\u0440\u0435\u0439 \u0438\u043c\u0435\u0435\u0442 \u043e\u043f\u044b\u0442 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u043d\u0430 \u0440\u0430\u0437\u043d\u044b\u0445 \u044f\u0437\u044b\u043a\u0430\u0445 \u043f\u043e\u0434 \u0440\u0430\u0437\u043d\u044b\u0435 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b \u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u044b. \u0411\u043e\u043b\u0435\u0435 8 \u043b\u0435\u0442 \u043f\u043e\u0441\u0432\u044f\u0442\u0438\u043b \u0441\u0444\u0435\u0440\u0435 \u0432\u0435\u0431, \u0440\u0430\u0431\u043e\u0442\u0430\u044f \u0441 \u0440\u0430\u0437\u043d\u044b\u043c\u0438 CMS, \u0442\u0430\u043a\u0438\u043c\u0438 \u043a\u0430\u043a: Opencart, Drupal, Joomla, \u0438 \u043a\u043e\u043d\u0435\u0447\u043d\u043e \u0436\u0435 \u043d\u0430\u0438\u0431\u043e\u043b\u0435\u0435 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0439 \u0432 \u043d\u0430\u0448\u0438 \u0434\u043d\u0438 \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u043a\u043e\u043d\u0442\u0435\u043d\u0442\u043e\u043c WordPress.","sameAs":["https:\/\/hostkoss.com\/b"],"url":"https:\/\/hostkoss.com\/b\/author\/andrii-kostashchuk\/"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990","position":1,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799195990","name":"Ako\u00a0\u010dasto by som mal vymaz\u00e1va\u0165 datab\u00e1zu MySQL?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>Odpor\u00fa\u010da sa vytv\u00e1ra\u0165 pravideln\u00e9 z\u00e1lohy, napr\u00edklad denne alebo t\u00fd\u017edenne, aby sa zabezpe\u010dila minim\u00e1lna strata \u00fadajov v pr\u00edpade nepredv\u00eddan\u00fdch udalost\u00ed.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460","position":2,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799216460","name":"Je mo\u017en\u00e9 vytvori\u0165 v\u00fdpis datab\u00e1zy MySQL bez preru\u0161enia datab\u00e1zy?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>\u00c1no, pr\u00edkaz mysqldump zvy\u010dajne nezamyk\u00e1 tabu\u013eky po\u010das procesu z\u00e1lohovania, \u010do umo\u017e\u0148uje pokra\u010dova\u0165 v pr\u00e1ci s datab\u00e1zou bez preru\u0161enia.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719","position":3,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799228719","name":"Mus\u00edm\u00a0s\u00fabory v\u00fdpisu datab\u00e1zy MySQL \u0161ifrova\u0165?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>\u0160ifrovanie s\u00faborov v\u00fdpisu datab\u00e1zy prid\u00e1va \u010fal\u0161iu \u00farove\u0148 zabezpe\u010denia, najm\u00e4 pri ukladan\u00ed z\u00e1loh na extern\u00e9 alebo cloudov\u00e9 \u00falo\u017eisko.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910","position":4,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799239910","name":"M\u00f4\u017eem\u00a0obnovi\u0165 v\u00fdpis datab\u00e1zy MySQL na inom serveri?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>\u00c1no, v\u00fdpis datab\u00e1zy MySQL m\u00f4\u017eete obnovi\u0165 na \u013eubovo\u013enom serveri s nain\u0161talovanou datab\u00e1zou MySQL, ak s\u00fa \u0161trukt\u00fara datab\u00e1zy a pou\u017e\u00edvate\u013esk\u00e9 pr\u00e1va kompatibiln\u00e9.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069","position":5,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799253069","name":"Existuj\u00fa\u00a0nejak\u00e9 obmedzenia t\u00fdkaj\u00face sa ve\u013ekosti skl\u00e1dok datab\u00e1zy MySQL?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>Hoci skump datab\u00e1zy MySQL m\u00f4\u017ee by\u0165 ve\u013ek\u00fd, pri pl\u00e1novan\u00ed pravideln\u00fdch skumpov by ste mali bra\u0165 do \u00favahy mno\u017estvo \u00falo\u017en\u00e9ho priestoru a trvanie z\u00e1lohovania.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"},{"@type":"Question","@id":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246","position":6,"url":"https:\/\/hostkoss.com\/b\/sk\/dump-mysql-database\/#faq-question-1720799265246","name":"Ak\u00e9 opatrenia by som mal prija\u0165 pri ukladan\u00ed s\u00faborov v\u00fdpisov datab\u00e1z MySQL?","answerCount":1,"acceptedAnswer":{"@type":"Answer","text":"<em>Z\u00e1lo\u017en\u00e9 s\u00fabory ukladajte na bezpe\u010dn\u00e9 miesta, najlep\u0161ie do offline alebo \u0161ifrovan\u00e9ho \u00falo\u017eiska, aby ste zabr\u00e1nili neopr\u00e1vnen\u00e9mu pr\u00edstupu alebo \u00faniku \u00fadajov.<\/em>","inLanguage":"en-US"},"inLanguage":"en-US"}]}},"lang":"sk","translations":{"sk":28568,"uk":1509,"ru":1496,"en":3291,"pl":10880,"de":13567,"lv":15739,"et":18211,"lt":20628,"ro":23190,"cs":25876,"hu":31131,"it":33799,"fr":37639,"tr":40584,"da":43616,"fi":46612,"id":51772},"amp_enabled":true,"pll_sync_post":[],"_links":{"self":[{"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/posts\/28568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/comments?post=28568"}],"version-history":[{"count":10,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/posts\/28568\/revisions"}],"predecessor-version":[{"id":28581,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/posts\/28568\/revisions\/28581"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/media\/28557"}],"wp:attachment":[{"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/media?parent=28568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/categories?post=28568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostkoss.com\/b\/wp-json\/wp\/v2\/tags?post=28568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}