{"id":574,"date":"2013-02-19T18:15:02","date_gmt":"2013-02-19T23:15:02","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/19\/locate-db-name\/"},"modified":"2021-08-16T23:21:22","modified_gmt":"2021-08-17T03:21:22","slug":"locate-db-name","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/","title":{"rendered":"How to find your database name in osCommerce"},"content":{"rendered":"

Working with your osCommerce site you will be able to make most changes for settings within the administrative panel. However, you may need to access the database directly, most often during troubleshooting. To do this, you will need to know the exact database name. Below are the instructions that will help you find the exact database name your osCommerce application is using.<\/p>\n

Finding your database name in your osCommerce application<\/h2>\n
    \n
  1. First, log into your cPanel<\/a>.<\/li>\n
  2. This leads you to the main cPanel screen. From here, enter the File Manager<\/a> section.<\/li>\n
  3. Now that you are in the File Manager, you will need to navigate through the folders your osCommerce store root folder. For example, if your store is using your main domain name the folder you want is the public_html<\/em> folder. If you are using a subfolder for your store, such as example.com\/store<\/em> then it would be under a folder with that name (public_html\/store<\/em>)<\/li>\n
  4. Once you locate the root folder for your store, click on the includes<\/strong> folder.<\/li>\n
  5. Inside the includes folder you will see many files. Find and highlight the file names configure.php<\/em> file, then click on the Edit<\/strong> button located in the toolbar at the top of the screen. You will be met with a popup box, click the Edit<\/strong> button there as well.<\/li>\n
  6. Once inside the editor, you will see a lot of code which is a list of various settings. The line of code you want is the one with the DB_DATABASE setting. At the end of the lien of code, you will find your database name. Below is an example of the correct line of code.\n

    define('DB_DATABASE', 'userna5_osco123');<\/code>
    \nThe database name parameter is composed of two parts has two parts. Using our example, userna5<\/span>_osco123<\/span> the first part coded in red, userna5<\/em><\/span> is the cpanel username, followed by the actual database name coded in green _osco123<\/em><\/span>.<\/li>\n

  7. Be sure to write down the database name for later use. Now you can locate the correct database when working with phpMyAdmin<\/a> or other database management tools.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Working with your osCommerce site you will be able to make most changes for settings within the administrative panel. However, you may need to access the database directly, most often during troubleshooting. To do this, you will need to know the exact database name. Below are the instructions that will help you find the exact 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":[31],"tags":[],"class_list":["post-574","post","type-post","status-publish","format-standard","hentry","category-oscommerce"],"acf":[],"yoast_head":"\nHow to find your database name in osCommerce | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Use this tutorial to quickly find the exact database name for your osCommerce 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\/oscommerce\/locate-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 in osCommerce | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Use this tutorial to quickly find the exact database name for your osCommerce application.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-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-19T23:15:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:21:22+00:00\" \/>\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\/oscommerce\/locate-db-name\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to find your database name in osCommerce\",\"datePublished\":\"2013-02-19T23:15:02+00:00\",\"dateModified\":\"2021-08-17T03:21:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/\"},\"wordCount\":350,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"OsCommerce\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/\",\"name\":\"How to find your database name in osCommerce | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2013-02-19T23:15:02+00:00\",\"dateModified\":\"2021-08-17T03:21:22+00:00\",\"description\":\"Use this tutorial to quickly find the exact database name for your osCommerce application.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-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 in osCommerce\"}]},{\"@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\/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 in osCommerce | InMotion Hosting","description":"Use this tutorial to quickly find the exact database name for your osCommerce 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\/oscommerce\/locate-db-name\/","og_locale":"en_US","og_type":"article","og_title":"How to find your database name in osCommerce | InMotion Hosting","og_description":"Use this tutorial to quickly find the exact database name for your osCommerce application.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-19T23:15:02+00:00","article_modified_time":"2021-08-17T03:21:22+00:00","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\/oscommerce\/locate-db-name\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to find your database name in osCommerce","datePublished":"2013-02-19T23:15:02+00:00","dateModified":"2021-08-17T03:21:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/"},"wordCount":350,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["OsCommerce"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/","name":"How to find your database name in osCommerce | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2013-02-19T23:15:02+00:00","dateModified":"2021-08-17T03:21:22+00:00","description":"Use this tutorial to quickly find the exact database name for your osCommerce application.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-db-name\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/oscommerce\/locate-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 in osCommerce"}]},{"@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\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/574","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=574"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/574\/revisions"}],"predecessor-version":[{"id":84943,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/574\/revisions\/84943"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}