Page 1 of 1
What is my database version
Posted: Sat Jan 26, 2013 1:15 am
by 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
Re: What is my database version
Posted: Sat Jan 26, 2013 2:22 pm
by 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.
Re: What is my database version
Posted: Sat Jan 26, 2013 10:13 pm
by 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?
Re: What is my database version
Posted: Sun Jan 27, 2013 7:48 am
by maschoff
In this case, yes.
Re: What is my database version
Posted: Sun Jan 27, 2013 4:11 pm
by nterry
Went great, thanks! Up and running on 2013. Love this product