URGENT: Recovery from MySQL table crash

Forum for questions and support relating to the 1.25.x releases only.
Locked
_saiko
Posts: 16
Joined: Wed Apr 04, 2012 8:48 pm

URGENT: Recovery from MySQL table crash

Post by _saiko »

Hi,

I had a power outage and apparently the Config table crashed.
Upon starting the system and opening the ZM web interface I noticed the message " Table 'Config' is marked as crashed and should be repaired".
Went to phpmyadmin to try and repair the table but no such luck. The err log showed: "[Note] Found 0 of 218 rows when repairing './zm/Config'"
Currently that table is empty...ofcourse no backup :)
Other data seems intact...
What could be done currently to minimize loss?

Thanks in advance!
_saiko
Posts: 16
Joined: Wed Apr 04, 2012 8:48 pm

Re: URGENT: Recovery from MySQL table crash

Post by _saiko »

Solved...

As I said luckily only the config table was lost so all I had to do was recreate the default table contents by using a modified zm_create.sql
Well setting regular backups as of now!
Locked