Reset events and frames ID number

[gola10]

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?

[Lee Sharp]

Start here. http://www.zoneminder.com/forums/viewtopic.php?t=11005 However, changing things can add some different problems. Be careful.

[zoneminder]

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

Code: Select all

alter table Events auto_increment=1;

etc.

[Alan87i]

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

[MikeH]

It's a SQL statement that could be run against the ZM database using phpMyAdmin or some similar tool.