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:

makenavoption("vBulletin Options","options.php?t=0","<br>");

BELOW THIS, add:

makenavoption("Repair & Optimize Data","repair.php?action=start","<br>");

Now, upload repair.php into your /admin folder. You are done.

[high]UPDATE[/high]
Quoted from freddie's post:

Originally posted by freddie
I wrote repair.php as something that I could run nightly on my forum as it was getting periodic corruption. It has run nightly for probably a year now and I have not had a corrupt table since.

I thought that perhaps it might help out others and be an easier than telling everyone to go run myisamchk on their databases to fix problems. That being said, I only tested it on my forum so that is why it says "Not Supported". It won't work on non MyISAM tables and it won't work if the user table is corrupted.

[TECK]

Originally posted by FireFly
Yes nakkid, even your script - can fail. Don't be so brutal and yell at people for doing nothing other than clicking a button.

firefly, is not my script. i only did as usual a little mod to it, you know i'm not the best at this. but when i know for sure one thing, i put my foot on the floor. is obvious that a script can fail, nothing is perfect, but 80%??? kmon... you can admit firefly that there is no diff between phpmyadmin and a query ran in VB. i have the tendency to believe that 225 is alot more stable in this area.

and i dont yell. i simply state that people have a tendency to blamne someone(something) else for their mistakes. so what if corrupted? if is no good, why would it be in the VB package??? i doubth Jelsoft wants to promote a crappy code image.

i know freddie from this board and he pulls amasing stuff. period. there is no but, maybe or how. and people had problems with the script because maybe it wasnt well documented? look at this situaton with Kaelon. he ran the script with the board ON. now we all know what to do. constructive, right?

@Slynderdale: dont panic, that's me.. when you will know me better, you will see that this is my wierd way to talk sometimes. dont take it bad because that's how i am, i say what i think... sometimes to fast.

regulars start laughing at me while i pull one of my panic attacs... and i join them also shortly after...

[Slynderdale]

that was taken around 1 am in the morning, that was my stats

[Admin]

Originally posted by nakkid
and i dont yell. i simply state that people have a tendency to blamne someone(something) else for their mistakes. so what if corrupted? if is no good, why would it be in the VB package??? i doubth Jelsoft wants to promote a crappy code image.

Oh you do yell, maybe you can't see it but you are. The script in vBulletin's zip file is not like your file. It's different, you altered it and added stuff - no matter what you did, you changed it.
And I don't care if the PHP authors wrote the script themselves, the fact is, many people can't get it to work correctly. So unless everyone here except you are complete idiots, something must be wrong, right?

Originally posted by nakkid
@Slynderdale: dont panic, that's me.. when you will know me better, you will see that this is my wierd way to talk sometimes. dont take it bad because that's how i am, i say what i think... sometimes to fast.

regulars start laughing at me while i pull one of my panic attacs... and i join them also shortly after...

Maybe you should start thinking before you post? Think over what you're going to say, and choose your words carefully. I don't know about others, but I certainly don't laught at your panic attacks, they actually annoy me quite a bit. If you feel angry don't take it out on the forum users, get a cigarette. People don't deserve your yells.

See, I'm not yelling.

[TECK]

true. i apologise about the tension i created like an idiot. i mean it.

now, about the script. if i understand correctly, people had problems with my mod? not with freddie's file?

[Sparkz]

Originally posted by nakkid
true. i apologise about the tension i created like an idiot. i mean it.

No offence, but it seems to me that this is something you do alot.

Maybe you should consider grabbing a glass of water, or maybe even counting to 100 before posting when you see something that makes you go off like this?

[Freddie Bingham]

Hmm lots of talk about me.

I wrote repair.php as something that I could run nightly on my forum as it was getting periodic corruption. It has run nightly for probably a year now and I have not had a corrupt table since.

I thought that perhaps it might help out others and be an easier than telling everyone to go run myisamchk on their databases to fix problems. That being said, I only tested it on my forum so that is why it says "Not Supported". It won't work on non MyISAM tables and it won't work if the user table is corrupted.

Kaelon - your post table was corrupted before you opened repair.php. You can have corruption without it being to the point of causing visible problems. The error 28 that the script generated shows that your database ran out of space while trying to repair the post table. There was nothing inherent to the script that caused your problem. Your post table is very small so for this to have occurred would have to be a fault of your hosting company in terms of managing disk space. In fact, the corrupted index that brought up the repair procedure to begin with was probably caused by the lack of disk space.

[Ren]

Very nice , I installed this and backed up my forums and it worked great .. thanks

[NTLDR]

Very nice addition to the Admin CP, thank you nakkid and freddie

@Slynderdale would you mind sharing how you got the custom avatar and attachment count in the stats?

[Floris]

NTLDR: hack by freddie

[NTLDR]

Originally posted by xiphoid
NTLDR: hack by freddie

I have freddies hack installed, but I wanted to know how the avatar and attachment count was added as that isn't part of the freddies hack (or at least not the version I installed).

I'll take another look.