Project

General

Profile

Forums » Help »

migrating to new version of redmine, database problems.

Added by John Simmons almost 10 years ago

Migrating from ubuntu 12.04 with redmine 1.3.2.stable
Migrating to ubuntu 14.04 with redmine 2.5.1.stable.13182

My issue is that once I had the 2.5.1 with ubuntu 14.04 set up, I tried to migrate the database. The old version uses the database name redmine_default. The new version uses the database name redmine. I have the old database on the new computer, with the name old.database.sql.

When I run the command "mysql -u root -p redmine < old.database.sql" It throws no errors, but when I go in and look at the tables, it has added a new database called redmine_default, with all of the information in it. The redmine table stays empty. When I tried to only move a table from the old redmine_default database into the new redmine database, it broke the whole site, and showed an error page that said to contact the site admin (which is me, and I also didn't get exactly what the error message said).

I had the config/database.yml setup correctly each time I tried, and did run service apache2 restart each time I made a change.

If anyone has any ideas on how to migrate this database I would greatly appreciate any help. Also, here are the guides I went by to set up each.
old redmine server: http://www.redmine.org/projects/redmine/wiki/HowTo_Install_Redmine_on_Ubuntu_step_by_step
new redmine server: http://martin-denizet.com/install-redmine-2-5-x-git-subversion-ubuntu-14-04-apache2-rvm-passenger/


Replies (1)

RE: migrating to new version of redmine, database problems. - Added by Anonymous almost 10 years ago

John,

a very convenient way to migrate databases is use of phpmyadmin. Set it up for source and target DB/machine. Go to phpmyadmin on old machine, do a full export (don't forget to check drop table option otherwise data will be imported incrementally). Store export on file system. Go to phpmyadmin on new machine and import the export-file.

Be aware that your new database follows the schema of the old redmine version

Do DB-Migration. DB-names do not matter.

Give it a try!

cheers

Alex

    (1-1/1)