Upgrading SQL tables from Redmine 2.3.1 to 2.4.3
Hi, I have been asked to move a Redmine 2.3.1 installation from a cloud server to our inhouse server. We used a bitnami stack installation of Redmine but no one seems to know where the old Redmine 2.3.1 stack installer is. So I installed the latest that they supply at bitname (2.4.3) and then did a MySQL dump of the data from off-site server and moved it to the inhouse server. Of course, it didn't work since there apparently have been a lot of upgrades done to the database in the intervening releases.
I know Redmine is a Rails app (which I don't know) and I understand that the upgrades it does version-to-version are built-in to the Ruby migration scripts.
Any quick ideas on how to take my 2.3.1 database and get it up to be compatible with 2.4.3 so it won't break immediately? I was hoping there would be a simple MySQL script I could run (possibly one for each release) but it seems I am going to have to do some Ruby "magic" to do this and that is a little scary since I've never done that before.
Help ? :-)
Have you tried?
rake db:migrate RAILS_ENV=production rake redmine:plugins:migrate RAILS_ENV=production
Source: Upgrade HowTo