Page 1 of 1

[Solved] Upgrading...is prior version listed in the exported .sql?

Posted: Wed Jan 14, 2009 2:29 pm
by kkruecke
I exported my cmsms database several months ago (August of 2008). But I, then, also removed cmms from the server shortly thereafter. I believe I first installed cmsms in 2006 (not sure). I now wish to upgrade to the latest version.

HOw can I determine the version I was using from the exported .sql? I do see, when I searched the export .sql, this line:

Code: Select all

INSERT INTO `cms_version` (`version`) VALUES
(29);
What version is this? I don't know which version to install in order to begin upgrading to the current version.

Re: Upgrading...is prior version in the exported .sql?

Posted: Wed Jan 14, 2009 2:40 pm
by duclet
I am not sure which version that is but since you are upgrading, I don't see a need to know what the previous version is. Just restore the database, which I believe you have already done so. Download the latest package and upload to site. Go to /install/upgrade.php to upgrade the site.

Re: Upgrading...is prior version in the exported .sql?

Posted: Wed Jan 14, 2009 3:06 pm
by kkruecke
Thanks for the reply. But will using update.php allow me to upgrade from several versions back?. I was concerned that there might have been several changes to the database tables between versions. I didn't realize upgrade.php could hadly the cumulative changes to the db between severalĀ  versions?

Re: Upgrading...is prior version in the exported .sql?

Posted: Wed Jan 14, 2009 8:02 pm
by kkruecke
Go to /install/upgrade.php to upgrade the site.
This worked. But I first had to do a fresh install into database of a different name, in order to create config.php, which I could then modifiy to point to the one I imported.

Re: Upgrading...is prior version in the exported .sql?

Posted: Wed Jan 14, 2009 10:30 pm
by duclet
You probably figured it out by now but yes, upgrade.php will allow you to upgrade from many versions back. Anyway, this seems to be solved so can you please add [Solved] to the title.

Re: [Solved] Upgrading...is prior version listed in the exported .sql?

Posted: Wed Jan 14, 2009 10:38 pm
by kkruecke
Thanks (done).