Also, I have tried using myisamchk -r -o /var/lib/mysql/* and I get an error for every file:
"myisamchk: error; 'filename' is not a MYISAM-table
I tried the same thing in the /var/lib/mysql/zm directory and same error....soooo where are the tables?
Search found 3 matches
- Thu Jun 11, 2020 8:16 pm
- Forum: ZoneMinder 1.35.x Development Branch
- Topic: Ungraceful shutdown SQL needs rebuilt
- Replies: 4
- Views: 3297
- Thu Jun 11, 2020 7:13 pm
- Forum: ZoneMinder 1.35.x Development Branch
- Topic: Ungraceful shutdown SQL needs rebuilt
- Replies: 4
- Views: 3297
Re: Ungraceful shutdown SQL needs rebuilt
Soooo, how do I rebuild the dbase from scratch?
- Wed Jun 10, 2020 7:36 pm
- Forum: ZoneMinder 1.35.x Development Branch
- Topic: Ungraceful shutdown SQL needs rebuilt
- Replies: 4
- Views: 3297
Ungraceful shutdown SQL needs rebuilt
Hello all, I had just got 1.35 up and going and my cameras added. I had not done a backup of the zm sql database yet as this was new. I had an unfortunate issue with a power cable(lost power). I am definitely not an SQL admin, but can get around. So now when I try and navigate to ZM_IP/zm I have the...