Page 1 of 1

URGENT: Recovery from MySQL table crash

Posted: Sat Mar 09, 2013 10:29 pm
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!

Re: URGENT: Recovery from MySQL table crash

Posted: Sat Mar 09, 2013 11:14 pm
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!