3 ways to repair a database

[eva2000]

3 ways to repair a database

===================
1. you need to upload repair.php from your vB zip file to your /admin directory and run this url

yourdomain.com/admin/repair.php?html=1&check=1

2. or using mysqlcheck repair for 3.23.38 and above

i.e. in shell/telnet/ssh type while mysql is running and forum is CLOSED:

mysqlcheck -r -u mysqlusername -p databasename

3. or via myisamchk repair functions while mysql is shutdown/stopped in shell/telnet/ssh type :

myisamchk -r -u root -p databasename

option #3 most likely requires server and mysql root access to first stop mysql and then run myisamchk repair options.

[qxh]

When using vBulletin 3:

Go right down to the bottom of the Admin CP to "Import & Maintenance", and select the option "Repair / Optimize Tables". Next, select the checkbox "Check All" or the specific table which is corrupt or damaged. At "Options" you may change the option for "Optimize Tables" to no, but this is an optional step. Now click the button "Continue", it should repair your damaged table(s). :)

Using PhpMyAdmin:

Go into PhpMyAdmin and type the following query in the SQL box:

REPAIR TABLE tablename

Scott

[squall14716]

When using vB2, you can also install filburt's Self-Healing Database hack, and when a table is corrupted, it will automatically run REPAIR TABLE tablename.

[GmvsFord]

When using vB2, you can also install filburt's Self-Healing Database hack, and when a table is corrupted, it will automatically run REPAIR TABLE tablename.

Is there something like this for VB3 yet?


This would really come in handy for me :rolleyes:

[Zachery]

AdminCP > Import & Maitence > Repair and Optmize Tables

oh, and try upgrading to mysql 4.0.16 or better ;)