Database crashed, does not repair

electron · Post by **electron** » Sun Apr 16, 2006 9:06 pm

This is a fresh FC3 DVD install with 1.22 RPM's installed. It was working for few weeks just fine, but the datbase crashed last nite & I've tried the mysqlcheck --all-databases --auto-repair -pzm_pass -u zm_user and that has always fixed any database problems before. This time I get:
warning : Table is marked as crashed
warning : 1 clients is using or hasn't closed the table properly
error : record delete-link-chain corrupted
error : Corrupt

So I tried using mysql terminal, use zm database, then Describe Frames
ERROR 1016: Can't open file: 'Frames.MYD'. (errno: 145)
mysql> DESCRIBE Frames;
ERROR 1016: Can't open file: 'Frames.MYD'. (errno: 145)

Is there a way to repair this, or do I need to delete the database & create a new one over again ?
BTW, this install has had other problems I hadn't yet diagnosed, it always had problems running all 3 cams in mocord & before on 1.21.3 it did not, I'm sure it's my goof up on the install somewhere, cuz I have 2 other ZM boxes running 1.22 w/out this problem.
Thanks !

Post by **cordel** » Mon Apr 17, 2006 4:15 am

You may need to stop the database as outlined in this thead:
http://www.zoneminder.com/forums/viewtopic.php?t=5657

Regards,
Corey

electron · Post by **electron** » Mon Apr 17, 2006 4:34 pm

Thanks that did the trick !