PDA

View Full Version : Can I find out what version of Mezzmo an old Mezzmo.db database is from?



some_evil
12-28-2017, 04:04 PM
Hey,

I have weekly backups of my Mezzmo database going back about 2 years (several Mezzmo versions).

I have downloaded an older version of Mezzmo from here www.mezzmo.com/wiki/doku.php?id=downloading_older_versions_of_mezzmo

I am wondering if there is a way I can see what version each of my database backups were at, at any given time? I have been viewing the DB using SQLiteSpy, but I cannot see a version table or something that would indicate what version that particular snapshot of my DB is at. Is there a way I can look at my Mezzmo.db file and see what version I should install to be able to associate it with?

Cheers

Paul
12-28-2017, 05:08 PM
The backup folder that is created when you backup your Mezzmo database has the Mezzmo program version number in the folder name. For example "MezzmoBackup-v4.1.3.0-2015-01-13-11-08-24". This tells you v4.1.3.0 and the date/time of the backup.

some_evil
12-28-2017, 05:14 PM
what if the database is not within a 'backup' folder? My entire Mezzmo directory is backed up off site, so the database is not within a folder as you describe, it is in the root directory. Is there a way to tell what the version of the software was at, at the time of the database snapshot?

Paul
12-28-2017, 05:27 PM
In the Mezzmo.db file, there is a MGOSettings table and it has a DatabaseVersion column. This represents the (internal) version of the database. There is no correlation between database version and program version. The latest version of Mezzmo will automatically upgrade your Mezzmo database to the latest database version.

some_evil
12-28-2017, 05:32 PM
ah ok.. bugger. So is there a way I can install v5.1.3 and use the DB which was updated when installing v5.2.0?

Paul
12-28-2017, 07:25 PM
Sorry - cannot downgrade the database.

Ideally, you should have made a backup when upgrading/installing the latest v5.2.0.0. Do you have that backup? If yes, then you can restore it into Mezzmo v5.1.3.0.

If no backup, then we can troubleshoot the streaming problem you are having with v5.2.0.0. The logs you sent into us via email did not have any streaming. So please re-install Mezzmo v5.2.0.0, turn on logging and try streaming a few files. Then stop your Mezzmo server and exit Mezzmo (Windows) app. Zip up all the logs and email them to us. We'll analyze them and report back shortly.

some_evil
12-28-2017, 09:47 PM
Ideally, you should have made a backup when upgrading/installing the latest v5.2.0.0. Do you have that backup? If yes, then you can restore it into Mezzmo v5.1.3.0.


When the update went through I was prompted (unsure if it was pre or post update) to backup my DB. I just looked in my windows directory and the backup folder is called MezzmoBackup-v5.2.0.0-2017-12-26-15-47-48, so from that I am guessing that the backup was taken after mezzmo had updated and converted the DB to the latest version, meaning I cannot restore that to a client version of 5.1.3.0, is my understanding of this correct?

Thanks again for your time. Its greatly appreciated.

Cheers

Paul
12-28-2017, 10:40 PM
Actually the backup is made before the upgrade. so you can use this with your previous Mezzmo version.