Database crashed, does not repair
Posted: 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 !
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 !