{"id":1212,"date":"2020-12-04T16:54:08","date_gmt":"2020-12-04T15:54:08","guid":{"rendered":"https:\/\/support.websupport.se\/?post_type=ht_kb&#038;p=1212"},"modified":"2021-12-16T15:14:06","modified_gmt":"2021-12-16T14:14:06","slug":"migrering-uppgradering-av-mysql-databaser","status":"publish","type":"ht_kb","link":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/","title":{"rendered":"Migrering \/ uppgradering av MySQL-databaser"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\"><strong><br>Migrering \/ uppgradering av MySQL-databaser<\/strong><\/h4>\n\n\n\n<p>Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.<\/p>\n\n\n\n<p>1. Logga in p\u00e5&nbsp;<a href=\"https:\/\/admin.websupport.se\/\">Webadmin<\/a>.<\/p>\n\n\n\n<p>2. I avsnittet Tj\u00e4nster v\u00e4ljer du den dom\u00e4n som du beh\u00f6ver migrera databasen f\u00f6r och klickar p\u00e5 Databaser till v\u00e4nster.<\/p>\n\n\n\n<p>3. F\u00f6r en specifik databas klickar du p\u00e5 de tre punkterna till h\u00f6ger och sedan Duplicera<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"302\" src=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png\" alt=\"\" class=\"wp-image-18091\" srcset=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png 783w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-50x19.png 50w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-1536x593.png 1536w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-60x23.png 60w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-100x39.png 100w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1.png 1692w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>4. Du kommer att meddelas att en aktuell s\u00e4kerhetskopia m\u00e5ste skapas f\u00f6rst f\u00f6r att g\u00f6ra en kopia &#8211; det h\u00e4r \u00e4r bra, klicka bara p\u00e5 Forts\u00e4tt<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"563\" height=\"248\" src=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_hJwZQe0h5A-1.png\" alt=\"\" class=\"wp-image-18092\" srcset=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_hJwZQe0h5A-1.png 563w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_hJwZQe0h5A-1-50x22.png 50w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_hJwZQe0h5A-1-60x26.png 60w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_hJwZQe0h5A-1-100x44.png 100w\" sizes=\"auto, (max-width: 563px) 100vw, 563px\" \/><\/figure>\n\n\n\n<p>5. P\u00e5 den nya sk\u00e4rmen, v\u00e4lj vilken typ av databas du beh\u00f6ver, ange valfritt namn och l\u00f6senord (du kommer att anv\u00e4nda denna information f\u00f6r senare \u00e5tkomst till den nya databasen) och klicka p\u00e5 Skapa-knappen.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"491\" src=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1-783x491.png\" alt=\"\" class=\"wp-image-18093\" srcset=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1-783x491.png 783w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1-50x31.png 50w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1-60x38.png 60w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1-100x63.png 100w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_EnGNz7YDGF-1.png 1115w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><\/figure>\n\n\n\n<p>Klicka p\u00e5 skapa f\u00f6r att skapa en kopia av databasen.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>\u00c4ndra sidkonfigurationsfiler<\/strong><\/h4>\n\n\n\n<p>N\u00e4r du har tagit en kopia av databasen m\u00e5ste du \u00e4ndra sidans konfigurationsfiler. Det m\u00e5ste justeras som standard<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Databasnamn<\/li><li>Databasanv\u00e4ndarnamn<\/li><li>Databasl\u00f6senord<\/li><li>Namnet p\u00e5 servern, resp. databasv\u00e4rd<\/li><\/ul>\n\n\n\n<p>Anslutningsalternativ med \u00e4ndrad kodning:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">$ connection = new PDO (\"mysql: host = HOSTNAME; port = 33XX; dbname = dbname; charset = utf8\", \"dbname\", \"tu_insert_password\", array (PDO :: MYSQL_ATTR_INIT_COMMAND =&gt; \"SET NAMES 'utf8'\") );<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Lista \u00f6ver v\u00e4rdnamn och portar:<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL&nbsp;5.7 &#8211;&nbsp;mysql57.websupport.se:3311<\/li><li>MariaDB 10.1 &#8211; mariadb101.websupport.se:3312<\/li><li>PostgreSQL 9.0 a 10.0 &#8211;&nbsp;postqresql.websupport.se:5432<\/li><li>MySQL 8.0 &#8211;&nbsp;mysql80.websupport.se:3314&nbsp;<\/li><li>MariaDB 10.3 &#8211;&nbsp;mariadb103.websupport.se:3313<\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Plats f\u00f6r konfigurationsfiler i CMS<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>WordPress &#8211; <\/strong>konfigurationsfilen finns i WordPress-installationen, filen wp-config.php (vanlig s\u00f6kv\u00e4g \u00e4r \/web\/wp-config.php). <a href=\"https:\/\/support.websupport.se\/index.php?type=page&amp;urlcode=883183&amp;title=Napojenie-WordPress-na-in%C3%BA-datab%C3%A1zu\">Redigera WordPress-anslutningen till databasen<\/a>. <\/li><li><strong>Joomla &#8211; <\/strong>konfigurationsfilen finns i Joomla-installationen, filen configuration.php (vanlig s\u00f6kv\u00e4g \u00e4r \/web\/configuration.php). <a href=\"https:\/\/support.websupport.se\/index.php?type=page&amp;urlcode=408623&amp;title=Napojenie-Joomly-na-in%C3%BA-datab%C3%A1zu\">\u00c4ndra Joomlas anslutning till databasen.<\/a><\/li><li><strong>Prestashop &#8211; <\/strong>konfigurationsfilen finns i Prestashop-installationen, filen settings.inc.php, som finns i mappen &#8221;config&#8221; (den vanlig s\u00f6kv\u00e4g \u00e4r \/web\/config\/settings.inc.php). De senaste versionerna av systemet har en konfigurationsfil som finns h\u00e4r: web \/ app \/ config \/ parameters.php. <a href=\"https:\/\/support.websupport.se\/index.php?type=page&amp;urlcode=483678&amp;title=Napojenie-Prestashopu-na-in%C3%BA-datab%C3%A1zu\">Redigera Prestashop-anslutningen till databasen<\/a>.&nbsp;<\/li><li><strong>Drupal &#8211; <\/strong>konfigurationsfilen finns i Drupal-installationen, inst\u00e4llningar.php-filen, som finns i mappen &#8221;platser \/ standard&#8221; (den gemensamma s\u00f6kv\u00e4gen \u00e4r \/web\/sites\/default\/settings.php). <a href=\"https:\/\/support.websupport.se\/index.php?type=page&amp;urlcode=655925&amp;title=Napojenie-Drupalu-na-in%C3%BA-datab%C3%A1zu\">Redigera Drupal-anslutningen till databasen.<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Migrering \/ uppgradering av MySQL-databaser Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick. 1. Logga in p\u00e5&nbsp;Webadmin. 2. I avsnittet Tj\u00e4nster v\u00e4ljer du den dom\u00e4n som du beh\u00f6ver migrera databasen f\u00f6r och klickar p\u00e5 Databaser till v\u00e4nster. 3. F\u00f6r en specifik databas&#8230;<\/p>\n","protected":false},"author":8,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[41],"ht-kb-tag":[],"class_list":["post-1212","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-databas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas<\/title>\n<meta name=\"description\" content=\"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas\" \/>\n<meta property=\"og:description\" content=\"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport kunskapsdatabas\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-16T14:14:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png\" \/>\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 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/\",\"url\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/\",\"name\":\"Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas\",\"isPartOf\":{\"@id\":\"https:\/\/kunskap.websupport.se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png\",\"datePublished\":\"2020-12-04T15:54:08+00:00\",\"dateModified\":\"2021-12-16T14:14:06+00:00\",\"description\":\"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.\",\"breadcrumb\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage\",\"url\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1.png\",\"contentUrl\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1.png\",\"width\":1692,\"height\":653},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kunskap.websupport.se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrering \/ uppgradering av MySQL-databaser\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kunskap.websupport.se\/#website\",\"url\":\"https:\/\/kunskap.websupport.se\/\",\"name\":\"Websupport kunskapsdatabas\",\"description\":\"Websupport kunskapsdatabas\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kunskap.websupport.se\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas","description":"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.","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:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/","og_locale":"sv_SE","og_type":"article","og_title":"Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas","og_description":"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.","og_url":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/","og_site_name":"Websupport kunskapsdatabas","article_modified_time":"2021-12-16T14:14:06+00:00","og_image":[{"url":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/","url":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/","name":"Migrering \/ uppgradering av MySQL-databaser - Websupport kunskapsdatabas","isPartOf":{"@id":"https:\/\/kunskap.websupport.se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage"},"image":{"@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage"},"thumbnailUrl":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1-783x302.png","datePublished":"2020-12-04T15:54:08+00:00","dateModified":"2021-12-16T14:14:06+00:00","description":"Du kan anv\u00e4nda webbadmin-gr\u00e4nssnittet f\u00f6r att \u00e4ndra databastyp. Du kan \u00e4ndra databastypen med n\u00e5gra f\u00e5 klick.","breadcrumb":{"@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#primaryimage","url":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1.png","contentUrl":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/11\/chrome_mbMArHmvwR-1.png","width":1692,"height":653},{"@type":"BreadcrumbList","@id":"https:\/\/kunskap.websupport.se\/kb\/migrering-uppgradering-av-mysql-databaser\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kunskap.websupport.se\/"},{"@type":"ListItem","position":2,"name":"Migrering \/ uppgradering av MySQL-databaser"}]},{"@type":"WebSite","@id":"https:\/\/kunskap.websupport.se\/#website","url":"https:\/\/kunskap.websupport.se\/","name":"Websupport kunskapsdatabas","description":"Websupport kunskapsdatabas","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kunskap.websupport.se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"}]}},"_links":{"self":[{"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb\/1212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/users\/8"}],"version-history":[{"count":3,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb\/1212\/revisions"}],"predecessor-version":[{"id":18094,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb\/1212\/revisions\/18094"}],"wp:attachment":[{"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/media?parent=1212"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb-category?post=1212"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb-tag?post=1212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}