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

[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.

[iconnor]

Nope, but you could pay for someone to create it for you.

[Toberius]

I'm going to the best, free, afordable workaround: re-install whole again

[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.