Part of your site maintenance should include database backup and optimization.  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.

Optimizing your database tables

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

Backing up your database

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

Converting your database to UTF-8

  1. Log into your SMF admin dashboard.
  2. From the Admin entry page, click Admin found the upper menu. This displays a second menu just below the first. Hover over Mainand click on Administration Center from the popup submenu> You should,however, already be at this page by default when entering the Admin area.
  3. Scroll to the bottom of the page for the list of maintenance categories. Locate and click on the Forum Maintenance category to continue.
  4. Once on the Forum Maintenance page, select the Database link from the page menu.
  5. Locate the Convert The Database And Data To UTF-8 section and click on the Run task Now.
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Like this Article?

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 201018

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!