{"id":2083,"date":"2012-12-17T17:24:36","date_gmt":"2012-12-17T17:24:36","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/12\/17\/datanase-management\/"},"modified":"2021-08-16T23:26:10","modified_gmt":"2021-08-17T03:26:10","slug":"datanase-management","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/","title":{"rendered":"How to Manage your database in SMF 2.0"},"content":{"rendered":"

Part of your site maintenance should include database backup and optimization.\u00a0 Backing up your database should be done regularly. This is great insurance against any unforeseen instances that may cause you to lost data. The more recent your backup, the less data will be lost. Below are instructions on how to optimize your tables, backup your database, and convert your tables and data to UTF-8.<\/p>\n

Optimizing your database tables<\/h3>\n
    \n
  1. Log into your SMF admin dashboard<\/a>.<\/li>\n
  2. From the entry page, click Admin<\/strong> from the upper menu. This will reveal a second menu just underneath the first. Hover over Main<\/strong>and click on Administration Center<\/strong> from the popup submenu> You should,however, already be at this page by default when entering the Admin area.<\/li>\n
  3. At the the bottom of the page and you will see a list of maintenance categories. Click on the Forum Maintenance<\/strong> link to continue.<\/li>\n
  4. From the Forum Maintenance<\/em> page, select the Database<\/strong> link from the page menu.<\/li>\n
  5. Locate the Optimize All Tables<\/em> section and click on the Run task Now<\/strong> button.<\/li>\n<\/ol>\n

    Backing up your database<\/h3>\n
      \n
    1. Log into your SMF admin dashboard<\/a>.<\/li>\n
    2. On this page, click the Admin<\/strong> link in the upper menu. A second menu will appear just below. Hover over Main<\/strong>and click on Administration Center<\/strong> from the popup submenu> You should,however, already be at this page by default when entering the Admin area.<\/li>\n
    3. Scroll to the bottom of the page and you will see a list of categories. Click on the Forum Maintenance<\/strong> category to continue.<\/li>\n
    4. Once on the Forum Maintenance<\/em> page, select the Database<\/strong> link from the page menu.<\/li>\n
    5. Locate the Backup Database section on the screen and configure the settings as you desire. By default, all settings are selected.<\/li>\n
    6. Once configured, click on the Download<\/strong> button to download the backup to your local computer.<\/li>\n<\/ol>\n

      Converting your database to UTF-8<\/h3>\n
        \n
      1. Log into your SMF admin dashboard<\/a>.<\/li>\n
      2. From the Admin entry page, click Admin<\/strong> found the upper menu. This displays a second menu just below the first. Hover over Main<\/strong>and click on Administration Center<\/strong> from the popup submenu> You should,however, already be at this page by default when entering the Admin area.<\/li>\n
      3. Scroll to the bottom of the page for the list of maintenance categories. Locate and click on the Forum Maintenance<\/strong> category to continue.<\/li>\n
      4. Once on the Forum Maintenance<\/em> page, select the Database<\/strong> link from the page menu.<\/li>\n
      5. Locate the Convert The Database And Data To UTF-8<\/em> section and click on the Run task Now<\/strong>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

        Part of your site maintenance should include database backup and optimization.\u00a0 Backing up your database should be done regularly. This is great insurance against any unforeseen instances that may cause you to lost data. The more recent your backup, the less data will be lost. Below are instructions on how to optimize your tables, backup 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-2083","post","type-post","status-publish","format-standard","hentry","category-mediawiki","category-smf","category-website","category-databases"],"acf":[],"yoast_head":"\nHow to Manage your database in SMF 2.0 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.\" \/>\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\/datanase-management\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Manage your database in SMF 2.0 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\" \/>\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=\"2012-12-17T17:24:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:26:10+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\/datanase-management\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"How to Manage your database in SMF 2.0\",\"datePublished\":\"2012-12-17T17:24:36+00:00\",\"dateModified\":\"2021-08-17T03:26:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\"},\"wordCount\":420,\"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\/datanase-management\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\",\"name\":\"How to Manage your database in SMF 2.0 | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2012-12-17T17:24:36+00:00\",\"dateModified\":\"2021-08-17T03:26:10+00:00\",\"description\":\"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Manage your database in SMF 2.0\"}]},{\"@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 Manage your database in SMF 2.0 | InMotion Hosting","description":"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.","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\/datanase-management\/","og_locale":"en_US","og_type":"article","og_title":"How to Manage your database in SMF 2.0 | InMotion Hosting","og_description":"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-12-17T17:24:36+00:00","article_modified_time":"2021-08-17T03:26:10+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\/datanase-management\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"How to Manage your database in SMF 2.0","datePublished":"2012-12-17T17:24:36+00:00","dateModified":"2021-08-17T03:26:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/"},"wordCount":420,"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\/datanase-management\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/","name":"How to Manage your database in SMF 2.0 | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2012-12-17T17:24:36+00:00","dateModified":"2021-08-17T03:26:10+00:00","description":"Learn to manage your database by backing up the data, converting the data to UTF-8 and streamlining the tables.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/mediawiki\/datanase-management\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Manage your database in SMF 2.0"}]},{"@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\/2083","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=2083"}],"version-history":[{"count":2,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2083\/revisions"}],"predecessor-version":[{"id":85188,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2083\/revisions\/85188"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}