Upgrade Db only

Added by Michalis Miatidis about 5 years ago

Hello,

I had a running Redmine 1.2.1 installation till today that the hosting harddrive crashed. Luckily, I have a recent backup of redmine files and MySQL db that contains all data.

I want to grab the opportunity and install Redmine 2.1.3 at a new system with the same database. Is it possible to somehow install the new Redmine and then replace the initial default database with my productive database that I will have in the meanwhile upgraded to the new version? If yes, I suppose I need a script or command to upgrade it. Could someone with experience enlighten me?

thanks in advance!

Replies (4)

RE: Upgrade Db only - Added by Ivan Cenov about 5 years ago

Many things have changed after Redmine 1.2.1. See what is needed for Redmine 2.1.3 at RedmineInstall.
Redmine 1.2.1 didn't use bundler, while since 1.4.0 Redmine has used bundler.
Also Rails versions are different.
Another difference is plugins incompatibility. You have to find plugin versions that are compatible with 2.1.3.
If you use mysql you have to switch to mysql2 adapter.
If you use mongrel as server, now you may have to switch to thin (on Windows).
It is better to upgrade Ruby from 1.8.7 to 1.9.3p194 (not 1.9.3p327 which has bugs).

Yes, it is possible to upgrade to 2.1.3, just you have to plan this movement well. May be you have to upgrade to 1.4.x first and then to 2.1.3?

RE: Upgrade Db only - Added by Etienne Massip about 5 years ago

This should be possible to upgrade your db to 2.1.3 easily.

Simply install Redmine 2.1.3 following RedmineInstall with your old db instead of creating an empty one; when it comes to run migrations (rake db:migrate) your database will be updated.

Just skip Step 7 - Database default data set.

RE: Upgrade Db only - Added by Etienne Massip about 5 years ago

As Ivan said, the uncertain part is plugins and specifically those altering the database with migration.

You might have to uninstall them and run their migrations down before removing them actually and start the upgrade.

RE: Upgrade Db only - Added by Michalis Miatidis about 5 years ago

Thanks a lot for the answers. Finally, I managed to install Redmine 2.1.3, directly upgrade database to new version and it seems to work well without problems!

(1-4/4)