How to Optimize & Reduce size of MySql Database?
MySql databases form the back end of many online applications including WordPress blogs and website, Shopping carts, Asquared knowledge base.
Size of a database is very important for easy management and must be reviewed on a regular basis.
Optimizing Mysql database can greatly reduce overall size of your database. For example: a WordPress Blog database went from 85MB to just 10MB after optimization.
There are a number of articles you can read to understand and learn how to optmise a database. It is recommended you get a basic understanding of how a database works first.
PLEASE NOTE:
You must backup your database(s) before attempting optimisation or any changes. If something goes wrong, you can then reload the database. It is not recommended you alter the database in any way if you do not have a basic understanding of database operations.
User support is available for this operation, please contact us for current user support rates by lodging a ticket with details on what kind of support you require.
Please go to:
http://www.tothepc.com/archives/how-to-optimize-reduce-size-of-mysql-database/
http://www.mitchelsellers.com/blogs/articletype/articleview/articleid/121.aspx