{"id":50573,"date":"2023-05-09T14:17:55","date_gmt":"2023-05-09T13:17:55","guid":{"rendered":"https:\/\/kinsta.com\/dk\/?p=50573&#038;preview=true&#038;preview_id=50573"},"modified":"2023-08-24T10:16:14","modified_gmt":"2023-08-24T09:16:14","slug":"mysql-til-mariadb","status":"publish","type":"post","link":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/","title":{"rendered":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB"},"content":{"rendered":"<p>Hvis du overvejer at migrere fra MySQL til MariaDB, er der gode argumenter for at skifte. Som en af de f\u00f8rste DBMS-platforme (database management system) har MySQL domineret branchen i lang tid og er stadig bem\u00e6rkelsesv\u00e6rdigt relevant.<\/p>\n<p>Organisationer er dog langsomt ved at bev\u00e6ge sig v\u00e6k fra det p\u00e5 grund af dets langsommere behandling og ineffektivitet i h\u00e5ndteringen af komplekse data. Mange af disse organisationer g\u00e5r over til MariaDB.<\/p>\n<p>MariaDB er et nyere, letv\u00e6gts-DBMS, der tilbyder forbedret ydeevne, flere avancerede funktioner og en st\u00f8rre kapacitet til at h\u00e5ndtere komplekse datas\u00e6t. <a href=\"https:\/\/kinsta.com\/dk\/blog\/mariadb-vs-mysql\/\">Sammenlignet med MySQL<\/a> kan MariaDB ogs\u00e5 prale af et mere levende f\u00e6llesskab, der holder sit offentlige repository opdateret og foretager innovative \u00e6ndringer.<\/p>\n<p>Denne artikel vil guide dig gennem migreringen af dine data fra MySQL til MariaDB.<\/p>\n<div><\/div><kinsta-auto-toc heading=\"Table of Contents\" exclude=\"last\" list-style=\"arrow\" selector=\"h2\" count-number=\"-1\"><\/kinsta-auto-toc>\n<h2>S\u00e5dan skifter du databaser fra MySQL til MariaDB<\/h2>\n<p>Det er afsindig nemt at migrere fra MySQL til MariaDB. Du kan opdele hele processen i to v\u00e6sentlige trin:<\/p>\n<ol start=\"1\">\n<li><a href=\"https:\/\/kinsta.com\/blog\/mysql-backup-database\/\">Sikkerhedskopier din database<\/a> i MySQL ved at dumpe den i en SQL-fil.<\/li>\n<li>Log ind p\u00e5 din MariaDB-server, og indl\u00e6s backup-filen for at oprette databasen.<\/li>\n<\/ol>\n<p>MariaDB er kompatibel med MySQL, s\u00e5 du vil ikke have problemer med at migrere din database.<\/p>\n<p>N\u00e5r du har migreret din database fra MySQL til MariaDB og krydstjekket, at tabellerne er komplette, kan du opdatere dit websted til at hente data fra MariaDB i stedet for MySQL.<\/p>\n\n<h3>Krav<\/h3>\n<p>Da du \u00f8nsker at migrere fra MySQL til MariaDB, b\u00f8r du allerede have en MySQL-database, der indeholder nogle data, du \u00f8nsker at flytte.<\/p>\n<p>Naturligvis skal du ogs\u00e5 have en kopi af MariaDB. Selv om det ikke er p\u00e5kr\u00e6vet, bruger denne vejledning <a href=\"https:\/\/kinsta.com\/dk\/blog\/installeres-phpmyadmin\/\">phpMyAdmin<\/a>, et visuelt open source-v\u00e6rkt\u00f8j, som giver dig mulighed for at administrere MySQL- og MariaDB-databaser ved hj\u00e6lp af en webbrowser.<\/p>\n<figure style=\"width: 1230px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/phpMyAdmin-tool.png\" alt=\"phpMyAdmin administrationsv\u00e6rkt\u00f8j\" width=\"1230\" height=\"573\"><figcaption class=\"wp-caption-text\">phpMyAdmin<\/figcaption><\/figure>\n<p>For at f\u00e5 adgang til phpMyAdmin skal du installere enten <a href=\"https:\/\/kinsta.com\/blog\/mamp-alternative\/#2-wampserver\">WAMPServer<\/a> eller <a href=\"https:\/\/kinsta.com\/blog\/mamp-alternative\/#3-xampp\">XAMPP<\/a>. Disse serverpakker leveres forudinstalleret med phpMyAdmin, MySQL og MariaDB &#8211; alt det, du skal f\u00f8lge i denne vejledning. (XAMPP kan k\u00f8re p\u00e5 Windows, macOS og Linux).<\/p>\n<p>Hvis du ikke har phpMyAdmin, skal du ikke bekymre dig. Artiklen indeholder de kommandoer, du kan k\u00f8re p\u00e5 din terminal for at replikere de samme handlinger p\u00e5 MySQL og MariaDB.<\/p>\n<h2>Ud med MySQL<\/h2>\n<p>Start med at oprette en backup af din m\u00e5ldatabase i MySQL. Start din MySQL-server, og log ind p\u00e5 din MySQL-database med phpMyAdmin. Fra WAMP eller XAMPP kan du f\u00e5 adgang til phpMyAdmin ved at navigere til <a href=\"http:\/\/localhost\/phpMyAdmin\">http:\/\/localhost\/phpMyAdmin\/<\/a>.<\/p>\n<figure style=\"width: 572px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/MySQL-login.png\" alt=\"phpMyAdmin log-in side for MySQL server\" width=\"572\" height=\"494\"><figcaption class=\"wp-caption-text\">phpMyAdmin log-in-side<\/figcaption><\/figure>\n<p>N\u00e5r du er i MySQL-milj\u00f8et, skal du klikke p\u00e5 den database, du \u00f8nsker at tage backup af. I dette eksempel eksporteres en <a href=\"https:\/\/kinsta.com\/dk\/blog\/wordpress-databasen\/\">WordPress-database<\/a>, som indeholder de typiske WordPress-tabeller.<\/p>\n<figure style=\"width: 703px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/wordpress-database-phpmyadmin-mysql.png\" alt=\"WordPress-database p\u00e5 phpMyAdmin ved hj\u00e6lp af MySQL\" width=\"703\" height=\"402\"><figcaption class=\"wp-caption-text\">WordPress-database p\u00e5 phpMyAdmin<\/figcaption><\/figure>\n<p>Klik p\u00e5 fanen <strong>Eksporter<\/strong> over tabellerne, og v\u00e6lg derefter SQL-formatet. Du vil importere den til MariaDB senere.<\/p>\n<figure style=\"width: 535px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/wordpress-database-export-tab.png\" alt=\"Eksport af WordPress-database i SQL-format\" width=\"535\" height=\"360\"><figcaption class=\"wp-caption-text\">Eksport af WordPress-database i SQL-format<\/figcaption><\/figure>\n<p>Klik p\u00e5 <strong>Go <\/strong>for at downloade databasebackuppen til din lokale computer som en SQL-fil. Alternativt, hvis du ikke har phpMyAdmin eller foretr\u00e6kker at bruge kommandoer, kan du bruge f\u00f8lgende kommando til at dumpe din database til en SQL-fil. Udskift <code>your-name<\/code> og <code>your-pass<\/code> med dit database-brugernavn og dit password.<\/p>\n<pre><code class=\"language-sql\"> $ mysqldump --user=your-name --password=\"your-pass\" wordpress &gt; wordpress.sql<\/code><\/pre>\n<p>I dette tilf\u00e6lde opretter kommandoen en backup-fil med navnet <strong>wordpress.sql<\/strong>, der indeholder SQL-koden fra <a href=\"https:\/\/kinsta.com\/dk\/blog\/wordpress-databasen\/\">WordPress-databasen<\/a>.<\/p>\n<p>Til sidst skal du afinstallere MySQL.<\/p>\n<h2>I med MariaDB<\/h2>\n<p>F\u00f8rst skal du sikre dig, at du har MariaDB <a href=\"https:\/\/www.mariadbtutorial.com\/getting-started\/install-mariadb\/\" target=\"_blank\" rel=\"noopener noreferrer\">installeret p\u00e5 din lokale maskine<\/a>. Du beh\u00f8ver ikke at g\u00f8re dette manuelt, hvis du bruger WAMP, XAMPP eller lignende distributioner, der er pr\u00e6installeret med MariaDB.<\/p>\n<p>Nu er det tid til at indl\u00e6se backup MySQL-filen i MariaDB. Stop MySQL-serveren fra dit serveradministrationspanel. Log ud af MySQL-serveren og ind p\u00e5 din MariaDB-server (skift blot fra MySQL til MariaDB, n\u00e5r du logger ind p\u00e5 phpMyAdmin).<\/p>\n<figure style=\"width: 494px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/phpmyadmin-mariadb-login-page.png\" alt=\"phpMyAdmin log-in-side for MariaDB-server\" width=\"494\" height=\"474\"><figcaption class=\"wp-caption-text\">phpMyAdmin log-in-side for MariaDB-server<\/figcaption><\/figure>\n<p>Opret en ny database p\u00e5 administrationspanelet. Det g\u00f8r du i phpMyAdmin ved at klikke p\u00e5 <strong>New<\/strong>, give din database et navn og klikke p\u00e5 <strong>Create<\/strong>.<\/p>\n<figure style=\"width: 781px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/wordpress-database-phpmyadmin-mariadb.png\" alt=\"WordPress-database p\u00e5 phpMyAdmin ved hj\u00e6lp af MariaDB\" width=\"781\" height=\"369\"><figcaption class=\"wp-caption-text\">WordPress-database p\u00e5 phpMyAdmin ved hj\u00e6lp af MariaDB<\/figcaption><\/figure>\n<p>Klik p\u00e5 den nye database, du lige har oprettet, og klik derefter p\u00e5 fanen <strong>Import<\/strong> \u00f8verst og importer backup-filen ved at klikke p\u00e5 <strong>Choose\u00a0file<\/strong> eller <strong>Browse<\/strong>.<\/p>\n<figure style=\"width: 694px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/import-database.png\" alt=\"Import af WordPress-database\" width=\"694\" height=\"575\"><figcaption class=\"wp-caption-text\">Import af WordPress-database<\/figcaption><\/figure>\n<p>Klik p\u00e5 <strong>Go<\/strong>\u00a0for at indl\u00e6se filen. Processen kan tage et stykke tid, og hvis alt g\u00e5r godt, informerer phpMyAdmin dig om, at foresp\u00f8rgslen var vellykket.<\/p>\n<figure style=\"width: 510px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/success-message.png\" alt=\"Meddelelse om succes\" width=\"510\" height=\"42\"><figcaption class=\"wp-caption-text\">Meddelelse om succes<\/figcaption><\/figure>\n<p>Hvis du i stedet vil bruge kommandolinjen, skal du f\u00f8lge disse trin.<\/p>\n<p>Log ind p\u00e5 din MariaDB-server, og opret den nye database som f\u00f8lger:<\/p>\n<pre><code class=\"language-sql\">$ mysql --user=your-name --password=\"your-pass\" -e  \"CREATE DATABASE wordpress\";<\/code><\/pre>\n<p>Indl\u00e6s backup-filen i MariaDB.<\/p>\n<pre><code class=\"language-mysql\">$ mysql --user=your-name --password=\"your-pass\" --database=wordpress &lt; wordpress.sql<\/code><\/pre>\n<p>N\u00e5r du har importeret filerne fra MySQL til MariaDB, bliver mark\u00f8ren aktiv igen.<\/p>\n<h2>S\u00e5dan opdaterer du dit WordPress-websted<\/h2>\n<p>N\u00e5r du har flyttet fra MySQL til MariaDB, er det tid til at f\u00e5 dit WordPress-websted til at begynde at bruge den nye database. For at opn\u00e5 dette skal du blot opdatere dit hjemmesides <strong>wp-config.php<\/strong>-fil med de nye databaseoplysninger:<\/p>\n<pre><code class=\"language-mysql\">\/\/ ** MariaDB settings** \/\/\n\ndefine('DB_NAME', 'database_name_here');\ndefine('DB_USER', 'database_username_here');\ndefine('DB_PASSWORD', 'database_password_here');\ndefine('DB_HOST', 'localhost');\ndefine('DB_CHARSET', 'utf8');\n\n\/** The Database Collate type. Don't change this if in doubt. *\/\ndefine('DB_COLLATE', '');<\/code><\/pre>\n<p>N\u00e5r du har gemt filen, vil WordPress-webstedet begynde at hente data fra din nye database.<\/p>\n<figure style=\"width: 758px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kinsta.com\/wp-content\/uploads\/2023\/03\/shown-live.png\" alt=\"Opdateret WordPress-websted\" width=\"758\" height=\"304\"><figcaption class=\"wp-caption-text\">Opdateret WordPress-websted<\/figcaption><\/figure>\n<h2>MariaDB og Kinsta<\/h2>\n<p>MariaDB er en af de hurtigst innovative DBMS-platforme, og denne tendens vil sandsynligvis forts\u00e6tte i en overskuelig fremtid. Hos Kinsta tror vi p\u00e5 MariaDB&#8217;s styrke. Derfor <a href=\"https:\/\/docs.sevalla.com\/databases\/manage-data\/database-studio\">bruger vi MariaDB<\/a> som en del af vores performance-drevne serverstack for at levere fremragende serverydelse. Vores hostingabonnementer giver dig mulighed for at udnytte den bedste og hurtigste teknologi, der findes.<\/p>\n<p>Kinsta g\u00f8r det nemt at bruge MariaDB. Du beh\u00f8ver ikke at bekymre dig om at opdatere din databasesoftware, rense databasen eller kontrollere for fejl. Vi tager os af alle disse nitty-gritty opgaver for dig, s\u00e5 du kan fokusere p\u00e5 at skabe det bedste indhold til brugerne af dit websted.<\/p>\n\n<h2>Oversigt<\/h2>\n<p>At migrere fra MySQL til MariaDB er en simpel proces. Kort sagt skal du tage backup af din database og afinstallere MySQL, derefter installere MariaDB og importere din database backup.<\/p>\n<p>Husk, at du kan st\u00f8de p\u00e5 nogle problemer, mens du migrerer fra MySQL til MariaDB. For eksempel kan du f\u00e5 en fejl, hvis skemaet i MySQL ikke passer til skemaet i MariaDB. S\u00f8rg ogs\u00e5 for at k\u00f8re <code>mysql_upgrade<\/code>, n\u00e5r du migrerer fra en version til en anden. I de fleste tilf\u00e6lde er l\u00f8sningen p\u00e5 migrationsproblemer at opgradere begge databaser til deres nyeste versioner, f\u00f8r du pr\u00f8ver igen.<\/p>\n<p>Efterh\u00e5nden som MariaDB forts\u00e6tter med at forny sig, vil den sandsynligvis blive mindre kompatibel med MySQL p\u00e5 et rudiment\u00e6rt niveau. S\u00e5 hvis du bruger MySQL og overvejer at flytte til MariaDB p\u00e5 grund af de ekstra fordele, anbefaler vi, at du g\u00f8r det s\u00e5 hurtigt som muligt.<\/p>\n<p>Med Kinstas databasehosting-tjenester kan du <a href=\"https:\/\/sevalla.com\/database-hosting\/\">oprette en database<\/a> og bruge hurtige, sikre interne forbindelser.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hvis du overvejer at migrere fra MySQL til MariaDB, er der gode argumenter for at skifte. Som en af de f\u00f8rste DBMS-platforme (database management system) har &#8230;<\/p>\n","protected":false},"author":117,"featured_media":50574,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[718,754],"class_list":["post-50573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","topic-mysql-database","topic-wordpress-udvikling"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.6 (Yoast SEO v24.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>S\u00e5dan overf\u00f8res fra MySQL til MariaDB- Kinsta\u00ae<\/title>\n<meta name=\"description\" content=\"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"S\u00e5dan overf\u00f8res fra MySQL til MariaDB\" \/>\n<meta property=\"og:description\" content=\"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-09T13:17:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-24T09:16:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"3042\" \/>\n\t<meta property=\"og:image:height\" content=\"1521\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Salman Ravoof\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:description\" content=\"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@salmanravoof\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_dk\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salman Ravoof\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\"},\"author\":{\"name\":\"Salman Ravoof\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\"},\"headline\":\"S\u00e5dan overf\u00f8res fra MySQL til MariaDB\",\"datePublished\":\"2023-05-09T13:17:55+00:00\",\"dateModified\":\"2023-08-24T09:16:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\"},\"wordCount\":1260,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\",\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\",\"url\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\",\"name\":\"S\u00e5dan overf\u00f8res fra MySQL til MariaDB- Kinsta\u00ae\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\",\"datePublished\":\"2023-05-09T13:17:55+00:00\",\"dateModified\":\"2023-08-24T09:16:14+00:00\",\"description\":\"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#breadcrumb\"},\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\",\"contentUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg\",\"width\":3042,\"height\":1521},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/dk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL-database\",\"item\":\"https:\/\/kinsta.com\/dk\/emner\/mysql-database\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"S\u00e5dan overf\u00f8res fra MySQL til MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/dk\/#website\",\"url\":\"https:\/\/kinsta.com\/dk\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Hurtig, sikker, premium hostingl\u00f8sninger\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/dk\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"da-DK\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/dk\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/dk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/\",\"https:\/\/x.com\/kinsta_dk\",\"https:\/\/www.instagram.com\/kinstahosting\/\",\"https:\/\/www.linkedin.com\/company\/kinsta\/\",\"https:\/\/www.pinterest.com\/kinstahosting\/\",\"https:\/\/www.youtube.com\/c\/Kinsta\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\",\"name\":\"Salman Ravoof\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/kinsta.com\/dk\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g\",\"caption\":\"Salman Ravoof\"},\"description\":\"Salman Ravoof is a self-taught web developer, writer, creator, and a huge admirer of Free and Open Source Software (FOSS). Besides tech, he's excited by science, philosophy, photography, arts, cats, and food. Learn more about him on his website, and connect with Salman on Twitter.\",\"sameAs\":[\"https:\/\/salmanravoof.com\",\"https:\/\/www.linkedin.com\/in\/salman-ravoof-5a749133\/\",\"https:\/\/x.com\/salmanravoof\"],\"url\":\"https:\/\/kinsta.com\/dk\/blog\/author\/salmanravoof\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB- Kinsta\u00ae","description":"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.","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:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/","og_locale":"da_DK","og_type":"article","og_title":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB","og_description":"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.","og_url":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/","article_published_time":"2023-05-09T13:17:55+00:00","article_modified_time":"2023-08-24T09:16:14+00:00","og_image":[{"width":3042,"height":1521,"url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","type":"image\/jpeg"}],"author":"Salman Ravoof","twitter_card":"summary_large_image","twitter_description":"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.","twitter_image":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","twitter_creator":"@salmanravoof","twitter_site":"@kinsta_dk","twitter_misc":{"Skrevet af":"Salman Ravoof","Estimeret l\u00e6setid":"8 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/"},"author":{"name":"Salman Ravoof","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987"},"headline":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB","datePublished":"2023-05-09T13:17:55+00:00","dateModified":"2023-08-24T09:16:14+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/"},"wordCount":1260,"commentCount":0,"publisher":{"@id":"https:\/\/kinsta.com\/dk\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","inLanguage":"da-DK","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/","url":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/","name":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB- Kinsta\u00ae","isPartOf":{"@id":"https:\/\/kinsta.com\/dk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","datePublished":"2023-05-09T13:17:55+00:00","dateModified":"2023-08-24T09:16:14+00:00","description":"MariaDB er et nyere, letv\u00e6gts DBMS, der tilbyder forbedret ydeevne og mere avancerede funktioner. L\u00e6r, hvordan du migrerer fra MySQL til MariaDB.","breadcrumb":{"@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#primaryimage","url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","contentUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/05\/mysql-to-mariadb.jpg","width":3042,"height":1521},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/dk\/blog\/mysql-til-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/dk\/"},{"@type":"ListItem","position":2,"name":"MySQL-database","item":"https:\/\/kinsta.com\/dk\/emner\/mysql-database\/"},{"@type":"ListItem","position":3,"name":"S\u00e5dan overf\u00f8res fra MySQL til MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/dk\/#website","url":"https:\/\/kinsta.com\/dk\/","name":"Kinsta\u00ae","description":"Hurtig, sikker, premium hostingl\u00f8sninger","publisher":{"@id":"https:\/\/kinsta.com\/dk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/dk\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/dk\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/dk\/","logo":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/dk\/wp-content\/uploads\/sites\/12\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/dk\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Kinsta-Danmark-122855885298660\/","https:\/\/x.com\/kinsta_dk","https:\/\/www.instagram.com\/kinstahosting\/","https:\/\/www.linkedin.com\/company\/kinsta\/","https:\/\/www.pinterest.com\/kinstahosting\/","https:\/\/www.youtube.com\/c\/Kinsta"]},{"@type":"Person","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987","name":"Salman Ravoof","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/kinsta.com\/dk\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0c5885f75cb78473fb7408e5e49ad190?s=96&d=mm&r=g","caption":"Salman Ravoof"},"description":"Salman Ravoof is a self-taught web developer, writer, creator, and a huge admirer of Free and Open Source Software (FOSS). Besides tech, he's excited by science, philosophy, photography, arts, cats, and food. Learn more about him on his website, and connect with Salman on Twitter.","sameAs":["https:\/\/salmanravoof.com","https:\/\/www.linkedin.com\/in\/salman-ravoof-5a749133\/","https:\/\/x.com\/salmanravoof"],"url":"https:\/\/kinsta.com\/dk\/blog\/author\/salmanravoof\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/50573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/comments?post=50573"}],"version-history":[{"count":6,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/50573\/revisions"}],"predecessor-version":[{"id":50721,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/posts\/50573\/revisions\/50721"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/pt"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/fr"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/de"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/nl"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/es"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/translations\/dk"},{"href":"https:\/\/kinsta.com\/dk\/wp-json\/kinsta\/v1\/posts\/50573\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/media\/50574"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/media?parent=50573"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/tags?post=50573"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/dk\/wp-json\/wp\/v2\/topic?post=50573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}