Move from one Redmine server to another, with different versions of Redmine?

Added by Patrik Fältström almost 15 years ago

I am on my way to move 100% of the content of one remine server to another one, one that is already at a higher version number (the 0.9.x-stable branch).

Am I correct that I can do the following:

1. mysqldump the complete old database in the old system

2. Load the mysqldump in the new database (on the new system)

3. Start on "Step 4 - Update the database" (as found on on http://www.redmine.org/wiki/redmine/RedmineUpgrade)

What confuses me a bit are what other things might be broken because of this move. I specifically see the note VERY IMPORTANT: do NOT overwrite config/settings.yml with the old one.

I have verified that the new redmine system is working. And I do not mind wiping all data in it.

Or have anyone already done some more clever dump/restore things that do handle cross-versioning export/load?

Patrik

Replies (2)

RE: Move from one Redmine server to another, with different versions of Redmine? - Added by Anonymous almost 15 years ago

Hi Patrik,
When I moved Redmine from an old machine to a new machine a few month ago, there were three main things that must be copied over: the Subversion repository, the Redmine database and the Redmine uploaded file attachments. My process was much more complicated because we have a lot of Subversion hooks, mail configuration, etc, so there's no point in me giving you the full process. However, here's the bit out of the process that I recorded for copying over the main chunks:

Copy over the latest Redmine database, Redmine files and Subversion from the old dev box:

sudo svnadmin dump /var/svn/repository > /tmp/svn_repository.dmp
gzip /tmp/svn_repository.dmp
tar czf /tmp/redmine_files.tar.gz -P /var/www/apps/redmine
mysqldump -uredmine redmine > /tmp/redmine_backup.sql
gzip /tmp/redmine_backup.sql
cd /tmp
scp svn_repository.dmp.gz redmine_backup.sql.gz redmine_files.tar.gz workbooks@172.16.19.85:

Back on the new dev box, drop and recreate the redmine database:

mysql -uroot -p
drop database redmine;
create database redmine character set utf8;
grant all privileges on redmine.* to 'redmine'@'localhost';
exit

Restore the Redmine database:

gunzip redmine_backup.sql.gz
mysql -uredmine redmine < redmine_backup.sql

Restore the Redmine file attachments and set permissions:

tar xzf redmine_files.tar.gz
sudo chown -R www-data:www-data /var/www/apps/redmine/*

Restore the SVN repository:

gunzip svn_repository.dmp.gz
sudo mv /var/svn/repository /var/svn/repository.test
sudo svnadmin create /var/svn/repository
sudo svnadmin load /var/svn/repository < svn_repository.dmp

The first time I did it I forgot the file attachments - they aren't stored in Redmine's database - they are in the redmine application directory on the filesystem.

Hope that helps,
Jonathan.

RE: Move from one Redmine server to another, with different versions of Redmine? - Added by Patrik Fältström almost 15 years ago

Jonathan!

Thanks for this help. FWIW, I did not have any SVN repository, so I could skip that part, BUT, part from that:

1. Your instructions above

2. The instructions on the upgrade page, from step 4 (rake upgrade of the database structure)

...things went more smoothly than I thought!

Hope other people also can be helped by these notes.

Patrik

(1-2/2)

Project

General

Profile

Redmine