{"id":25019,"date":"2026-07-09T11:44:47","date_gmt":"2026-07-09T09:44:47","guid":{"rendered":"https:\/\/kunskap.websupport.se\/?post_type=ht_kb&#038;p=25019"},"modified":"2026-07-09T11:44:50","modified_gmt":"2026-07-09T09:44:50","slug":"import-databases-larger-than-96-mb","status":"publish","type":"ht_kb","link":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/","title":{"rendered":"Import databases larger than 96 MB"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Import databases larger than 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 has-alpha-channel-opacity\" \/>\n\n\n\n<p class=\"wp-block-paragraph\">You need a MySQL client to create a connection to the database server and perform the import. For simple tasks, the free HeidiSQL program is sufficient; the current version is available <a href=\"https:\/\/www.heidisql.com\/download.php\">here.<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After installation, you can create a connection to the database server.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You&#8217;ll find all the necessary information in Webadmin in the &#8220;Databases&#8221; section for your site.<\/li>\n\n\n\n<li>In our example, we connect to a database named <em>testdatabas<\/em> with the user <em>testanvandare<\/em>, which is MariaDB version 10.3 (and uses port 3313).<\/li>\n\n\n\n<li>After HeidiSQL starts, click New \u2192 Session in the root folder, enter the database connection details, and select Open:<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><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 class=\"wp-block-paragraph\">In the open window, you can see the database and its tables, if any exist:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1114\" height=\"753\" src=\"https:\/\/kunskap.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\">\n<li>Go to File \u2192 Load SQL file or press Ctrl + O and select the SQL file you want to import.<\/li>\n\n\n\n<li>In the window that appears after selecting the file, click Run file(s) directly and watch the import to our servers begin:<\/li>\n<\/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 has-alpha-channel-opacity\" \/>\n\n\n\n<p class=\"wp-block-paragraph\">On Linux, you can run HeidiSQL in a Wine environment by following the steps above. However, it&#8217;s more efficient to use the MySQL console directly, which you install by running this command in the terminal:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>sudo apt-get install mysql-client-5.5<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The import syntax is as follows:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>mysql -h adress.db.server -P port -p -u db_userdb_name<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In our example, we would use this command:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>mysql -h <\/em><strong>mariadb103.websupport.se<\/strong><em> -P <\/em><strong>3313<\/strong><em> -p -u <\/em><strong>databasanvandare<\/strong><em> &lt; <\/em><strong>databas.sql<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After you enter the database password, the import starts and any errors are printed to the console. When done, you can verify the database contents either through the console client or with phpMyAdmin.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Import databases larger than 96 MB Windows You need a MySQL client to create a connection to the database server and perform the import. For simple tasks, the free HeidiSQL program is sufficient; the current version is available here. After installation, you can create a connection to the database server&#8230;.<\/p>\n","protected":false},"author":44,"template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[572],"ht-kb-tag":[],"class_list":["post-25019","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Import databases larger than 96 MB - Websupport kunskapsdatabas<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import databases larger than 96 MB - Websupport kunskapsdatabas\" \/>\n<meta property=\"og:description\" content=\"Import databases larger than 96 MB Windows You need a MySQL client to create a connection to the database server and perform the import. For simple tasks, the free HeidiSQL program is sufficient; the current version is available here. After installation, you can create a connection to the database server....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/\" \/>\n<meta property=\"og:site_name\" content=\"Websupport kunskapsdatabas\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-09T09:44:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"686\" \/>\n\t<meta property=\"og:image:height\" content=\"393\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/\",\"url\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/\",\"name\":\"Import databases larger than 96 MB - Websupport kunskapsdatabas\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kunskap.websupport.se\\\/app\\\/uploads\\\/sites\\\/4\\\/2021\\\/02\\\/heidisql_PpGToRsAel.png\",\"datePublished\":\"2026-07-09T09:44:47+00:00\",\"dateModified\":\"2026-07-09T09:44:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/kb\\\/import-databases-larger-than-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\\\/en\\\/kb\\\/import-databases-larger-than-96-mb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kunskap.websupport.se\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import databases larger than 96 MB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/\",\"name\":\"Websupport kunskapsdatabas\",\"description\":\"Websupport kunskapsdatabas\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kunskap.websupport.se\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import databases larger than 96 MB - Websupport kunskapsdatabas","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\/en\/kb\/import-databases-larger-than-96-mb\/","og_locale":"en_US","og_type":"article","og_title":"Import databases larger than 96 MB - Websupport kunskapsdatabas","og_description":"Import databases larger than 96 MB Windows You need a MySQL client to create a connection to the database server and perform the import. For simple tasks, the free HeidiSQL program is sufficient; the current version is available here. After installation, you can create a connection to the database server....","og_url":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/","og_site_name":"Websupport kunskapsdatabas","article_modified_time":"2026-07-09T09:44:50+00:00","og_image":[{"width":686,"height":393,"url":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/","url":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/","name":"Import databases larger than 96 MB - Websupport kunskapsdatabas","isPartOf":{"@id":"https:\/\/kunskap.websupport.se\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/#primaryimage"},"image":{"@id":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/#primaryimage"},"thumbnailUrl":"https:\/\/kunskap.websupport.se\/app\/uploads\/sites\/4\/2021\/02\/heidisql_PpGToRsAel.png","datePublished":"2026-07-09T09:44:47+00:00","dateModified":"2026-07-09T09:44:50+00:00","breadcrumb":{"@id":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-96-mb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kunskap.websupport.se\/en\/kb\/import-databases-larger-than-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\/en\/kb\/import-databases-larger-than-96-mb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kunskap.websupport.se\/"},{"@type":"ListItem","position":2,"name":"Import databases larger than 96 MB"}]},{"@type":"WebSite","@id":"https:\/\/kunskap.websupport.se\/en\/#website","url":"https:\/\/kunskap.websupport.se\/en\/","name":"Websupport kunskapsdatabas","description":"Websupport kunskapsdatabas","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kunskap.websupport.se\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb\/25019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/users\/44"}],"version-history":[{"count":2,"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb\/25019\/revisions"}],"predecessor-version":[{"id":25025,"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb\/25019\/revisions\/25025"}],"wp:attachment":[{"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/media?parent=25019"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb-category?post=25019"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/kunskap.websupport.se\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=25019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}