Database optimization

[Unlucky]

Our host has said we need to optimize our database but we haven't a clue how or what to do?

Any advice appreciated

[AndyF]

I'm surprised they would not do it for you if you asked ? I'd take a backup first though.

Do you plan to do this via phpmyadmin or via ssh (command line) ? , phpmyadmin is slightly easier if you are not sure!

[bfarber]

Did they provide you with any additional details?

The term "optimize" is a rather loose term here. If you are using MyISAM tables then you can run a true optimize query in phpmyadmin (or a similar tool) which can help some tables:

OPTIMIZE TABLE _tablename_

Your host may have been talking more broadly about improving the efficiency of your database, however, which is probably something you would need to relay to us if they gave you details.