{"id":139,"date":"2023-12-29T11:26:21","date_gmt":"2023-12-29T11:26:21","guid":{"rendered":"https:\/\/hostup.se\/support\/?p=139"},"modified":"2023-12-29T11:26:22","modified_gmt":"2023-12-29T11:26:22","slug":"importera-en-databas","status":"publish","type":"post","link":"https:\/\/hostup.se\/support\/importera-en-databas\/","title":{"rendered":"Importera en databas"},"content":{"rendered":"\n<p>Om du redan har en sida som du vill flytta \u00f6ver, detta fall en WordPress sida s\u00e5 beh\u00f6ver du importera dess databas. Oftast g\u00e5r det bra att importera denna via phpmyadmin men den har n\u00e4mligen en ganska s\u00e5 stor begr\u00e4nsning &#8211; upload limit. Databas filerna f\u00e5r allts\u00e5 inte vara \u00f6ver en viss storlek.<\/p>\n\n\n\n<p>S\u00e5 h\u00e4r kan du importera alla slags databas filer, stora som sm\u00e5. De kan vara flera GB stora och detta tillv\u00e4gag\u00e5ngss\u00e4tt kommer alltid att fungera.<\/p>\n\n\n\n<p>F\u00f6rst beh\u00f6ver du \u00f6ppna upp ett terminal f\u00f6nster. Jag rekommenderar att du&nbsp;<strong>g\u00f6r detta med SSH<\/strong><\/p>\n\n\n\n<p>Sedan beh\u00f6ver du navigera till d\u00e4r du har laddat upp din databas fil. Om du inte redan har laddat upp den s\u00e5 rekommenderar jag att du<strong>&nbsp;i FTP laddar upp den till din hem kategori, \/home\/anv\u00e4ndarnamn<\/strong>.<\/p>\n\n\n\n<p>Navigera till din hemkatalog med hj\u00e4lp av f\u00f6ljande kommando:&nbsp;<strong>cd \/home\/anv\u00e4ndarnamn<\/strong>.<\/p>\n\n\n\n<p>V\u00e4l d\u00e4r kan du lista alla filer med kommandot:&nbsp;<strong>ls -lh<\/strong><\/p>\n\n\n\n<p>Du importerar din databasfil med kommandot:&nbsp;<strong>mysql DBNAME &lt; \/path\/to\/sqlfile<\/strong><\/p>\n\n\n\n<p>D\u00e4r DBNAME \u00e4r en databas som du beh\u00f6ver att skapa om du inte redan har gjort s\u00e5 under&nbsp;<strong>Databases &gt; MySQL Manager &gt; Create Database<\/strong><\/p>\n\n\n\n<p>Kommandot i detta exemplet blev:&nbsp;<strong>mysql namn_databasnamn &lt; \/home\/namn\/sqlfil.sql<\/strong><\/p>\n\r\n\t\t\t<div id=\"daexthefu-container\"\r\n\t\t\t\tclass=\"daexthefu-container daexthefu-layout-side-by-side daexthefu-alignment-left\"\r\n\t\t\t\tdata-post-id=\"139\">\r\n\r\n\t\t\t\t<div class=\"daexthefu-feedback\">\r\n\t\t\t\t\t<div class=\"daexthefu-text\">\r\n\t\t\t\t\t\t<h3 class=\"daexthefu-title\">Var den h\u00e4r artikeln hj\u00e4lpsam?<\/h3>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<div class=\"daexthefu-buttons-container\">\r\n\t\t\t\t\t\t<div class=\"daexthefu-buttons\">\r\n\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-yes daexthefu-button daexthefu-button-type-icon\" data-value=\"1\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>.happy-face-cls-1{fill:#c9c9c9;}.happy-face-cls-2{fill:#e1e1e1;}.happy-face-cls-3{fill:#676767;}<\/style>\r\n                    <\/defs>\r\n                    <g id=\"happy_face\">\r\n                        <circle class=\"happy-face-cls-1 daexthefu-icon-primary-color\" cx=\"24\" cy=\"24\" r=\"17\" \/>\r\n                        <path class=\"happy-face-cls-2 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <circle class=\"happy-face-cls-3 daexthefu-icon-secondary-color\" cx=\"18\" cy=\"22\" r=\"2\" \/>\r\n                        <circle class=\"happy-face-cls-3 daexthefu-icon-secondary-color\" cx=\"30\" cy=\"22\" r=\"2\" \/>\r\n                        <path class=\"happy-face-cls-3 daexthefu-icon-secondary-color\" d=\"m16.79,29c-1.19,0-1.89,1.31-1.25,2.32,1.77,2.81,4.9,4.68,8.47,4.68s6.7-1.87,8.47-4.68c.63-1.01-.06-2.32-1.25-2.32-3.67,0-10.76,0-14.43,0Z\" \/>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t<div class=\"daexthefu-no daexthefu-button daexthefu-button-type-icon\" data-value=\"0\">\r\n\t\t\t\t\r\n                <svg>\r\n                    <defs>\r\n                        <style>\r\n                            .sad-face-cls-1{fill:#c9c9c9;}.sad-face-cls-2{fill:#676767;}.sad-face-cls-3{fill:#e1e1e1;}.sad-face-cls-4{fill:#676767;}\r\n                        <\/style>\r\n                    <\/defs>\r\n                    <g id=\"sad_face\">\r\n                        <circle class=\"sad-face-cls-1 daexthefu-icon-primary-color\" cx=\"24\" cy=\"24\" r=\"17\" \/>\r\n                        <path class=\"sad-face-cls-3 daexthefu-icon-circle\" d=\"m24,3c11.58,0,21,9.42,21,21s-9.42,21-21,21S3,35.58,3,24,12.42,3,24,3m0-1C11.85,2,2,11.85,2,24s9.85,22,22,22,22-9.85,22-22S36.15,2,24,2h0Z\" \/>\r\n                        <circle class=\"sad-face-cls-4 daexthefu-icon-secondary-color\" cx=\"18\" cy=\"22\" r=\"2\" \/>\r\n                        <circle class=\"sad-face-cls-4 daexthefu-icon-secondary-color\" cx=\"30\" cy=\"22\" r=\"2\" \/>\r\n                        <path class=\"sad-face-cls-2 daexthefu-icon-secondary-color\" d=\"M16.9,34.5c-0.4,0-0.8-0.1-1.1-0.4c-0.6-0.6-0.6-1.5,0-2.1c2.2-2.2,5.1-3.4,8.1-3.4c3.1,0,6,1.2,8.1,3.4\r\n                        c0.6,0.6,0.6,1.5,0,2.1s-1.5,0.6-2.1,0c-1.6-1.6-3.7-2.5-6-2.5s-4.4,0.9-6,2.5C17.7,34.4,17.3,34.5,16.9,34.5z\" \/>\r\n                    <\/g>\r\n                <\/svg>\t\t\t<\/div>\r\n\r\n\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-comment\">\r\n\t\t\t\t\t<div class=\"daexthefu-comment-top-container\">\r\n\t\t\t\t\t\t<label id=\"daexthefu-comment-label\" class=\"daexthefu-comment-label\"><\/label>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-container\">\r\n\t\t\t\t\t\t\t\t<div id=\"daexthefu-comment-character-counter-number\"\r\n\t\t\t\t\t\t\t\t\tclass=\"daexthefu-comment-character-counter-number\"><\/div>\r\n\t\t\t\t\t\t\t\t<div class=\"daexthefu-comment-character-counter-text\"><\/div>\r\n\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\r\n\t\t\t\t\t<textarea id=\"daexthefu-comment-textarea\" class=\"daexthefu-comment-textarea\"\r\n\t\t\t\t\t\t\t\tplaceholder=\"Skriv ditt meddelande\"\r\n\t\t\t\t\t\t\t\tmaxlength=\"\r\n\t\t\t\t\t\t\t\t400\t\t\t\t\t\t\t\t\t\"><\/textarea>\r\n\t\t\t\t\t<div class=\"daexthefu-comment-buttons-container\">\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-submit daexthefu-button\">Skicka in<\/button>\r\n\t\t\t\t\t\t<button class=\"daexthefu-comment-cancel daexthefu-button\">Avbryt<\/button>\r\n\t\t\t\t\t<\/div>\r\n\t\t\t\t<\/div>\r\n\r\n\t\t\t\t<div class=\"daexthefu-successful-submission-text\">Tack f\u00f6r din feedback!<\/div>\r\n\r\n\t\t\t<\/div>\r\n\r\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>Om du redan har en sida som du vill flytta \u00f6ver, detta fall en WordPress sida s\u00e5 beh\u00f6ver du importera dess databas. Oftast g\u00e5r det bra att importera denna via phpmyadmin men den har n\u00e4mligen en ganska s\u00e5 stor begr\u00e4nsning &#8211; upload limit. Databas filerna f\u00e5r allts\u00e5 inte vara \u00f6ver en viss storlek. S\u00e5 h\u00e4r [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_helpful_status":1,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-139","post","type-post","status-publish","format-standard","hentry","category-webbhotell"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":1,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/posts\/139\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hostup.se\/support\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}