Upgrade Redmine 2.4 to Redmine 3.2:import database

After install Redmine 3.2, your may import the data from old version redmine to Redmine 3.2.

1) Create A new clean database

sudo mysql-u root-pdrop database redmine

CREATE DATABASE redmine character SET UTF8; CREATE user ' redmine ' @ ' localhost ' identified by ' My_password '; GRANT all privileges on redmine.* to ' redmine ' @ ' localhost ';

2) Import old Redmine database to new Redmine

/usr/bin/mysql-u root-p Redmine </redmine_db_dir/redmine_db_16_02_27.sql

3) Generate new Secret and Update db and plugins

sudo su-redminecd redminerake generate_secret_tokenrake db:migrate rails_env=productionrake redmine:plugins:migrate Rails_env=productionrake Tmp:cache:clearrake Tmp:sessions:clearexit

Upgrade Redmine 2.4 to Redmine 3.2:import database