Redmine

nevermind. I'll post here what i did in order to get it right:
- first, install redmine in a fresh postgre database
- then, copy (i did it table by table) the rows from every table from the mysql database to the postgresql, truncating the postgresql tables first.
- select max(id) from MyTable; => max(id) + 1 (MaxIdPlusOne) => use that number in an ALTER SEQUENCE MyTable_id_seq RESTART with MaxIdPlusOne; That for every table with a sequence.
And you should be good to go.

Hi,

I am facing to the same problem. Except I am trying to migrate from PostgreSQL to MySQL.
Could someone have some hits to do that ?

I am currently using:
- the pgsql_dump command with special parameters;
- the sqlt command to convert the dump to MySQL.

And I am having still some errors.

Any help would be appreciated :)

You generally can't just "sqldump" activerecord/rails data from one DB type to another, as the adapters have database-specific optimizations.

There are different means to transfer the data from one DB type to the other though, your could try taps, see also this article about its usage: http://adam.heroku.com/past/2009/2/11/taps_for_easy_database_transfers/

Thank you for your help.

I read about your links and taps. And I was finaly able to migrate my redmine database from postgresl to mysql, without any errors. It is really a powerfull tool :)

+1 for the taps method, works fine with SQLite 3 -> PostgreSQL. OTOH it failed when I tried to convert to MySQL.

Is there anyone successful with this method while trying to migrate from MySQL to PostgreSQL?

I've just migrated a Redmine installation from MySQL to PostgreSQL using mysql2psql using the process below. Starting with a working Redmine installation running on Passenger and MySQL; and PostgreSQL is available on the same host.

Create a PostgreSQL database.
SSH into your host, then:

gem install mysql2psql
mysql2psql

This creates a blank configuration file. Edit it to set the connection details for your mysql database and new postgresql database. I added an encoding setting to source and destination based on my existing database config even though an encoding setting was not in the sample config: encoding: utf8

vim mysql2psql.yml

Run the transfer:
mysql2psql

Edit Redmine database config.

cd ~/rails_apps/redmine-2.2.0/config
cp database.yml database.yml.backup
vim database.yml
cd ..

Create (or edit) Gemfile.local to install the postgresql adapter:
vim Gemfile.local

# Gemfile.local
gem 'activerecord-postgresql-adapter'

Restart Passenger:
touch tmp/restart.txt

Refresh the web browser and log in to Redmine.

Vincent Lizzi wrote:

I've just migrated a Redmine installation from MySQL to PostgreSQL using mysql2psql using the process below. Starting with a working Redmine installation running on Passenger and MySQL; and PostgreSQL is available on the same host.

Create a PostgreSQL database.
SSH into your host, then:

gem install mysql2psql
...

I can confirm mysql2psql as working. Thank you for this tip.

Just some hints for doing this on a current Ubuntu:

1. apt-get purge ruby-dev libmysqlclient-dev postgresql-server-dev-all
2. apt-get autoremove
3. apt-get autoclean

This should help to keep your system clean.

HTH

I successfully used yaml_db to do this migration, making sure to migrate the destination db only up to the db version of the data I was going to seed it with (after which I proceeded to migrate it the rest).

anyone successfully migrate from sqlite to postgresql?

easy steps for migartion

http://www.redmine.org/boards/1/topics/58263

an an option, you may consider Ispirer SQLWays Wizard for mysql to postgresql migration https://www.ispirer.com/products/mysql-to-postgresql-migration