Archived event export/import for upgrade/re-install...

lazyleopard · Post by **lazyleopard** » Tue Mar 08, 2005 9:20 pm

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?

Post by **zoneminder** » Tue Mar 08, 2005 11:33 pm

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

lazyleopard · Post by **lazyleopard** » Wed Mar 09, 2005 2:56 pm

Cheers.

lazyleopard · Post by **lazyleopard** » Fri Mar 11, 2005 12:14 am

Hmmm... Seem to be getting a mysql error when trying to update the database from 1.19.5 to 1.20.1...

Code: Select all

ERROR 1044 at line 6: Access denied for user:

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.