使用bitnami-redmine-2.6.3-0在做数据迁移的时候,可以直接使用其提供的phpadmin来做数据迁移,但是,在数据导入的时候,很有可能出现各项主键冲突的错误,经过实验,需要在执行导入之前先执行下列sql语句删除相关表的数据,即可成功导入
delete from attachments;
delete from boards;
delete from changes;
delete FROM changesets;
delete from code_review_project_settings;
delete from comments;
delete from custom_fields;
delete from custom_fields_trackers;
delete from custom_values;
delete from documents;
delete from enabled_modules;
delete from issue_statuses;
delete from enumerations;
delete from issues;
delete from roles;
delete from journals;
delete from journal_details;
delete from members;
delete from member_roles;
delete from messages;
delete from news;
delete from projects;
delete from projects_trackers;
delete from repositories;
delete from schema_migrations;
delete from tokens;
delete from settings;
delete from time_entries;
delete from trackers;
delete from users;
delete from user_preferences;
delete from user_issue_months;
delete FROM workflows;
DELETE FROM versions;
delete from votes;
DELETE from watchers;
DELETE FROM wikis;
数据迁移完成之后只需要将apps\redmine\htdocs\files以及apps\redmine\htdocs\plugins从老系统上拷贝到新安装的目录下即可,经过测试,所有的数据、附件、插件均能正常工作!