Move from one Redmine server to another, with different versions of Redmine?
Added by Patrik Fältström over 14 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 over 14 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 over 14 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