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

[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.

[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.

[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?

[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.

[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.

[kkruecke]

Thanks (done).