Export ZM configuration without copying the entire database.

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
User6677
Posts: 17
Joined: Sat Dec 24, 2022 9:32 am

Export ZM configuration without copying the entire database.

Post 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?
dougmccrary
Posts: 1256
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: Export ZM configuration without copying the entire database.

Post by dougmccrary »

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

You might want to look at https://wiki.zoneminder.com/MySQL
User6677
Posts: 17
Joined: Sat Dec 24, 2022 9:32 am

Re: Export ZM configuration without copying the entire database.

Post 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 :-)
Post Reply