{"id":52715,"date":"2023-05-09T13:29:35","date_gmt":"2023-05-09T13:29:35","guid":{"rendered":"https:\/\/kinsta.com\/se\/?p=52715&preview=true&preview_id=52715"},"modified":"2023-09-21T10:11:49","modified_gmt":"2023-09-21T10:11:49","slug":"mysql-till-mariadb","status":"publish","type":"post","link":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/","title":{"rendered":"Hur man flyttar fr\u00e5n MySQL till MariaDB"},"content":{"rendered":"

Om du funderar p\u00e5 att flytta fr\u00e5n MySQL till MariaDB finns det goda sk\u00e4l till detta. MySQL \u00e4r en av de f\u00f6rsta plattformarna f\u00f6r databashanteringssystem (DBMS), och har dominerat branschen under l\u00e5ng tid. Den \u00e4r dessutom fortfarande anm\u00e4rkningsv\u00e4rt relevant.<\/p>\n

Organisationer flyttar dock l\u00e5ngsamt bort fr\u00e5n denna plattform. Detta beror exempelvis p\u00e5 dess l\u00e5ngsammare bearbetning och ineffektivitet vid hantering av komplexa data. M\u00e5nga av dessa organisationer v\u00e4nder sig till MariaDB.<\/p>\n

MariaDB \u00e4r ett nyare, l\u00e4ttviktigt DBMS som erbjuder f\u00f6rb\u00e4ttrad prestanda, mer banbrytande funktioner och st\u00f6rre kapacitet att hantera komplexa datam\u00e4ngder. J\u00e4mf\u00f6rt med MySQL<\/a> har MariaDB dessutom ett mer livligt community som h\u00e5ller sitt offentliga arkiv uppdaterade och g\u00f6r innovativa f\u00f6r\u00e4ndringar.<\/p>\n

Den h\u00e4r artikeln kommer att guida dig genom migreringen av dina data fr\u00e5n MySQL till MariaDB.<\/p>\n

<\/div><\/kinsta-auto-toc>\n

Hur man byter databas fr\u00e5n MySQL till MariaDB<\/h2>\n

Att migrera fr\u00e5n MySQL till MariaDB \u00e4r l\u00f6jligt enkelt. Du kan dela upp hela processen i tv\u00e5 viktiga steg:<\/p>\n

    \n
  1. S\u00e4kerhetskopiera din databas<\/a> i MySQL genom att dumpa den till en SQL-fil.<\/li>\n
  2. Logga sedan in p\u00e5 din MariaDB-server och ladda s\u00e4kerhetskopian f\u00f6r att skapa databasen.<\/li>\n<\/ol>\n

    MariaDB \u00e4r kompatibel med MySQL. Som ett resultat kommer du inte att ha n\u00e5gra problem med att migrera din databas.<\/p>\n

    Har du migrerat din databas fr\u00e5n MySQL till MariaDB och dubbelkontrollerat att tabellerna \u00e4r fullst\u00e4ndiga? D\u00e5 kan du sedan uppdatera din webbplats s\u00e5 att den h\u00e4mtar data fr\u00e5n MariaDB i st\u00e4llet f\u00f6r MySQL.<\/p>\n\n

    Krav<\/h3>\n

    Eftersom du vill migrera fr\u00e5n MySQL till MariaDB b\u00f6r du redan ha en MySQL-databas som inneh\u00e5ller data som du vill flytta.<\/p>\n

    Du b\u00f6r naturligtvis \u00e4ven ha en kopia av MariaDB. \u00c4ven om detta inte \u00e4r ett krav s\u00e5 anv\u00e4nder den h\u00e4r handledningen phpMyAdmin<\/a>. Det \u00e4r ett visuellt verktyg med \u00f6ppen k\u00e4llkod som l\u00e5ter dig administrera MySQL- och MariaDB-databaser med hj\u00e4lp av en webbl\u00e4sare.<\/p>\n

    \"phpMyAdmin\"
    phpMyAdmin<\/figcaption><\/figure>\n

    F\u00f6r att f\u00e5 tillg\u00e5ng till phpMyAdmin installerar du antingen WAMPServer<\/a> eller XAMPP<\/a>. Dessa serverpaket levereras f\u00f6rinstallerade med phpMyAdmin, MySQL och MariaDB. Det \u00e4r allt som du beh\u00f6ver f\u00f6r att f\u00f6lja den h\u00e4r handledningen. (XAMPP kan k\u00f6ras p\u00e5 Windows, macOS och Linux).<\/p>\n

    Om du inte har phpMyAdmin beh\u00f6ver du inte oroa dig. Artikeln inneh\u00e5ller dessutom de kommandon som du kan k\u00f6ra i din terminal f\u00f6r att replikera samma \u00e5tg\u00e4rder p\u00e5 MySQL och MariaDB.<\/p>\n

    Ut med MySQL<\/h2>\n

    B\u00f6rja med att skapa en s\u00e4kerhetskopia av m\u00e5ldatabasen i MySQL. Starta din MySQL-server och logga in p\u00e5 din MySQL-databas med phpMyAdmin. Fr\u00e5n WAMP eller XAMPP kan du komma \u00e5t phpMyAdmin genom att navigera till http:\/\/localhost\/phpMyAdmin\/<\/a>.<\/p>\n

    \"Inloggningssida
    Inloggningssida f\u00f6r phpMyAdmin<\/figcaption><\/figure>\n

    N\u00e4r du \u00e4r inne i MySQL-milj\u00f6n klickar du p\u00e5 den databas som du vill s\u00e4kerhetskopiera. Det h\u00e4r exemplet exporterar en WordPress-databas<\/a> som inneh\u00e5ller de typiska WordPress-tabellerna.<\/p>\n

    \"WordPress-databas
    WordPress-databas i phpMyAdmin<\/figcaption><\/figure>\n

    Klicka p\u00e5 fliken Exportera<\/strong> ovanf\u00f6r tabellerna och v\u00e4lj sedan SQL-formatet. Du kommer sedan att importera den till MariaDB.<\/p>\n

    \"Exportera
    Exportera WordPress-databasen i SQL-format<\/figcaption><\/figure>\n

    Klicka p\u00e5 K\u00f6r\u00a0<\/strong>f\u00f6r att ladda ner databasens s\u00e4kerhetskopia till din lokala dator som en SQL-fil. Saknar du phpMyAdmin eller f\u00f6redrar att anv\u00e4nda kommandon? D\u00e5 kan du \u00e4ven anv\u00e4nda f\u00f6ljande kommando f\u00f6r att dumpa din databas till en SQL-fil. Ers\u00e4tt your-name<\/code> och your-pass<\/code> med ditt anv\u00e4ndarnamn och l\u00f6senord f\u00f6r databasen.<\/p>\n

     $ mysqldump --user=your-name --password=\"your-pass\" wordpress > wordpress.sql<\/code><\/pre>\n
    I det h\u00e4r fallet skapar kommandot en s\u00e4kerhetskopierings-fil som heter wordpress.sql<\/strong> och som inneh\u00e5ller SQL-koden fr\u00e5n WordPress-databasen<\/a>.<\/p>\n
    Slutligen avinstallerar du MySQL.<\/p>\n
    In med MariaDB<\/h2>\n
    Se f\u00f6rst till att MariaDB \u00e4r installerat p\u00e5 din lokala dator<\/a>. Du beh\u00f6ver inte g\u00f6ra detta manuellt om du anv\u00e4nder WAMP, XAMPP eller liknande distribueringar som \u00e4r f\u00f6rinstallerade med MariaDB.<\/p>\n
    Nu \u00e4r det dags att ladda in MySQL\u2019s s\u00e4kerhetskopierings-fil i MariaDB. Stoppa MySQL-servern fr\u00e5n din serveradministrat\u00f6rspanel. Logga ut fr\u00e5n MySQL-servern och in p\u00e5 din MariaDB-server (byt bara fr\u00e5n MySQL till MariaDB n\u00e4r du loggar in i phpMyAdmin).<\/p>\n
    \"phpMyAdmin-inloggningssida
    phpMyAdmin-inloggningssida f\u00f6r MariaDB-server<\/figcaption><\/figure>\n
    P\u00e5 adminpanelen skapar du en ny databas. Du g\u00f6r detta i phpMyAdmin genom att klicka p\u00e5 Ny<\/strong>.\u00a0Ge sedan din databas ett namn och klicka p\u00e5 Skapa<\/strong>.<\/p>\n
    \"WordPress-databas
    WordPress-databas i phpMyAdmin med MariaDB<\/figcaption><\/figure>\n
    Klicka p\u00e5 den nya databasen som du just har skapat, klicka d\u00e4refter p\u00e5 fliken Importera<\/strong> h\u00f6gst upp och importera s\u00e4kerhetskopian genom att klicka p\u00e5 alternativet V\u00e4lj fil<\/strong> eller Bl\u00e4ddra<\/strong>.<\/p>\n
    \"Importera
    Importera WordPress-databas<\/figcaption><\/figure>\n
    Klicka p\u00e5 K\u00f6r<\/strong> f\u00f6r att ladda filen. Processen kan ta ett tag, och om allt g\u00e5r bra informerar phpMyAdmin dig om att din f\u00f6rfr\u00e5gan lyckades.<\/p>\n
    \"Meddelande
    Meddelande om framg\u00e5ng<\/figcaption><\/figure>\n
    Om du vill anv\u00e4nda kommandoraden i st\u00e4llet s\u00e5 f\u00f6ljer du de h\u00e4r stegen.<\/p>\n
    Logga in p\u00e5 din MariaDB-server och skapa den nya databasen p\u00e5 f\u00f6ljande s\u00e4tt:<\/p>\n
    $ mysql --user=your-name --password=\"your-pass\" -e  \"CREATE DATABASE wordpress\";<\/code><\/pre>\n
    Ladda sedan in s\u00e4kerhetskopian i MariaDB.<\/p>\n
    $ mysql --user=your-name --password=\"your-pass\" --database=wordpress < wordpress.sql<\/code><\/pre>\n
    N\u00e4r du har lyckats importera filerna fr\u00e5n MySQL till MariaDB blir mark\u00f6ren aktiv igen.<\/p>\n
    Hur du uppdaterar din WordPress-webbplats<\/h2>\n
    N\u00e4r du har flyttat fr\u00e5n MySQL till MariaDB \u00e4r det dags att f\u00e5 din WordPress-webbplats att b\u00f6rja anv\u00e4nda den nya databasen. F\u00f6r att uppn\u00e5 detta beh\u00f6ver du bara uppdatera din webbplats fil wp-config.php<\/strong> med de nya databasuppgifterna:<\/p>\n
    \/\/ ** 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
    N\u00e4r du har sparat filen kommer WordPress-webbplatsen att b\u00f6rja h\u00e4mta data fr\u00e5n din nya databas.<\/p>\n
    \"Uppdaterad
    Uppdaterad WordPress-webbplats<\/figcaption><\/figure>\n
    MariaDB och Kinsta<\/h2>\n
    MariaDB \u00e4r en av de snabbaste innovativa DBMS-plattformarna. Den trenden kommer sannolikt att forts\u00e4tta under en l\u00e4ngre tid. Kinsta tror p\u00e5 kraften i MariaDB. Det \u00e4r d\u00e4rf\u00f6r som\u00a0vi anv\u00e4nder MariaDB<\/a> som en del av v\u00e5r prestandadrivna serverstack f\u00f6r att erbjuda en utm\u00e4rkt serverprestanda. V\u00e5ra hosting-planer g\u00f6r det dessutom m\u00f6jligt f\u00f6r dig att utnyttja den b\u00e4sta och snabbaste tekniken som finns tillg\u00e4nglig.<\/p>\n
    Kinsta g\u00f6r det enkelt att anv\u00e4nda MariaDB. Du beh\u00f6ver inte oroa dig f\u00f6r att uppdatera din databasprogramvara, rensa databasen eller kontrollera fel. Vi tar hand om alla dessa n\u00f6rderiuppgifter \u00e5t dig. Som ett resultat kan du fokusera p\u00e5 att skapa det b\u00e4sta inneh\u00e5llet f\u00f6r anv\u00e4ndarna p\u00e5 din webbplats.<\/p>\n\n
    Sammanfattning<\/h2>\n
    Att migrera fr\u00e5n MySQL till MariaDB \u00e4r en enkel process. I korthet m\u00e5ste du s\u00e4kerhetskopiera din databas och avinstallera MySQL. Du installerar sedan MariaDB och importerar din s\u00e4kerhetskopia av databasen.<\/p>\n
    Kom ih\u00e5g att du kan st\u00f6ta p\u00e5 vissa problem n\u00e4r du migrerar fr\u00e5n MySQL till MariaDB. Du kan exempelvis f\u00e5 ett fel om schemat i MySQL inte st\u00e4mmer \u00f6verens med schemat i MariaDB. Se dessutom till att du k\u00f6r mysql_upgrade<\/code> n\u00e4r du migrerar fr\u00e5n en version till en annan. I de flesta fall \u00e4r l\u00f6sningen p\u00e5 migreringsproblem att uppgradera b\u00e5da databaserna till deras senaste versioner innan du f\u00f6rs\u00f6ker igen.<\/p>\n
    I takt med att MariaDB forts\u00e4tter att f\u00f6rnya sig kommer det troligen att bli mindre kompatibelt med MySQL p\u00e5 en rudiment\u00e4r niv\u00e5. Om du anv\u00e4nder MySQL och funderar p\u00e5 att flytta till MariaDB f\u00f6r de extra f\u00f6rdelarna rekommenderar vi d\u00e4rf\u00f6r att du hellre g\u00f6r det f\u00f6rr \u00e4n senare.<\/p>\n
    Med Kinsta\u2019s tj\u00e4nster f\u00f6r databashosting kan du starta en databas<\/a> och anv\u00e4nda snabba, s\u00e4kra interna anslutningar.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Om du funderar p\u00e5 att flytta fr\u00e5n MySQL till MariaDB finns det goda sk\u00e4l till detta. MySQL \u00e4r en av de f\u00f6rsta plattformarna f\u00f6r databashanteringssystem (DBMS), …<\/p>\n","protected":false},"author":117,"featured_media":52716,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kinsta_gated_content":false,"_kinsta_gated_content_redirect":"","footnotes":""},"tags":[],"topic":[796,832],"class_list":["post-52715","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","topic-mysql-databas","topic-wordpress-utveckling"],"yoast_head":"\nHur du migrerar fr\u00e5n MySQL till MariaDB - Kinsta\u00ae<\/title>\n<meta name=\"description\" content=\"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till 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\/se\/blog\/mysql-till-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hur man flyttar fr\u00e5n MySQL till MariaDB\" \/>\n<meta property=\"og:description\" content=\"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"Kinsta\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/kinstasweden\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-09T13:29:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-09-21T10:11:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/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 \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@salmanravoof\" \/>\n<meta name=\"twitter:site\" content=\"@kinsta_se\" \/>\n<meta name=\"twitter:label1\" content=\"Skriven av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salman Ravoof\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ber\u00e4knad l\u00e4stid\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minuter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\"},\"author\":{\"name\":\"Salman Ravoof\",\"@id\":\"https:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\"},\"headline\":\"Hur man flyttar fr\u00e5n MySQL till MariaDB\",\"datePublished\":\"2023-05-09T13:29:35+00:00\",\"dateModified\":\"2023-09-21T10:11:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\"},\"wordCount\":1406,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/se\/#organization\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg\",\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\",\"url\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\",\"name\":\"Hur du migrerar fr\u00e5n MySQL till MariaDB - Kinsta\u00ae\",\"isPartOf\":{\"@id\":\"https:\/\/kinsta.com\/se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg\",\"datePublished\":\"2023-05-09T13:29:35+00:00\",\"dateModified\":\"2023-09-21T10:11:49+00:00\",\"description\":\"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.\",\"breadcrumb\":{\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage\",\"url\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg\",\"contentUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg\",\"width\":3042,\"height\":1521,\"caption\":\"Hur du migrerar fr\u00e5n MySQL till MariaDB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kinsta.com\/se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL-databas\",\"item\":\"https:\/\/kinsta.com\/se\/topics\/mysql-databas\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Hur man flyttar fr\u00e5n MySQL till MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kinsta.com\/se\/#website\",\"url\":\"https:\/\/kinsta.com\/se\/\",\"name\":\"Kinsta\u00ae\",\"description\":\"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar\",\"publisher\":{\"@id\":\"https:\/\/kinsta.com\/se\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kinsta.com\/se\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"sv-SE\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kinsta.com\/se\/#organization\",\"name\":\"Kinsta\",\"url\":\"https:\/\/kinsta.com\/se\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"contentUrl\":\"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg\",\"width\":500,\"height\":500,\"caption\":\"Kinsta\"},\"image\":{\"@id\":\"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/kinstasweden\/\",\"https:\/\/x.com\/kinsta_se\",\"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\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987\",\"name\":\"Salman Ravoof\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kinsta.com\/se\/#\/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\/se\/blog\/author\/salmanravoof\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hur du migrerar fr\u00e5n MySQL till MariaDB - Kinsta\u00ae","description":"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till 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\/se\/blog\/mysql-till-mariadb\/","og_locale":"sv_SE","og_type":"article","og_title":"Hur man flyttar fr\u00e5n MySQL till MariaDB","og_description":"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.","og_url":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/","og_site_name":"Kinsta\u00ae","article_publisher":"https:\/\/www.facebook.com\/kinstasweden\/","article_published_time":"2023-05-09T13:29:35+00:00","article_modified_time":"2023-09-21T10:11:49+00:00","og_image":[{"width":3042,"height":1521,"url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","type":"image\/jpeg"}],"author":"Salman Ravoof","twitter_card":"summary_large_image","twitter_description":"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.","twitter_image":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","twitter_creator":"@salmanravoof","twitter_site":"@kinsta_se","twitter_misc":{"Skriven av":"Salman Ravoof","Ber\u00e4knad l\u00e4stid":"7 minuter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#article","isPartOf":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/"},"author":{"name":"Salman Ravoof","@id":"https:\/\/kinsta.com\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987"},"headline":"Hur man flyttar fr\u00e5n MySQL till MariaDB","datePublished":"2023-05-09T13:29:35+00:00","dateModified":"2023-09-21T10:11:49+00:00","mainEntityOfPage":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/"},"wordCount":1406,"commentCount":0,"publisher":{"@id":"https:\/\/kinsta.com\/se\/#organization"},"image":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","inLanguage":"sv-SE","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/","url":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/","name":"Hur du migrerar fr\u00e5n MySQL till MariaDB - Kinsta\u00ae","isPartOf":{"@id":"https:\/\/kinsta.com\/se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage"},"image":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","datePublished":"2023-05-09T13:29:35+00:00","dateModified":"2023-09-21T10:11:49+00:00","description":"MariaDB \u00e4r ett nytt, l\u00e4ttviktigt DBMS med f\u00f6rb\u00e4ttrad prestanda och mer innovativa funktioner. L\u00e4r dig hur du migrerar fr\u00e5n MySQL till MariaDB.","breadcrumb":{"@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#primaryimage","url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","contentUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/05\/mysql-to-mariadb.jpg","width":3042,"height":1521,"caption":"Hur du migrerar fr\u00e5n MySQL till MariaDB"},{"@type":"BreadcrumbList","@id":"https:\/\/kinsta.com\/se\/blog\/mysql-till-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kinsta.com\/se\/"},{"@type":"ListItem","position":2,"name":"MySQL-databas","item":"https:\/\/kinsta.com\/se\/topics\/mysql-databas\/"},{"@type":"ListItem","position":3,"name":"Hur man flyttar fr\u00e5n MySQL till MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/kinsta.com\/se\/#website","url":"https:\/\/kinsta.com\/se\/","name":"Kinsta\u00ae","description":"Snabba, s\u00e4kra, premium hosting-l\u00f6sningar","publisher":{"@id":"https:\/\/kinsta.com\/se\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kinsta.com\/se\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"sv-SE"},{"@type":"Organization","@id":"https:\/\/kinsta.com\/se\/#organization","name":"Kinsta","url":"https:\/\/kinsta.com\/se\/","logo":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/","url":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","contentUrl":"https:\/\/kinsta.com\/se\/wp-content\/uploads\/sites\/9\/2023\/12\/kinsta-logo.jpeg","width":500,"height":500,"caption":"Kinsta"},"image":{"@id":"https:\/\/kinsta.com\/se\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/kinstasweden\/","https:\/\/x.com\/kinsta_se","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\/se\/#\/schema\/person\/9cafd2eedd617e640eeea4cf3a5fd987","name":"Salman Ravoof","image":{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kinsta.com\/se\/#\/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\/se\/blog\/author\/salmanravoof\/"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/52715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/users\/117"}],"replies":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/comments?post=52715"}],"version-history":[{"count":7,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/52715\/revisions"}],"predecessor-version":[{"id":52824,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/posts\/52715\/revisions\/52824"}],"alternate":[{"embeddable":true,"hreflang":"en","title":"English","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/en"},{"embeddable":true,"hreflang":"it","title":"Italian","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/it"},{"embeddable":true,"hreflang":"pt","title":"Portuguese","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/pt"},{"embeddable":true,"hreflang":"fr","title":"French","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/fr"},{"embeddable":true,"hreflang":"de","title":"German","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/de"},{"embeddable":true,"hreflang":"ja","title":"Japanese","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/jp"},{"embeddable":true,"hreflang":"nl","title":"Dutch","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/nl"},{"embeddable":true,"hreflang":"es","title":"Spanish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/es"},{"embeddable":true,"hreflang":"sv","title":"Swedish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/se"},{"embeddable":true,"hreflang":"da","title":"Danish","href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/translations\/dk"},{"href":"https:\/\/kinsta.com\/se\/wp-json\/kinsta\/v1\/posts\/52715\/tree"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/media\/52716"}],"wp:attachment":[{"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/media?parent=52715"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/tags?post=52715"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/kinsta.com\/se\/wp-json\/wp\/v2\/topic?post=52715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}