Migrating Redmine from Windows 2008 R2 to Ubuntu 14.04 -- Migration Scripts for Uploaded Files

Added by Erdem Kaya about 7 years ago

Hi everyone,

We have been using Redmine for more than a year in our company. The instance (Redmine 2.3.2) that we have been using is a bitnami redmine stack installation on Windows 2008 R2. We have not made any change in the configuration (i.e. still using MySQL (5.5.32) as the database server, the default directory hierarchy, database server and web server are on the same machine and what not).

We would like to migrate our instance along with its internal configuration (issue types, special fields, etc.), user accounts, and all the data including the documents that have been uploaded by our users so far. To go about doing this, I decided to follow the steps in this link: https://wiki.bitnami.com/Native_Installers_Quick_Start_Guide#How_can_I_create_a_full_backup_of_a_Stack.3f

I believe I can make a new instance run on Ubuntu 14.04 by
  • Backing up my old Redmine database and recovering it on the new Redmine instance
  • Copying all the uploaded files and doing the migration in the database (so that my application can reach the uploaded files?)
  • Doing some other configurations related to web server etc.

doing the migration in the database
In the article, at some point, they mention about migration scipts for the uploaded files:
You should also copy any uploaded files and configuration files. It also could be necessary to run migration scripts to update the database. This depends on the application (i.e. in my case Redmine) itself.

I would be more than glad if anyone could tell me what these migration scripts would be and whether my overall approach has any problem.

Thanks in advance.

Replies (1)

RE: Migrating Redmine from Windows 2008 R2 to Ubuntu 14.04 -- Migration Scripts for Uploaded Files - Added by Tony Ordner about 7 years ago

You should probably be asking on the bitnami forums as the stack may be different from what we would do around here.

Maybe the migration scripts reference is in case the mysql version is different than your existing one? If you export using mysql tools it may make a difference.

I pretty much do a new install and move my files and config. I am using the yaml_db gem to backup and move data since it is database agnostic and it works pretty slick. I have migrated back and forth from mysql to sqlite to mysql and across platforms. So I pretty much do a new install every time then restore the data.

hope this helps