What is my database version

[nterry]

I'm trying to upgrade from 2012 Beta 3 to the latest 2013 released version. I tried using the automatic upgrade and now have a mess! I am going to remove everything and do a fresh install, but I would like to be able to save my old Database (Not cmm, just regular). I have a daily backup but the issue is I am not clear on what version it is in order to run the upgrade. Is the database version actually stored somewhere in the database itself?

Thanks

[maschoff]

An online update to 2013 is not available for beta versions, only for release candidates and a beta should not be used for production systems, of course.

But no problem: If your backup is based on OpenEMM 2011 you can manually update it to OpenEMM 2013 with "mysql -u root -p openemm < update_openemm-2011-2013.sql"

If your backup is stuck somewhere in the middle between 2011 and 2013 you have to check for every SQL statement in file update_openemm-2011-2013.sql whether it is already in your DB. And if it isn't you have to execute the statement manually.

[nterry]

Thanks. My backup is from 2012 Beta 3. Do I assume from your comment that this is not 2011 but some state between that and 2013?

[maschoff]

In this case, yes.

[nterry]

Went great, thanks! Up and running on 2013. Love this product