Where is the actual redmine Mysql database located (release 1.2.0.)?
Added by Stephan Kubisch over 10 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