Medina's picture

hello, I need to migrate the old turnkey redmine to a new one, I want to do it manually without TKLBAM, I can’t find documentation on migration, I don’t know where to start and what to configure, because it’s not clear at all, and regarding the database, in the old The muscle scheme is different from the old one, if I dump the database and migrate tables or columns one at a time, won’t anything break? Give me your advice on how to migrate

Forum: 
Jeremy Davis's picture

Hi there. Have a look at the Redmine docs to back up your existing Redmine DN and files. As noted on that page, your files will be in the configured 'attachments_storage_path' - which by default should be 'files/' directory within your Redmine install path.

Once you have created your DB dump, then you can transfer it and your Redmine files directory to your new server using rsync. Something like this should do the trick:

rsync azP path/to/db-dump root@NEW_SERVER_IP:~/
rsync -azP /var/www/redmine/files root@NEW_SERVER_IP:/var/www/redmine/files

On your new server, restore your DB.

Then treat it like it's a Redmine upgrade on the new server to import your data into the newer Redmine version.

I'm glossing over the details, but that should be enough to get you going in the right direction. Any issues, feel free to post back. The more info you can provide about what you've done, where you've got to and what's not working, the easier it will be to help you.

Good luck! :)

Medina's picture

Thank you! Do you have a turnkey version of ISO 13? because we can't install sig on debian 12. We installed version 14 of Turnkey and decided to migrate version 13 there, or will it lead to a breakdown?

I noticed that database schema 14 is different from turnkey 13, maybe I should manually migrate each column? But in general, after successfully transferring files and a database, I should immediately go to the account that is in the database? help with advice on how to transfer the database

Jeremy Davis's picture

Hi Medina, I've responded in detail to your Hub support post re migrating using TKLBAM. You may no longer need these questions answered, but for completeness, I'll answer these questions here too.

Do you have a turnkey version of ISO 13? [...] We installed version 14 of Turnkey and decided to migrate version 13 there, or will it lead to a breakdown?

Unfortunately, as you've probably noticed, the oldest version we still have on our mirror is v14.2. You may find older versions somewhere online (I recall that there was an old mirror somewhere). Another option may be to use archive.org (aka "wayback machine") although I can't confirm.

Manually migrating from v13.x to v14.2 should go ok. Although as I don't have a copy of v13.x available and wasn't as closely involved with TurnKey back then, I'm not 100% sure. Having said that, gauging from your Hub support request, I'm guessing that you managed it ok?

I noticed that database schema 14 is different from turnkey 13, maybe I should manually migrate each column? But in general, after successfully transferring files and a database, I should immediately go to the account that is in the database? help with advice on how to transfer the database

The Redmine upgrade process should migrate the database schema from the old layout to the newer one. Having said that, to load in your database content, you may need to manually drop the existing DB.

To do that, first check the database name (IIRC it should be "redmine" but I'm not 100% sure). Do that like this:

mysql -e "SHOW databases;"

Then assuming that it is called "redmine", drop it like this:

mysql -e "DROP DATABASE redmine; "

Add new comment