一 :文件和数据库备份
备份原Redmine以下目录和文件:
sudo cp -r /etc/redmine/default/email.yml ~/backup/
备份原redmine数据库:
mysqldump -uroot -ppassword -B redmine_default >~/backup/redmine_back130501.sql (-u+用户名 -p+密码 )
将以上备份内容拷贝至新Redmine服务器的用户目录下面;
scp -r proto@192.168.1.23:~/backup ~/
二 :文件和数据库恢复
恢复文件:
cd /var/lib/redmine/default/
sudo rm -rf files
sudo cp -r ~/backup/files ./
cd /etc/redmine/default/
sudo cp -r ~/backup/email.yml ./
恢复数据库:
mysql -uroot -ppassword
drop database redmine_default;
drop user 'redmine'@'localhost';
create database redmine_default character set utf8;
create user 'redmine'@'localhost'identified by 'password';
grant all privileges on redmine_default.* to 'redmine'@'localhost'identified by 'password';
quit;
/etc/init.d/mysql restart
mysql -uroot -ppassword < ~/backup/redmine_back130501.sql
重新启动redmine:
cd /usr/share/redmine
rake db:migrate RAILS_ENV="production"
sudo /opt/nginx/sbin/nginx -s reload
问题汇总:
1.redmine 部分页面显示如下:
Internal
error
An
error occurred on the page you were trying to access.
If
you continue to experience problems please contact your redMine administrator for assistance.
解决办法:
cd
/usr/share/redmine
sudo rake
db:migrate RAILS_ENV="production"
sudo
/opt/nginx/sbin/nginx -s reload
2.执行rake db:migrate RAILS_ENV="production"时如下报错:
Mysql::Error:
Table 'changeset_parents' already exists: CREATE TABLE `changeset_parents`
(`changeset_id` int(11)NOT NULL, `parent_id` int(11) NOT NULL) ENGINE=InnoDB
解决办法:
1、登录http://192.168.1.123/phpmyadmin,删除redmine_default数据库中changeset_parents的表;
2、登录mysql使用drop
table 命令删除redmine_default中的changeset_parents表;
cd
/usr/share/redmine
sudo rake db:migrate RAILS_ENV="production"
3.执行rake db:migrate RAILS_ENV="production"时如下报错:
rake aborted!
Access denied for user 'redmine'@'localhost'(using password: YES)
解决办法:
确认/etc/redmine/default/database.yml文件中password项密码与redmine_default一致;