I have ZM 1.22.3 installed from ZM Mandriva 2007 livecd. This computer was attacked by a hacker so i better reinstall. But i want to keep y settings.
One way to go is to backup the database and restore it on the new installation. (at least that i what i plan. But would like to reset reset frame ID number and Events ID number. Frames number is already 8 digits and events 6 digits.
Is there a script to reset this databases and the autoincrement field?
Reset events and frames ID number
Start here. http://www.zoneminder.com/forums/viewtopic.php?t=11005 However, changing things can add some different problems. Be careful.
- zoneminder
- Site Admin
- Posts: 5215
- Joined: Wed Jul 09, 2003 2:07 pm
- Location: Bristol, UK
- Contact:
Although you can reset the events and frame indexes etc this will only work if you do not have entries in the DB already. If you add even just one event with an id of 1000000 then the next one will be 10000001 regardless. If you have an empty DB you can reset the counts with etc.
Code: Select all
alter table Events auto_increment=1;
Phil
A bit more detail
Could someone please explain a little further where or what a fellow is to do with this code ( alter table Events auto_increment=1 ) to make use of it?
Thanks
Thanks