Page 1 of 1

Export ZM configuration without copying the entire database.

Posted: Sat Mar 02, 2024 8:14 am
by User6677
I'm running ZM 1.36 and sadly my DB got corrupted and the backup overwritten with corrupted data before I noticed.

I repaired the DB as much as possible (by using sql recovery mode, then creating a new ZM DB and importing recovered data). But certain features are not working right.

So I need to start from scratch, but I'd like to copy my monitor config (especially motion detection areas) which I've been tweaking and improving for a long time.

Which DB tables contain:
- motion detection areas
- monitor config?

And will I have to fix any data manually afterwards? Does anyone here know?

Re: Export ZM configuration without copying the entire database.

Posted: Sat Mar 02, 2024 8:32 am
by dougmccrary
Which DB tables contain:
- motion detection areas
- monitor config?
-Zones
-Monitors

You might want to look at https://wiki.zoneminder.com/MySQL

Re: Export ZM configuration without copying the entire database.

Posted: Mon Mar 04, 2024 6:39 am
by User6677
dougmccrary wrote: Sat Mar 02, 2024 8:32 am
Which DB tables contain:
- motion detection areas
- monitor config?
-Zones
-Monitors

You might want to look at https://wiki.zoneminder.com/MySQL
Thank you :-)