Page 1 of 1

My Vicidial_list table become corupt

PostPosted: Fri Jul 20, 2007 3:12 am
by sanisoft
Hello All

my vicidial_list table become corrupt, any idea how to fix it

I drop table and and try to re-create it.

Now when I gave command to create vicidial_list table again. it gave me following error

ERROR 3 (00000): Error writing file './asterisk/vicidial_list.frm' (Errcode: 28)

any idea how to fix this isuue, I will be very much thanking full to you.

Thanks and Regards

Sani

PostPosted: Sat Jul 21, 2007 10:43 am
by devafree
Generally, the command check table <tablename> in MySQL prompt will show the status. If it is corrupt or marked as crashed, we can use "repair table <tablename>" then re-check status it is generally becomes OK.

If not able to , then from the root shell, use mysqladmin shutdown command , then type /usr/bin/myisamchk -r /pathto-your mysql/<tablename.MYI> it should recover fine. I use slackware 11 and default scratch install.

hope it helps

regards

devafree