| LinHES Forums http://forums.linhes.org/ |
|
| How to clear and recreate the zoneminder database in R8 http://forums.linhes.org/viewtopic.php?f=25&t=23875 |
Page 1 of 1 |
| Author: | tscholl [ Fri Nov 15, 2013 2:39 pm ] |
| Post subject: | How to clear and recreate the zoneminder database in R8 |
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 |
|
| Author: | bobmyth [ Fri Nov 15, 2013 2:55 pm ] |
| Post subject: | Re: How to clear and recreate the zoneminder database in R8 |
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. |
|
| Author: | tscholl [ Fri Nov 15, 2013 8:52 pm ] |
| Post subject: | Re: How to clear and recreate the zoneminder database in R8 |
That is what I was thinking but zminit no longer exists in the current package. |
|
| Author: | jams [ Mon Nov 18, 2013 5:44 pm ] |
| Post subject: | Re: How to clear and recreate the zoneminder database in R8 |
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 |
|
| Author: | tscholl [ Mon Nov 18, 2013 6:37 pm ] |
| Post subject: | Re: How to clear and recreate the zoneminder database in R8 |
Thanks jams! Might be a good tip for the wiki |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|