Project

General

Profile

Importing data in to Redmine 2.0.3 - SOLVED

Added by Scott Mehring over 11 years ago

Since I had an issue installing redcase in 0.8.4, I just installed redmine 2.0.3 on a new machine and got everything configured the way I want it. The only problem now is that I have all my data in my old database and need to get it into my new database. I can set everything else up by hand, but we have about 700 issues I want to export from 0.8.4 and import into 2.0.3.

I've installed the redmine_importer plugin, but when I click on the tab in 2.0.3 I just get a blank screen.

Anyone have any ideas on how I can accomplish this?


Replies (6)

RE: Importing data in to Redmine 2.0.3 - Added by Terence Mill over 11 years ago

Why import? Just migrate the old database with redmine itself.
rake db:migrate RAILS_ENV=production

RE: Importing data in to Redmine 2.0.3 - Added by Scott Mehring over 11 years ago

Every time I try to do that I get:

rake aborted!
Access denied for user 'bitnami'@'localhost' (using password: YES)

Tasks: TOP => db:migrate => environment
(See full trace by running task with --trace)

This is a Windows 7 box with UAC turned on (can't turn it off because of domain policies).
I've tried doing this first:

$ mysql -u root -p
mysql> create database database_name;
mysql> grant all privileges on database_name.* to 'bitnami'@'localhost'
identified by 'BITNAMI_USER_PASSWORD';
mysql> flush privileges;
mysql> exit;

Then running the rake command.

I've tried first doing: set RAILS_ENV=production
Then doing: rake db:migrate

Each time I get the same error message.

RE: Importing data in to Redmine 2.0.3 - Added by Scott Mehring over 11 years ago

OK, I've gotten a step further. I changed the user and password in the database.yml file to match that of my database. Then I did the same commands:
set RAILS_ENV=production
rake db:migrate

I'm getting the errors seen in the screenshot attached. Thanks in advance for the help!

RE: Importing data in to Redmine 2.0.3 - Added by Scott Mehring over 11 years ago

Holy Sh1t, I figured it out!

The db:migrate eventually worked. Here's all the steps I had to take to get it working and upgraded.

1. Copy the installdir/mysql folder from my old machine to my new machine (making sure to make a copy of my new, fresh database first!)
2. Edit database.yml from the following location installdir\apps\redmine\htdocs\config
3. Under the production header, changed username to 'root' and the password to my root password
4. Ran the "Use BitNami Redmine Stack" command from Start -> All Programs
5. CD to installdir\apps\redmine\htdocs
6. Ran the command set RAILS_ENV=production
7. Ran the command rake db:migrate HOORAY, IT FINISHED

This actually took me a couple tries, putting a copy of my "old" mysql database on the new server again. The first time I ran through it I got an error about the member_roles table and I did the instructions here: http://www.redmine.org/projects/redmine/wiki/RedmineUpgrade (at the bottom), but it ended up not working for me.

8. All that was left was to copy over all the attachments. I copied them from 0.8.4 (installdir\apps\redmine\files) to the correct folder in 2.0.3 (installdir\apps\redmine\htdocs\files)

I wanted to say thanks to Terence who led me down this path, otherwise it would have been a long grueling week (or more) exporting and importing all these issues and settings.

RE: Importing data in to Redmine 2.0.3 - SOLVED - Added by Jasen Burkett about 9 years ago

Terence Mill, can you please and or others please help me.

I basically did the same thing, I used mysqldump to dump my existing database into a sql file.
I then put that file into my new redmine install with a clean database called redmine

I then try to do the rake db:migrate RAILS_ENV=production

I then get errors!

I NEED to get this fixed and am not getting any help at all. Please help.

    (1-6/6)