ZoneMinder Forums

Hi,

The PC i use for zoneminder chrashed today so i have to reboot with the reset switch.

It all came back so i was happy. However when i got to the zone minder page i can login ok but get the following error.

Got error 134 from table handler
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/html/zm/zm_html_view_console.php on line 41

I guess the database has got corupted.

Is the a quick fix for this or should i rebuild the machine from the live cd.


Regards

Paul

This will repair any damaged tables. Run as root

myisamchk --silent --force --fast --update-state -O key_buffer=64M \
-O sort_buffer=64M -O read_buffer=1M -O write_buffer=1M \
/var/lib/mysql/*/*.MYI

Hope this helps.

Ross

Thanks Ross,

This has got the database back.

Regards

Paul