{"id":6324,"date":"2020-08-11T10:24:21","date_gmt":"2020-08-11T08:24:21","guid":{"rendered":"https:\/\/www.webonic.hu\/support\/?post_type=ht_kb&#038;p=6324"},"modified":"2023-05-09T15:39:20","modified_gmt":"2023-05-09T13:39:20","slug":"megszunik-az-elavult-adatbazisok-tamogatasa","status":"publish","type":"ht_kb","link":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/","title":{"rendered":"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa"},"content":{"rendered":"\n<p>T\u00e1rhelyeinken 2020-t\u00f3l kezd\u0151d\u0151en v\u00e9get \u00e9r t\u00f6bb elavult SQL adatb\u00e1zis verzi\u00f3j\u00e1nak t\u00e1mogat\u00e1sa.<br>Az al\u00e1bbiakban inform\u00e1ci\u00f3k olvashat\u00f3k, melyek el\u0151k\u00e9sz\u00edtik a friss\u00edt\u00e9st \u00e9s biztos\u00edtj\u00e1k, hogy a weboldal kompatibilis legyen az \u00fajabb verzi\u00f3val is.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-center\" data-align=\"center\">Adatb\u00e1zis verzi\u00f3ja<\/th><th class=\"has-text-align-center\" data-align=\"center\">Friss\u00edt\u00e9s d\u00e1tuma<\/th><th class=\"has-text-align-center\" data-align=\"center\">Friss\u00edtve<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">MariaDB 10.1<\/td><td class=\"has-text-align-center\" data-align=\"center\">2022.12.12.<\/td><td class=\"has-text-align-center\" data-align=\"center\">MariaDB 10.3<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MySQL 5.0<\/td><td class=\"has-text-align-center\" data-align=\"center\">2020.08.24<\/td><td class=\"has-text-align-center\" data-align=\"center\">MySQL 5.7<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MySQL 5.1<\/td><td class=\"has-text-align-center\" data-align=\"center\">2020.09.30.<\/td><td class=\"has-text-align-center\" data-align=\"center\">MySQL 5.7<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">MariaDB 5.5<\/td><td class=\"has-text-align-center\" data-align=\"center\">2021.03.09.<\/td><td class=\"has-text-align-center\" data-align=\"center\">MariaDB 10.3<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">PostgreSQL 9<\/td><td class=\"has-text-align-center\" data-align=\"center\">2023.06.05.<\/td><td class=\"has-text-align-center\" data-align=\"center\">PostgreSQL 10<\/td><\/tr><\/tbody><\/table><figcaption class=\"wp-element-caption\">Az egyes SQL verzi\u00f3k friss\u00edt\u00e9s\u00e9nek \u00fctemez\u00e9se<\/figcaption><\/figure>\n\n\n\n<p>Az adatb\u00e1zis t\u00edpusok friss\u00edt\u00e9s\u00e9re automatikusan ker\u00fcl sor az adatb\u00e1zis hozz\u00e1f\u00e9r\u00e9si adatainak megv\u00e1ltoztat\u00e1sa n\u00e9lk\u00fcl. A friss\u00edt\u00e9s el\u0151tt e-mailben k\u00fcld\u00fcnk t\u00e1j\u00e9koztat\u00e1st az \u00e9rintett \u00fcgyfelek r\u00e9sz\u00e9re, majd 14 napon bel\u00fcl elv\u00e9gezz\u00fck a friss\u00edt\u00e9st. Ez esetben a be\u00e1ll\u00edt\u00e1sokon nincs sz\u00fcks\u00e9g v\u00e1ltoztatni.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Manu\u00e1lis friss\u00edt\u00e9s<\/h2>\n\n\n\n<p>Ha ink\u00e1bb egy\u00e9nileg szeretn\u00e9 \u00e1tmozgatni adatb\u00e1zis\u00e1t valamelyik \u00fajabb t\u00edpus\u00fa adatb\u00e1zisba, \u00fagy az al\u00e1bbi bejegyz\u00e9seink lehetnek seg\u00edts\u00e9g\u00e9re:<br><a href=\"https:\/\/www.webonic.hu\/support\/kb\/adatbazis-masolasa\/\" target=\"_blank\" rel=\"noreferrer noopener\">Adatb\u00e1zis m\u00e1sol\u00e1sa<\/a><br><a href=\"https:\/\/www.webonic.hu\/support\/kb\/adatbazis-kapcsolodasok\" target=\"_blank\" rel=\"noreferrer noopener\">Adatb\u00e1zis kapcsol\u00f3d\u00e1si lehet\u0151s\u00e9gek<\/a><\/p>\n\n\n\n<p>A k\u00e9zi \u00e1ttelep\u00edt\u00e9s miatt a konfigur\u00e1ci\u00f3s f\u00e1jlokban is sz\u00fcks\u00e9ges m\u00f3dos\u00edtani az adatokat, ugyanis a kiszolg\u00e1l\u00f3k \u00e9s a hozz\u00e1f\u00e9r\u00e9si adatok is v\u00e1ltoznak az \u00faj t\u00edpus\u00fa adatb\u00e1zis haszn\u00e1lat\u00e1val.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A webhely kompatibilit\u00e1sa \u00e9s v\u00e1ltoz\u00e1sai<\/h2>\n\n\n\n<p>Ha tartalomkezel\u0151 rendszert (CMS) haszn\u00e1l (pl. WordPress, Joomla, Drupal), A weboldalnak az SQL-adatb\u00e1zisok \u00fajabb verzi\u00f3ival t\u00f6k\u00e9letesen m\u0171k\u00f6dnie kell. A leggyakrabban haszn\u00e1lt tartalomkezel\u0151 rendszerek kompatibilis ezekkel az \u00fajabb adatb\u00e1zis verzi\u00f3kkal, ha azok (b\u0151v\u00edtm\u00e9nyek \u00e9s t\u00e9m\u00e1k is) naprak\u00e9szek. Javasoljuk, hogy mindig friss\u00edtse a tartalomkezel\u0151 rendszer\u00e9t \u00e9s annak pluginjeit a legfrissebb verzi\u00f3kra, ezzel n\u00f6velve oldala biztons\u00e1g\u00e1t.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wordpress.org\/about\/requirements\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/wordpress.org\/about\/requirements\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.drupal.org\/node\/3044215\/requirements\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.drupal.org\/node\/3044215\/requirements<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/devdocs.prestashop.com\/1.7\/basics\/installation\/system-requirements\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/devdocs.prestashop.com\/1.7\/basics\/installation\/system-requirements\/<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.opencart.com\/requirements\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.opencart.com\/requirements\/<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">A v\u00e1ltoz\u00e1sok hivatalos dokument\u00e1ci\u00f3ja<\/h2>\n\n\n\n<p>Egyedi fejleszt\u00e9s\u0171 oldalak eset\u00e9n az al\u00e1bbi hivatalos dokument\u00e1ci\u00f3k lehetnek m\u00e9g hasznosak:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/mariadb.com\/kb\/en\/upgrading\/\" target=\"_blank\" rel=\"noreferrer noopener\">A MariaDB v\u00e1ltoz\u00e1sainak \u00e1ttekint\u00e9se (t\u00f6bb verzi\u00f3)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/upgrading-from-previous-series.html#upgrade-sql-changes\" target=\"_blank\" rel=\"noreferrer noopener\">A MySQL 5.7 v\u00e1ltoz\u00e1sai a kor\u00e1bbi verzi\u00f3khoz k\u00e9pest<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/10\/release-10.html#id-1.11.6.18.4\" target=\"_blank\" rel=\"noreferrer noopener\">\u00c1tt\u00e9r\u00e9s a PostgreSQL 10-re<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>T\u00e1rhelyeinken 2020-t\u00f3l kezd\u0151d\u0151en v\u00e9get \u00e9r t\u00f6bb elavult SQL adatb\u00e1zis verzi\u00f3j\u00e1nak t\u00e1mogat\u00e1sa.Az al\u00e1bbiakban inform\u00e1ci\u00f3k olvashat\u00f3k, melyek el\u0151k\u00e9sz\u00edtik a friss\u00edt\u00e9st \u00e9s biztos\u00edtj\u00e1k, hogy a weboldal kompatibilis legyen az \u00fajabb verzi\u00f3val is. Adatb\u00e1zis verzi\u00f3ja Friss\u00edt\u00e9s d\u00e1tuma Friss\u00edtve MariaDB 10.1 2022.12.12. MariaDB 10.3 MySQL 5.0 2020.08.24 MySQL 5.7 MySQL 5.1 2020.09.30. MySQL 5.7 MariaDB&#8230;<\/p>\n","protected":false},"author":19,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[100],"ht-kb-tag":[942,1050,879,978],"class_list":["post-6324","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-adatbazis","ht_kb_tag-adatbazis","ht_kb_tag-adatbazis-masolasa","ht_kb_tag-adatbazis-migracio","ht_kb_tag-webadmin-adatbazis"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis<\/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.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta property=\"og:description\" content=\"T\u00e1rhelyeinken 2020-t\u00f3l kezd\u0151d\u0151en v\u00e9get \u00e9r t\u00f6bb elavult SQL adatb\u00e1zis verzi\u00f3j\u00e1nak t\u00e1mogat\u00e1sa.Az al\u00e1bbiakban inform\u00e1ci\u00f3k olvashat\u00f3k, melyek el\u0151k\u00e9sz\u00edtik a friss\u00edt\u00e9st \u00e9s biztos\u00edtj\u00e1k, hogy a weboldal kompatibilis legyen az \u00fajabb verzi\u00f3val is. Adatb\u00e1zis verzi\u00f3ja Friss\u00edt\u00e9s d\u00e1tuma Friss\u00edtve MariaDB 10.1 2022.12.12. MariaDB 10.3 MySQL 5.0 2020.08.24 MySQL 5.7 MySQL 5.1 2020.09.30. MySQL 5.7 MariaDB...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport Tud\u00e1sb\u00e1zis\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T13:39:20+00:00\" \/>\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 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/megszunik-az-elavult-adatbazisok-tamogatasa\\\/\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/megszunik-az-elavult-adatbazisok-tamogatasa\\\/\",\"name\":\"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\"},\"datePublished\":\"2020-08-11T08:24:21+00:00\",\"dateModified\":\"2023-05-09T13:39:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/megszunik-az-elavult-adatbazisok-tamogatasa\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/megszunik-az-elavult-adatbazisok-tamogatasa\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/kb\\\/megszunik-az-elavult-adatbazisok-tamogatasa\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/#website\",\"url\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/\",\"name\":\"Websupport Tud\u00e1sb\u00e1zis\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.websupport.hu\\\/tamogatas\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis","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.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/","og_locale":"hu_HU","og_type":"article","og_title":"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis","og_description":"T\u00e1rhelyeinken 2020-t\u00f3l kezd\u0151d\u0151en v\u00e9get \u00e9r t\u00f6bb elavult SQL adatb\u00e1zis verzi\u00f3j\u00e1nak t\u00e1mogat\u00e1sa.Az al\u00e1bbiakban inform\u00e1ci\u00f3k olvashat\u00f3k, melyek el\u0151k\u00e9sz\u00edtik a friss\u00edt\u00e9st \u00e9s biztos\u00edtj\u00e1k, hogy a weboldal kompatibilis legyen az \u00fajabb verzi\u00f3val is. Adatb\u00e1zis verzi\u00f3ja Friss\u00edt\u00e9s d\u00e1tuma Friss\u00edtve MariaDB 10.1 2022.12.12. MariaDB 10.3 MySQL 5.0 2020.08.24 MySQL 5.7 MySQL 5.1 2020.09.30. MySQL 5.7 MariaDB...","og_url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/","og_site_name":"Websupport Tud\u00e1sb\u00e1zis","article_modified_time":"2023-05-09T13:39:20+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/","url":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/","name":"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa - Websupport Tud\u00e1sb\u00e1zis","isPartOf":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/#website"},"datePublished":"2020-08-11T08:24:21+00:00","dateModified":"2023-05-09T13:39:20+00:00","breadcrumb":{"@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.websupport.hu\/tamogatas\/kb\/megszunik-az-elavult-adatbazisok-tamogatasa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.websupport.hu\/tamogatas\/"},{"@type":"ListItem","position":2,"name":"Megsz\u0171nik az elavult adatb\u00e1zisok t\u00e1mogat\u00e1sa"}]},{"@type":"WebSite","@id":"https:\/\/www.websupport.hu\/tamogatas\/#website","url":"https:\/\/www.websupport.hu\/tamogatas\/","name":"Websupport Tud\u00e1sb\u00e1zis","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.websupport.hu\/tamogatas\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"}]}},"_links":{"self":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/6324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/users\/19"}],"version-history":[{"count":2,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/6324\/revisions"}],"predecessor-version":[{"id":8080,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb\/6324\/revisions\/8080"}],"wp:attachment":[{"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/media?parent=6324"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-category?post=6324"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupport.hu\/tamogatas\/wp-json\/wp\/v2\/ht-kb-tag?post=6324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}