{"id":14490,"date":"2017-02-07T14:01:34","date_gmt":"2017-02-07T13:01:34","guid":{"rendered":"https:\/\/www.oderland.se\/support\/artikel\/hur-tar-jag-en-backup-av-min-databas\/"},"modified":"2026-02-13T16:31:50","modified_gmt":"2026-02-13T15:31:50","slug":"how-do-i-back-up-my-database","status":"publish","type":"ht_kb","link":"https:\/\/www.oderland.se\/support\/en\/artikel\/how-do-i-back-up-my-database\/","title":{"rendered":"How do I back up my database?"},"content":{"rendered":"\n

There are various ways to create a backup of a database, and in these instructions we describe two of the most common options.<\/p>\n\n\n\n

We automatically save backups of all data on all web hosting accounts<\/a>, Managed Servers<\/a> and Agency<\/a> services once per day via the backup tool Acronis. You may read more about the tool here<\/a>.
If you have a Managed Server and wish for us to save backups more often than once per day, contact us<\/a> and we’ll take it from there.<\/p>\n\n\n\n

phpMyAdmin<\/h2>\n\n\n\n

You can create a backup of your database by using phpMyAdmin, accessible via cPanel for your web hosting account.<\/p>\n\n\n\n

    \n
  1. Begin by logging on to cPanel<\/a>.<\/li>\n\n\n\n
  2. Then click the icon phpMyAdmin<\/code> under Databases<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  3. Once you’ve entered phpMyAdmin, you will see a list of your databases to the left. Click the one you’d like to back up.<\/li>\n\n\n\n
  4. Now, in the menu at the top of the page, click the tab Export<\/code>.
    \"\"<\/a><\/li>\n\n\n\n
  5. Finally, select the export method you want to use, either Quick<\/code> or Custom<\/code>. If you do not know that you must set any specific options for the export, use Quick<\/code>. You also need to choose export format; choose SQL<\/code> here. Then click Go<\/code> to create your backup.
    \"\"<\/a><\/li>\n<\/ol>\n\n\n\n

    SSH<\/h2>\n\n\n\n

    You can also create backups of your databases via SSH. To do this, firstly, you must connect to your account via SSH, and we have a set of instructions for that he<\/a>r<\/a>e<\/a>.<\/p>\n\n\n\n

    Once connected via SSH, run the following command to create a backup of your database:<\/p>\n\n\n\n

    mariadb-dump -u username -p'password' dbname > \/path\/to\/databasebackup.sql<\/pre>\n\n\n\n
    Replace username<\/code> with the database username, and password<\/code> with the correct password for the database user. Also, replace dbname<\/code> with the name of the database, and enter the correct path to where you want to save the backup.<\/p>\n\n\n\n
    Do not save the backup file in a folder accessible via the Internet. If you do, anyone could download your database. Instead, save the database file e.g.<\/em> in the document root of your account.<\/p>\n","protected":false},"excerpt":{"rendered":"
    There are various ways to create a backup of a database, and in these instructions we describe two of the most common options. phpMyAdmin You can create a backup of your database by using phpMyAdmin, accessible via cPanel for your web hosting account. SSH You can also create backups of…<\/p>\n","protected":false},"author":12,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[194],"ht-kb-tag":[],"class_list":["post-14490","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-backup-and-restore"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/comments?post=14490"}],"version-history":[{"count":15,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14490\/revisions"}],"predecessor-version":[{"id":24954,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb\/14490\/revisions\/24954"}],"wp:attachment":[{"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/media?parent=14490"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb-category?post=14490"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.oderland.se\/support\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=14490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}