{"id":1290,"date":"2020-12-04T09:45:16","date_gmt":"2020-12-04T08:45:16","guid":{"rendered":"https:\/\/support.websupport.se\/?post_type=ht_kb&#038;p=1290"},"modified":"2021-12-20T10:41:26","modified_gmt":"2021-12-20T09:41:26","slug":"importera-databaser-storre-an-96-mb","status":"publish","type":"ht_kb","link":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/","title":{"rendered":"Importera databaser st\u00f6rre \u00e4n 96 MB"},"content":{"rendered":"\n<p>Importera databaser st\u00f6rre \u00e4n 96 MB<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Windows<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>Du beh\u00f6ver en MySQL-klient d\u00e4r du skapar en anslutning till databasservern och utf\u00f6r sj\u00e4lva importen. F\u00f6r enkla uppgifter r\u00e4cker freeware-programmet HeidiSQL, vars nuvarande version finns <a href=\"https:\/\/www.heidisql.com\/download.php\">h\u00e4r.<\/a>&nbsp;<\/p>\n\n\n\n<p>Efter installationen kan du skapa en anslutning till databasservern.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Du hittar all n\u00f6dv\u00e4ndig information i Webadmin i avsnittet &#8221;Databaser&#8221; f\u00f6r din webbplats.&nbsp;<\/li><li>I v\u00e5rt exempel ansluter vi till en databas med namnet <em>testdatabas<\/em> och anv\u00e4ndaren <em>testanvandare<\/em>, vilket \u00e4r MariaDB version 10.3 (och d\u00e4rmed anv\u00e4nder port 3313).&nbsp;<\/li><li>Efter att HeidiSQL har startat, klicka p\u00e5 Ny \u2192 Session i rotmappen, ange data f\u00f6r anslutning till DB och v\u00e4lj \u00d6ppna:<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"686\" height=\"393\" src=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png\" alt=\"\" class=\"wp-image-17741\" srcset=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png 686w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel-50x29.png 50w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel-60x34.png 60w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel-100x57.png 100w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<p>I det \u00f6ppna f\u00f6nstret kan du se databasen och dess tabeller, om n\u00e5gon finns:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1114\" height=\"753\" src=\"https:\/\/support.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2.png\" alt=\"\" class=\"wp-image-1292\" srcset=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2.png 1114w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-300x203.png 300w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-768x519.png 768w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-783x529.png 783w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-50x34.png 50w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-60x41.png 60w, https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2018\/12\/2-100x68.png 100w\" sizes=\"auto, (max-width: 1114px) 100vw, 1114px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Tryck p\u00e5 Arkiv \u2192 Ladda SQL-fil eller snabbtangenten Ctrl + O och v\u00e4lj den SQL-fil du vill importera.&nbsp;<\/li><li>I f\u00f6nstret som visas efter att du har valt filen klickar du p\u00e5 Run file (s) direkt och ser hur importen till v\u00e5ra servrar sker:<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Debian\/Ubuntu Linux<\/strong><\/h3>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>N\u00e4r det g\u00e4ller Linux \u00e4r det m\u00f6jligt att k\u00f6ra n\u00e4mnda HeidiSQL i vinmilj\u00f6n genom att f\u00f6lja stegen ovan. Det \u00e4r dock mer effektivt att anv\u00e4nda en konsol direkt fr\u00e5n MySQL, som du installerar efter att ha startat terminalen med kommandot:<\/p>\n\n\n\n<p><em>sudo apt-get install mysql-client-5.5<\/em><\/p>\n\n\n\n<p>Syntaxen f\u00f6r import \u00e4r som f\u00f6ljer:<\/p>\n\n\n\n<p><em>mysql -h adress.db.server -P port -p -u db_userdb_name &lt;\/path\/to\/sql\/file.sql<\/em><\/p>\n\n\n\n<p>I v\u00e5rt exempel skulle vi anv\u00e4nda kommandot:<\/p>\n\n\n\n<p><em>mysql -h&nbsp;<\/em><strong>mariadb103.websupport.se<\/strong><em>&nbsp;-P&nbsp;<\/em><strong>3313<\/strong><em>&nbsp;-p -u&nbsp;<\/em><strong>databasanvandare<\/strong><em>&nbsp;&lt;&nbsp;<\/em><strong>databas.sql<\/strong><\/p>\n\n\n\n<p>N\u00e4r du har angett l\u00f6senordet till databasen startar importen och eventuella fel skrivs ut i konsolen. N\u00e4r du \u00e4r klar kan du kontrollera inneh\u00e5llet i databasen antingen via konsolklienten eller med phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Importera databaser st\u00f6rre \u00e4n 96 MB Windows Du beh\u00f6ver en MySQL-klient d\u00e4r du skapar en anslutning till databasservern och utf\u00f6r sj\u00e4lva importen. F\u00f6r enkla uppgifter r\u00e4cker freeware-programmet HeidiSQL, vars nuvarande version finns h\u00e4r.&nbsp; Efter installationen kan du skapa en anslutning till databasservern.&nbsp; Du hittar all n\u00f6dv\u00e4ndig information i Webadmin i&#8230;<\/p>\n","protected":false},"author":8,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[41],"ht-kb-tag":[],"class_list":["post-1290","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>Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas<\/title>\n<meta name=\"description\" content=\"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.\" \/>\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\/importera-databaser-storre-an-96-mb\/\" \/>\n<meta property=\"og:locale\" content=\"sv_SE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas\" \/>\n<meta property=\"og:description\" content=\"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport kunskapsdatabas\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-20T09:41:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.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\/importera-databaser-storre-an-96-mb\/\",\"url\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/\",\"name\":\"Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas\",\"isPartOf\":{\"@id\":\"https:\/\/kunskap.websupport.se\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png\",\"datePublished\":\"2020-12-04T08:45:16+00:00\",\"dateModified\":\"2021-12-20T09:41:26+00:00\",\"description\":\"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.\",\"breadcrumb\":{\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#breadcrumb\"},\"inLanguage\":\"sv-SE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"sv-SE\",\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage\",\"url\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png\",\"contentUrl\":\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kunskap.websupport.se\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importera databaser st\u00f6rre \u00e4n 96 MB\"}]},{\"@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":"Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas","description":"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.","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\/importera-databaser-storre-an-96-mb\/","og_locale":"sv_SE","og_type":"article","og_title":"Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas","og_description":"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.","og_url":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/","og_site_name":"Websupport kunskapsdatabas","article_modified_time":"2021-12-20T09:41:26+00:00","og_image":[{"url":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.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\/importera-databaser-storre-an-96-mb\/","url":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/","name":"Importera databaser st\u00f6rre \u00e4n 96 MB - Websupport kunskapsdatabas","isPartOf":{"@id":"https:\/\/kunskap.websupport.se\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage"},"image":{"@id":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage"},"thumbnailUrl":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png","datePublished":"2020-12-04T08:45:16+00:00","dateModified":"2021-12-20T09:41:26+00:00","description":"Det finns flera s\u00e4tt att importera en st\u00f6rre databas. Antingen via ett externt databasprogram eller via SSH.","breadcrumb":{"@id":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#breadcrumb"},"inLanguage":"sv-SE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/"]}]},{"@type":"ImageObject","inLanguage":"sv-SE","@id":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#primaryimage","url":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png","contentUrl":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/kunskap.websupport.se\/kb\/importera-databaser-storre-an-96-mb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kunskap.websupport.se\/"},{"@type":"ListItem","position":2,"name":"Importera databaser st\u00f6rre \u00e4n 96 MB"}]},{"@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\/1290","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\/1290\/revisions"}],"predecessor-version":[{"id":20540,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb\/1290\/revisions\/20540"}],"wp:attachment":[{"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/media?parent=1290"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb-category?post=1290"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/wp-json\/wp\/v2\/ht-kb-tag?post=1290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}