Migrate a Redmine site to another server

· 1 min read

On current server:

    # service apache2 stop
    # cd /opt/redmine/files
    # scp -r * root@:/opt/redmine/files

Make MySQL backup

    # mysqldump -u root -p redmine >/root/dump.sql
    # scp /root/dump.sql root@1:/root

On new server:

    # cd /opt/redmine/files
    # chown -R www-data:www-data *

Delete test database (is needed) and reload new database

    # mysqladmin -u root -p drop redmine
    # mysqladmin -u root -p create redmine
    # mysql -u root -p redmine 
Reload/migrate redmine data and plugins
    # rake db:migrate RAILS_ENV=production
    # rake redmine:plugins:migrate RAILS_ENV=production

    # rake tmp:cache:clear
    # rake tmp:sessions:clear

    # service apache2 restart

Related Articles

Cleanup Redmine users

Startup MySQL tool # mysql -u root -p redmine Maybe first use below queries with SELECT to see what matches there

· 1 min read