{"id":2472,"date":"2013-02-21T16:24:15","date_gmt":"2013-02-21T21:24:15","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/21\/301-locate-databse-name\/"},"modified":"2021-08-16T23:21:19","modified_gmt":"2021-08-17T03:21:19","slug":"locate-smf-databse-name","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/","title":{"rendered":"How to locate your SMF 2.0 installation’s database name"},"content":{"rendered":"

Your SMF database name was originally created during the programs installation. This information is usually not needed during routine work as the vast majority of settings and features can be handled within the SMF administation section. However, if you ever need to work directly with the database, particularly when troubleshooting, you will need to know the database name. As many hosting accounts contain more than one database, not knowing the exact database name can make things difficult. Below we will discuss how to locate the database name for your particular SMF installation.<\/p>\n

Finding your database name in SMF 2.0<\/h2>\n
    \n
  1. First, you will need to log into your cPanel<\/a> account.<\/li>\n
  2. Next, you will need to open and enter the File Manager<\/a> tool.<\/li>\n
  3. From the File Manager<\/em>, you will need to locate and move to the root folder for your SMF installation. If you are using your main domain, the root folder will be public_html<\/em>. If you are using a domain name, then it will be under public_html\/domainname<\/em> (For example, if example.com<\/em> is an addon domain, you will need to fin the public_html\/example.com<\/em> folder)<\/li>\n
  4. Once in the root folder for your application, you will see many files. The find the Settings.php<\/strong> file. Highlight the file and then click on the Edit<\/strong> button found in the toolbar across the top of the screen. A popup will appear on the screen, click the Edit<\/strong> button there as well.<\/li>\n
  5. Once in the editor, you will see a lot of different settings for your SMF program. Around line 30 you will see the code for the database name. It appears like the example below:\n

    $db_name = 'userna5_smf123';<\/code>
    \nThe database name is composed of two parts. In our example userna5<\/span>_smf123<\/span>, the first part is the cpanel username (userna5<\/span>), and the second part is the actual database name (smf123<\/span>)<\/li>\n

  6. Write down your database name in a safe place so will be able to remember it when you need to access it using the phpMyAdmin<\/a> tool.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Your SMF database name was originally created during the programs installation. This information is usually not needed during routine work as the vast majority of settings and features can be handled within the SMF administation section. However, if you ever need to work directly with the database, particularly when troubleshooting, you will need to know 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":[99,4293,4288,4305],"tags":[],"class_list":["post-2472","post","type-post","status-publish","format-standard","hentry","category-mediawiki","category-smf","category-website","category-databases"],"acf":[],"yoast_head":"\nHow to locate your SMF 2.0 installation's database name | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Find your SMF 2.0 application database name with this short article.\" \/>\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\/mediawiki\/locate-smf-databse-name\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to locate your SMF 2.0 installation's database name | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Find your SMF 2.0 application database name with this short article.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-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-21T21:24:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:21:19+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\/mediawiki\/locate-smf-databse-name\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to locate your SMF 2.0 installation’s database name\",\"datePublished\":\"2013-02-21T21:24:15+00:00\",\"dateModified\":\"2021-08-17T03:21:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/\"},\"wordCount\":340,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"MediaWiki\",\"SMF\",\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/\",\"name\":\"How to locate your SMF 2.0 installation's database name | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2013-02-21T21:24:15+00:00\",\"dateModified\":\"2021-08-17T03:21:19+00:00\",\"description\":\"Find your SMF 2.0 application database name with this short article.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to locate your SMF 2.0 installation’s database name\"}]},{\"@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 locate your SMF 2.0 installation's database name | InMotion Hosting","description":"Find your SMF 2.0 application database name with this short article.","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\/mediawiki\/locate-smf-databse-name\/","og_locale":"en_US","og_type":"article","og_title":"How to locate your SMF 2.0 installation's database name | InMotion Hosting","og_description":"Find your SMF 2.0 application database name with this short article.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-21T21:24:15+00:00","article_modified_time":"2021-08-17T03:21:19+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\/mediawiki\/locate-smf-databse-name\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to locate your SMF 2.0 installation’s database name","datePublished":"2013-02-21T21:24:15+00:00","dateModified":"2021-08-17T03:21:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/"},"wordCount":340,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["MediaWiki","SMF","Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/","name":"How to locate your SMF 2.0 installation's database name | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2013-02-21T21:24:15+00:00","dateModified":"2021-08-17T03:21:19+00:00","description":"Find your SMF 2.0 application database name with this short article.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/locate-smf-databse-name\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to locate your SMF 2.0 installation’s database name"}]},{"@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\/2472","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=2472"}],"version-history":[{"count":4,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2472\/revisions"}],"predecessor-version":[{"id":84933,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2472\/revisions\/84933"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}