mysql table corrupted vb4

[themude]

I have 4 tables which are corrupted

searchcore
searchgroup
searchlog
tag
tagcontent

HOw to fix them plz help..I tried to repair the tables in php myadmin but still it shows table corrupted.

Incorrect information in file: tagcontent.frm
Incorrect information in file: tag.frm'
Incorrect information in file: searchlog.frm
Incorrect information in file: searchgroup.frm
Incorrect information in file: searchcore

themude Reviewed by themude on 4th Mar 2010. mysql table corrupted vb4 I have 4 tables which are corrupted searchcore searchgroup searchlog tag tagcontent HOw to fix them plz help..I tried to repair the tables in php myadmin but still it shows table corrupted. Rating: 5

[iFlames]

Go To ACP --> Maintenance --> Repair / Optimize Tables

then check all and click on continue..

[themude]

i did that also and but its not repairing see below

searchcore Check Error: Incorrect information in file: './warezmob_vb/searchcore.frm'
searchcore Check Error: Corrupt
searchcore
searchcore_text Check Status: OK
searchcore_text Optimize Status: OK
searchgroup Check Error: Incorrect information in file: './warezmob_vb/searchgroup.frm'
searchgroup Check Error: Corrupt
searchgroup
searchgroup_text Check Status: OK
searchgroup_text Optimize Status: OK
searchlog Check Error: Incorrect information in file: './warezmob_vb/searchlog.frm'
searchlog Check Error: Corrupt
searchlog
setting Check Status: OK
setting Optimize Status: OK
settinggroup Check Status: OK
settinggroup Optimize Status: OK
sigparsed Check Status: OK
sigparsed Optimize Status: OK
sigpic Check Status: OK
sigpic Optimize Status: OK
smilie Check Status: OK

[iFlames]

Go to ACP --> Maintenance --> Update Counters
and then click on Rebuild Search Index at the bottom

[desiboy]

go to phpmyadmin..
select the tables and click repair..

[themude]

@desiboy

I did that also but it shows still corrupted

[iFlames]

did you try to rebuild search index?

[themude]

when i am trying to rebiult search index it gives database error:

Incorrect information in file: './warezmob_vb/searchgroup.frm'

[desiboy]

may not be the best solution..
just drop table..and rebuild

[iFlames]

i dunno if theres some other way
but heres a way that can work
make a new folder and a database in your server
install a fresh copy of vbulletin [same version as you are using now]
DO NOT DELETE OLD FILES AND DATABASE
then drop these tables from your old database: tagcontent, tag, searchcore, searchgroup and searchlog
then export these same tables from your new database to your old one
TAKE DATABASE BACKUP BEFORE TRYING THIS