[Solved] Is there any way to reset all id's, stored files counters?

Discussions related to the 1.36.x series of ZoneMinder
Post Reply
Toberius
Posts: 13
Joined: Fri Jan 27, 2023 12:56 am

[Solved] Is there any way to reset all id's, stored files counters?

Post by Toberius »

Hi, like topic said.

I'm new run and test ZM and I just wondering if there is a option to reset all counters, id's and other tracking like a fresh install.

My best.
Last edited by Toberius on Sat Jan 28, 2023 6:48 pm, edited 1 time in total.
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Is there any way to reset all id's, stored files counters?

Post by iconnor »

Nope, but you could pay for someone to create it for you.
Toberius
Posts: 13
Joined: Fri Jan 27, 2023 12:56 am

Re: Is there any way to reset all id's, stored files counters?

Post by Toberius »

I'm going to the best, free, afordable workaround: re-install whole again :wink:
Toberius
Posts: 13
Joined: Fri Jan 27, 2023 12:56 am

Re: Is there any way to reset all id's, stored files counters?

Post by Toberius »

Ok guys, I didn't need it to reinstall whole system, just digging a bit under 'zm' database into mariasql in my case. If you use MySQL must be the same I think.
First, I drop zm database and when logged into mysql as root, follow the insctruction below:

Code: Select all

mysql> CREATE DATABASE zm;
 * mysql> grant lock tables,alter,drop,select,insert,update,delete,create,index,alter routine,create routine, trigger,execute on zm.* to 'zmuser'@localhost identified by 'zmpass';
 * mysql> flush privileges;
 * Once you completed that you should execute the following:
 * mysql -p < /usr/share/zoneminder/db/zm_create.sql
The sql sentence to run I must to ran with root because I got a lot of errors that now I don't remember.
But... still I got one error "ERROR 1728 (HY000) at line 117 in file: '/usr/share/zoneminder/db/triggers.sql': Cannot load from mysql.proc. The table is probably corrupted"

Afterall doing that I achieve reset all Id's and folder store.
Post Reply