Tutorial - Database tips -

Few tips how to make your database stable for use:

Optimize your Database:

To perform the optimization, log in to your phpMyAdmin and select the database whose tables you wish to optimize.

A list with all the database's tables will appear. Tick the tables you wish to optimize, or simply click [Check All] to select all tables.

From the [With selected:] drop-down menu choose Optimize table. This will execute the OPTIMIZE TABLE SQL query on the selected tables and they will be updated and optimized.


Table prefixes:

Sometimes when you are moving your database on another host etc, it happens database generate new tables example:

Your table prefix: mybb3_
New tables: mybb5_

It's hard to see it, and also that can make forum slower so check for that.

Security Guidelines:

-Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database!

-Do not store any plaintext passwords in your database

-Use complex password for your Cpanel do not use something like "mybbjohn", use more numbers etc. More about complex passwords.

-Carefully watch from where are you downloading plugin, maybe some of them have are vulnerable to SQL injection so hacker can get access to your database.

Also read more threads about MyBB Security such as:

http://community.mybb.com/thread-44977.html
http://community.mybb.com/thread-9991.html

Hosting related:

Watch out which host you choose. On my own experience i changed 6 hosts, and 90% had server security problems.
Don't save your money on cheap hosting's, better pay more but to have good and much secured hosting. If you want to start the proiject don't even try free hosting.

Database Backups:

Do your database backups every day (my recommend). You will never know what will happend, losing some table, host shutdown, some kidy hacker screwed it all.
It's free to make database backups nothing costs you.

I'll keep this updated, JovanJ.

This can be done with in mybb (ACP, Tools & Maintenance, Optimize Database) or is it just preferred to use phpmyadmin or does it matter ?

It makes no difference; they both use the same PHP functions.

I use HOSTGATOR as my hosting provider. Based on review/comments i gathered they say hostgator is the best and also their livechat support.

No difference as Nathan sayed.
harlenjoy i never used it, so i can't say anything about them.

is it possible to optimize the mybb database using a cron job and a php script?

does a script exist?

(08-11-2012 08:48 AM)shemo Wrote:  is it possible to optimize the mybb database using a cron job and a php script?

does a script exist?

See: http://docs.mybb.com/Help-Task_System.html