Project

General

Profile

Where is the actual redmine Mysql database located (release 1.2.0.)?

Added by Stephan Kubisch over 9 years ago

Hi,

I am currently trying to upgrade our (old) redmine system to the latest version 2.6.1. .
Our existing redmine solution is of version 1.2.0. .
(I know, this version is already somewhat "aged"...until now there was no need and reason for us to update it...never change a running system).

I already worked through different forum threads and the installation guides but still I need help.
First question is:
Everywhere is mentioned to make a back up of the existing Mysql database.
But where is it located in version 1.2.0? What are the actual data base files that are used?
When logging into mysql with

mysql -u root -p 
Password: ****

and listing all the databases, it shows me the following:
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| redmine            |
| test               |
+--------------------+
5 rows in set (0.01 sec)

Now, I would think that the database redmine uses is "redmine".
When I make a backup if this database using
/usr/bin/mysqldump -u <username> -p<password> <redmine_database> | gzip > /path/to/backup/db/redmine_`date +%y_%m_%d`.gz

the resulting backup is only very small (>2kb) and is basically empty.

The config file my.cnf of mysql in my redmine folder is:

[mysqladmin]
user=root

[mysqld]
basedir=/opt/redmine-1.2.0-0/mysql
character-set-server=UTF8
collation-server=utf8_general_ci
datadir=/opt/redmine-1.2.0-0/mysql/data
port=3308
socket=/opt/redmine-1.2.0-0/mysql/tmp/mysql.sock
tmpdir=/opt/redmine-1.2.0-0/mysql/tmp

[mysqld_safe]
mysqld=mysqld.bin

[client]
default-character-set=UTF8
port=3308
socket=/opt/redmine-1.2.0-0/mysql/tmp/mysql.sock

[manager]
default-mysqld-path=/opt/redmine-1.2.0-0/mysql/bin/mysqld.bin
pid-file=/opt/redmine-1.2.0-0/mysql/tmp/manager.pid
port=3308
socket=/opt/redmine-1.2.0-0/mysql/tmp/mysql.sock

The database.yml in my redmine/config folder is:

[[# MySQL (default setup).

production:
  adapter: mysql
  database: bitnami_redmine
  host: localhost
  username: bitnami
  password: a006c91092
  socket: /opt/redmine-1.2.0-0/mysql/tmp/mysql.sock
  encoding: utf8

development:
  adapter: mysql
  database: redmine_development
  host: localhost
  username: bitnami
  password: a006c91092
  socket: /opt/redmine-1.2.0-0/mysql/tmp/mysql.sock
  encoding: utf8

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  adapter: mysql
  database: redmine_test
  host: localhost
  username: bitnami
  password: a006c91092
  socket: /opt/redmine-1.2.0-0/mysql/tmp/mysql.sock
  encoding: utf8

test_pgsql:
  adapter: postgresql
  database: redmine_production
  host: localhost
  username: postgres
  password: a006c91092

test_sqlite3:
  adapter: sqlite3
  database: db/test.db]]

For me the question now is: Where is database "bitnami_redmine" located? How can I access it with mysql and make a backup? Can I simply copy some files?

I actually have no additional plugins installed, so I would expect to be able to use the same database from 1.2.0 in redmine 2.6.1 after "rake-ing" something...

Thanks in advance.
Stephan