ZoneMinder Forums

I've got 1.19.5 running on system A. It's been working happily for quite a while, but the main system hardware's showing signs of flakeyness. I'm planning to put 1.20.1 onto new system B, which I've been building. There are a few catches:

System A runs mySQL 3.23.49, PHP 4.1.2, and Apache 1.3.26.
System B has mySQL 4.0.22, PHP 4.3.10, and Apache 2.0.52.

The easy thing to do is probably just to put a fresh install on system B and be done with it, but I have, I guess, fifty or sixty archived example events I'd quite like to hang on to.

Is there a relatively simple way to transfer the archived events from system A to system B so that they can be re-played on the new installation?

Essentially I think you need to look at mysqldump. This will create a text based SQL dump of all, or part of, your DB which you can then import into your new DB. Be aware that some tables may have changed between versions but I think you might be lucky with the Events table. In fact I think you'd be better off duplicating your whole 1.19.5 DB and then manually applying the DB updates to ensure that all the id numbers etc are consistent across tables.

Phil

Cheers.

Hmmm... Seem to be getting a mysql error when trying to update the database from 1.19.5 to 1.20.1...
The user can do some things with the database, and has had select,insert,update,delete granted...

Ah! The superuser, however, does seem to be able to do what's needed.