OptimizeDB
 

delete the space in excess in your database whit a click.
Optimize Table's space.

I'll try this out, thanks!

i dont' understand what this does? does it speed up your board or something? minimize the size of your DB?

repair.php will do the same thing.

Yeah I saw that after I ran it freddie, oh well, this is built into the admin cp, more easy to do it. And who made repair.php freddie? Was it the dev team? I thought I read somewhere it wasn't supported and was given as an extra script.

when you modify something on the forum in the database remains space that not used... this hack detele this space...

if you go in your phpadmin and go in Session table for example ... you see in red (under table space) "in excess". This is the space that delete.

if you run the repair.php file that come with vb it gives you this message

repair.php for mysql 3.23 or greater

This script will attempt to repair corrupted databases. While it can repair most common errors, it can not repair everything. As a side benefit it will also optimize your tables. This script is unsupported by jelsoft

I wrote repair.php and it has the same OPTIMIZE table commands that this script has in addition to CHECK and REPAIR.

hey thats cool :cool:

I get an error when I try to load it....

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/httpd/htdocs/diettalk.com/forums/admin/optidb.php on line 10

--------------------------------------------------------------------------------
You have run this script: 0

--------------------------------------------------------------------------------
You have saved in your database: Kb
--------------------------------------------------------------------------------

[ Optimize DataBase ]

[ Delete Statistic ]