Need help migrate Redmine 1.3.2.stable (MySQL)

Added by Bernhard Schulz 29 days ago

Hello!

I am running an old Ubuntu Server 12.04 LTS with Redmine 1.3.2.stable (MySQL).

I need help to upgrade/migrate my system to the latest Redmine version.

I tried to do a "release upgrade" to Ubuntu 14 Server, but that deletes my Redmine installation during the upgrade process.

I guess, it would be best to provide a new Ubuntu 18 LTS Server and then copy the data from the old Redmine to the new Redmine installation, but I do not know how, because I am pretty sure the database structure changed, so I cannot import the MySQL dump from the old installation to the new one. I read about "rake" and updates, but I am not a Ruby guy, so I do not know how it works.

There is only one plug-in: Stuff To Do Plugin Version 0.4.0, but I do not need it. We could get rid of it.

So I need help, maybe via Teamviewer and email, to migrate everything.
I could prepare things (a new Ubuntu 18 Server with a fresh Redmine for example).

Please offer your help along with your hourly rates here in the forum or at
Payment could be done via PayPal.

PS: Since there is some confidential data, I cannot provide a dump to do some conversion off-site. It has to be done on my server by myself.

Thank you,
Berni

Replies (3)

RE: Need help migrate Redmine 1.3.2.stable (MySQL) - Added by Andriy Lesyuk 9 days ago

Hi, Bernhard!

Generally, all that you need to do is the following:

  • Make a database dump of your old Redmine installation
  • Install the new server with new fresh Redmine
  • Restore the database from the dump overriding the database of the just-installed fresh Redmine
  • Run: bundle exec rake db:migrate RAILS_ENV=production

This rake command is intended for making sure, that the database structure is ready for the current version of Redmine. So, it should be safe to upgrade your very old Redmine in this way. In any way, you are better to make a test by doing this on some virtual machine, for example.

Andriy

RE: Need help migrate Redmine 1.3.2.stable (MySQL) - Added by Jens Krämer 8 days ago

Don't forget to save / restore the files folder from inside the old Redmine installation as well - it contains all attachments / documents.

RE: Need help migrate Redmine 1.3.2.stable (MySQL) / PROBLEM SOLVED! - Added by Bernhard Schulz 2 days ago

Thank you Andriy!
I was not aware of the fact, that it is that simple.
Dump the old DB, restore the old DB to a new server.
Install Redmine.
Run "rake".

It worked perfectly!

I used this opportunity to put redmine into a docker container and everything is up and running.

Thank you - your hint, that it is that easy was the key to solve me problem!

PS: Thank you Jens for your reminder!

(1-3/3)