![]() |
freddie's Repair & Optimize Database (vB integration)
As we all know, there is a great tool included in the /extras folder, called [high]repair.php[/high].
I think not alot of people use it, because probably they don't know the gold mine hidden on it, related to tables optimisation. freddie's script will repair your database, but ALSO will optimize the tables. So what is that means? It will remove all the empty spaces that clutter the database. The result? A smaller database size. I ran the script on my localhost. At the beggining my database was 1.63MB. After I completed the repair&optimize process, my database was shrinked to 0.82MB!! That's almost half of the original size!! So I decided to integrate this tool directly into my admin CP. NOTE: The script is made by freddie, I only adapt it to the VB security and made it look like part of your CP. Also, my goal was to be able to optimize easy my database (with one click), not to repair it. You can use this script in combination with another hack, also made freddie: Admin Quick Stats [high]INSTALL PROCEDURE[/high] In /admin/index.php, find: Code:
makenavoption("vBulletin Options","options.php?t=0","<br>"); Code:
makenavoption("Repair & Optimize Data","repair.php?action=start","<br>"); [high]UPDATE[/high] Quoted from freddie's post: Quote:
|
"getting ready to run the script" screenshot...
UPDATE: refresh to see the new text warning... |
"Repair & Optimize (in action)" screenshot...
|
This is a great script! I never knew it existed.
I ran it a couple of times, and here's a problem that I ran into: Quote:
Thanks! Kaelon |
Oh, boy - not good. After the above error, I'm unable to access my forums.
I get the following error: Quote:
|
i quote from freddie:
Quote:
|
Yes, however, this problem didn't exist until I ran the repair.php script. It seems to have generated this problem. Do we know anything about the post Table that I could do to fix it by running several queries on it?
Here it is again: Quote:
|
That's really unfortunate. The forums were working as intended and it seemed to be running just fine prior to my running this script. It appeared that however it attempted to correct one of the tables ended up creating a problem sufficient enough to cause the forums to stop working.
I recommend that users not use this script until we know a bit more about it. Kaelon |
or at least make a backup of the database before running the script
|
good point.. i will add this in the info.. in the repair.php file.
i only put the text that freddie had in there... |
All times are GMT. The time now is 12:34 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|