{"id":43017,"date":"2019-05-29T14:54:18","date_gmt":"2019-05-29T18:54:18","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=43017"},"modified":"2022-06-17T11:36:32","modified_gmt":"2022-06-17T15:36:32","slug":"backup-opencart-database","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/","title":{"rendered":"Backup Your OpenCart Database in Admin Dashboard"},"content":{"rendered":"

Like using a SSL certificate<\/a>, backups are important to your OpenCart and web hosting security. Below we cover how to backup your OpenCart database in your admin dashboard<\/strong>.<\/p>\n

Backup Database<\/h2>\n
    \n
  1. Login OpenCart.<\/li>\n
  2. Under Settings<\/em>, select Maintenance<\/strong> and Backup \/ Restore<\/strong>.<\/li>\n
  3. Specify tables to backup and select Export<\/strong>.\n
    \"backup<\/a>
    <\/div>\n
    You can restore the .sql<\/em> file in the Restore<\/strong> tab.\n
    \"restore<\/a>
    <\/div><\/li>\n<\/ol>\n

    We recommend you complete and download a full cPanel backup<\/a> regurlarly. Learn more about automated cPanel backups<\/a> with VPS Hosting.<\/p>\n\n\n\n

    <\/p>\n","protected":false},"excerpt":{"rendered":"

    Like using a SSL certificate, backups are important to your OpenCart and web hosting security. Below we cover how to backup your OpenCart database in your admin dashboard. Backup Database Login OpenCart. Under Settings, select Maintenance and Backup \/ Restore. Specify tables to backup and select Export. You can restore the .sql file in the Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[81,573],"tags":[],"class_list":["post-43017","post","type-post","status-publish","format-standard","hentry","category-opencart","category-opencart-3"],"acf":[],"yoast_head":"\nBackup Your OpenCart Database in Admin Dashboard | InMotion Hosting<\/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:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup Your OpenCart Database in Admin Dashboard | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Like using a SSL certificate, backups are important to your OpenCart and web hosting security. Below we cover how to backup your OpenCart database in your admin dashboard. Backup Database Login OpenCart. Under Settings, select Maintenance and Backup \/ Restore. Specify tables to backup and select Export. You can restore the .sql file in the Read More >\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-29T18:54:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-17T15:36:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"Backup Your OpenCart Database in Admin Dashboard\",\"datePublished\":\"2019-05-29T18:54:18+00:00\",\"dateModified\":\"2022-06-17T15:36:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\"},\"wordCount\":83,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png\",\"articleSection\":[\"OpenCart\",\"OpenCart 3\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\",\"name\":\"Backup Your OpenCart Database in Admin Dashboard | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png\",\"datePublished\":\"2019-05-29T18:54:18+00:00\",\"dateModified\":\"2022-06-17T15:36:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup Your OpenCart Database in Admin Dashboard\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support & Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup Your OpenCart Database in Admin Dashboard | InMotion Hosting","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:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/","og_locale":"en_US","og_type":"article","og_title":"Backup Your OpenCart Database in Admin Dashboard | InMotion Hosting","og_description":"Like using a SSL certificate, backups are important to your OpenCart and web hosting security. Below we cover how to backup your OpenCart database in your admin dashboard. Backup Database Login OpenCart. Under Settings, select Maintenance and Backup \/ Restore. Specify tables to backup and select Export. You can restore the .sql file in the Read More >","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2019-05-29T18:54:18+00:00","article_modified_time":"2022-06-17T15:36:32+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png","type":"","width":"","height":""}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"Backup Your OpenCart Database in Admin Dashboard","datePublished":"2019-05-29T18:54:18+00:00","dateModified":"2022-06-17T15:36:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/"},"wordCount":83,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png","articleSection":["OpenCart","OpenCart 3"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/","name":"Backup Your OpenCart Database in Admin Dashboard | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png","datePublished":"2019-05-29T18:54:18+00:00","dateModified":"2022-06-17T15:36:32+00:00","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/images\/stories\/opencart-3\/opencart-backup-database.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/backup-opencart-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Backup Your OpenCart Database in Admin Dashboard"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support & Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/43017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=43017"}],"version-history":[{"count":5,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/43017\/revisions"}],"predecessor-version":[{"id":97898,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/43017\/revisions\/97898"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=43017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=43017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=43017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}