View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Fri Nov 15, 2013 2:39 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
I installed zm and have all the cameras working and all the events the way I want them. However along the way I have deleted cameras, and recreated them, cleared events, etc. SO the monitor numbers, and event numbers are not as I'd like.

I think I'm ready to do good configuration but would like to start with a clean slate as far as the database goes. How do I clear an recreated the database?

Seems to me there was an easy way to do that in earlier versions, and it use to tell you at the end of the install how to initialize the zm database.

Thanks


Top
 Profile  
 
PostPosted: Fri Nov 15, 2013 2:55 pm 
Offline
Joined: Wed Jan 18, 2006 8:36 pm
Posts: 199
I am not using R8 yet so these directions are approximate.

You should be able to start mysql (perhaps as root): drop database zm

once you do that, you should be able to run the "zminit" script to set-up your initial database.

Hope that helps.


Top
 Profile  
 
PostPosted: Fri Nov 15, 2013 8:52 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
That is what I was thinking but zminit no longer exists in the current package.


Top
 Profile  
 
PostPosted: Mon Nov 18, 2013 5:44 pm 
Offline
Site Admin
Joined: Fri Jun 11, 2004 7:58 am
Posts: 507
Drop the database and then
Code:
cat /usr/share/zoneminder/db/zm_create.sql | mysql
echo 'grant lock tables, alter,select,insert,update,delete on zm.* to 'zmuser'@localhost identified by "zmpass";' | mysql


The above code was taken from this file:
http://cgit.linhes.org/linhes_pkgbuild/ ... er.install


Top
 Profile  
 
PostPosted: Mon Nov 18, 2013 6:37 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
Thanks jams! Might be a good tip for the wiki


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu