How to Optimize Your Database Tables in phpFox

This article will focus on optimizing your database tables within your phpFox AdminCP.

Periodically you will want to optimize your database tables, reducing the size of the database by cleaning out unnecessary “empty” space.  You can do this in a couple different ways, but we will focus on using the tools available in your phpFox AdminCP.

As always, before you make any major changes or do any maintenance to your site, it is advised that you backup your site files and/or database.

Login to your admincp and select Tools > SQL > Maintenance.

toolsmenu

The next page shows a list of all the tables in your database, the size of your database, and how much Overhead is in those tables.  In order to optimize this database, we are going to check the box to the left of Table, to select ALL the database tables.  You can select specific tables to optimize instead of the entire database if you would like.  You don’t need to optimize ALL the tables at the same time.

select

Once you have selected all the database tables, scroll to the bottom of the page and click on Optimize Tables.

optimize

You should now see a Success message similar to the one here:

Looking for quality phpFox Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , | Posted under phpfox | RSS 2.0

Author Spotlight

Stephanie Brown

Stephanie Brown

I am a web and graphic designer with 10+ years experience in website design and development, as well as website hosting. I have been working with the phpFox networking script for 3+ years. In those 3 years I have assisted clients with template/style customization and design, addon development, and general phpFox site maintenance. Outside of the internet, I am a mother of 2 young children, caretaker of 1 old english bulldog, 4 persian cats, and 1 baby black rat snake that decided to slither into our kitchen one day.

Leave a Reply

Your email address will not be published. Required fields are marked *


6 × = 12

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>