{"id":2461,"date":"2013-02-15T15:53:58","date_gmt":"2013-02-15T15:53:58","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/15\/340-find-db-name\/"},"modified":"2023-05-11T17:30:02","modified_gmt":"2023-05-11T21:30:02","slug":"find-opencart-db-name","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/","title":{"rendered":"How to find your database name for OpenCart 1.5"},"content":{"rendered":"<p>When working with ecommerce programs such as OpenCart, the vast majority of features and settings are taken care of in the administrative dashboard. There will come a time, however, when you will need to access or interact with the database directly, most often through some sort of troubleshooting. When this happens, you will need to know the exact database name that your OpenCart installation uses in order to interact. Working with the wrong database will not help your OpenCart application and could break another application as well. The following steps will guide you in how to locate the correct database name for your OpenCart application.<\/p>\n<h2>Finding the database name for your OpenCart application<\/h2>\n<ol class=\"article_list\">\n<li>First, <a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\" target=\"_blank\" rel=\"noopener noreferrer\">log into your cPanel<\/a> dashboard.<\/li>\n<li>Once inside the cPanel, you will need to <a href=\"\/support\/edu\/cpanel\/using-file-manager-in-cpanel\/\" target=\"_blank\" rel=\"noopener noreferrer\">enter the File Manager<\/a>.<\/li>\n<li>After entering the <em>File Manager<\/em>, navigate to the root folder for your OpenCart store. In our example, the folder is named <em>opencart<\/em> and is under the <em>public_html<\/em> root folder. This makes the folder path <em>public_html\/opencart.<\/em><\/li>\n<li>Under the root folder for your OpenCart store, locate and enter the folder named <strong>admin<\/strong>.<\/li>\n<li>Once inside the <em>admin<\/em> folder, look for the file named <strong>config.php<\/strong> file. To open the file, highlight it and click on the <strong>Edit<\/strong> icon located in the toolbar across the top.<br>\n<a href=\"\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"790\" height=\"498\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\" class=\"optimized-lcp-image\" alt=\"click edit toolbar button\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png 790w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01-300x189.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01-768x484.png 768w\"><\/a>\n<div style=\"clear: both;\"><\/div>\n<\/li>\n<li>Once you open the file you will see many settings. Look for the line of code with DB_DATABASE in it. You will see the database name in the right side of the code line. In our example, the database name would be <em>_opencrt1<\/em>. The prefix will always be your cPanel username, in this case it is <em>userna5.<\/em> You can see a sample line of code below:<code>define('DB_DATABASE', 'userna5_opencrt1');<\/code><\/li>\n<li>Be sure to write down the database name so you can remember it. Now you can locate the particular database to use for editing no matter how many you have in your account.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>When working with ecommerce programs such as OpenCart, the vast majority of features and settings are taken care of in the administrative dashboard. There will come a time, however, when you will need to access or interact with the database directly, most often through some sort of troubleshooting. When this happens, you will need to<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\"> Read More ><\/a><\/p>\n","protected":false},"author":8,"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],"tags":[],"class_list":["post-2461","post","type-post","status-publish","format-standard","hentry","category-opencart"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to find your database name for OpenCart 1.5 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn how to find the database name for your OpenCart application.\" \/>\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\/find-opencart-db-name\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to find your database name for OpenCart 1.5 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to find the database name for your OpenCart application.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\" \/>\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=\"2013-02-15T15:53:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-11T21:30:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\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\/find-opencart-db-name\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to find your database name for OpenCart 1.5\",\"datePublished\":\"2013-02-15T15:53:58+00:00\",\"dateModified\":\"2023-05-11T21:30:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\"},\"wordCount\":324,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\",\"articleSection\":[\"OpenCart\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\",\"name\":\"How to find your database name for OpenCart 1.5 | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\",\"datePublished\":\"2013-02-15T15:53:58+00:00\",\"dateModified\":\"2023-05-11T21:30:02+00:00\",\"description\":\"Learn how to find the database name for your OpenCart application.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png\",\"width\":790,\"height\":498,\"caption\":\"click edit toolbar button\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to find your database name for OpenCart 1.5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; 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\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to find your database name for OpenCart 1.5 | InMotion Hosting","description":"Learn how to find the database name for your OpenCart application.","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\/find-opencart-db-name\/","og_locale":"en_US","og_type":"article","og_title":"How to find your database name for OpenCart 1.5 | InMotion Hosting","og_description":"Learn how to find the database name for your OpenCart application.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-15T15:53:58+00:00","article_modified_time":"2023-05-11T21:30:02+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to find your database name for OpenCart 1.5","datePublished":"2013-02-15T15:53:58+00:00","dateModified":"2023-05-11T21:30:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/"},"wordCount":324,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png","articleSection":["OpenCart"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/","name":"How to find your database name for OpenCart 1.5 | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png","datePublished":"2013-02-15T15:53:58+00:00","dateModified":"2023-05-11T21:30:02+00:00","description":"Learn how to find the database name for your OpenCart application.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/cpanel_christopherm_cpanel_ocartdb_Selection_01.png","width":790,"height":498,"caption":"click edit toolbar button"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/find-opencart-db-name\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to find your database name for OpenCart 1.5"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; 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\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":81,"name":"OpenCart","slug":"opencart","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/opencart\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2461","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2461"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2461\/revisions"}],"predecessor-version":[{"id":104493,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2461\/revisions\/104493"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}