Redmine

I have created a python script from your C# code.

mysql -u user -p -e "create database redmine character set utf8;" 
sqlite3 production.db .dump | sqlite3-to-mysql.py | mysql -u user -p redmine

Note that "sqlite3-to-mysql.py" should have execution permission.

I have updated the script for better handling of new lines in text blocks.

Improved sqlite3-to-mysql.py to correctly handling double quotes in multiline text values (and test cases)

sqlite3 production.db .dump | sqlite3-to-mysql.py -u newuser -p newsecret -d newdbname |mysql -u root -p newdbname --default-character-set=utf8

mysql option --default-character-set=utf8 is important to get encoded text correctly imported into mysql

newuser, newsecret and newdbname are the details to connect from redmine:

production:
      adapter: mysql
      database: newdbname
      host: localhost
      username: newuser
      password: newsecret
      encoding: utf8

SQLite has a feature: "A column declared INTEGER PRIMARY KEY will autoincrement" (see SQLite FAQ)

I've updated the script to handle such columns and make them AUTO_INCREMENT in MySQL.

Hello,

I'm running Redmine in a Windows environment. So I can run this script and it will migrate our Redmine from SQLite (default) to MySQL (preferred). Actually, it would be better if we migrated to SQL Server, but I'll take MySQL over SQLite any day.

Thank you...

had a problem where not all was converted to the correct mysql value when a sting stretched across multiply lines, so i replace all newline and carriage return symbol when inside a sting, write the result into a tmp file and the process it, in the end in restore all the newline and carriage return symbol inside the strings, it is not pretty or super fast but only needed to use it once

This script gave me a lot of errors. I recommend the taps method, as per

Installing, Migrating & Upgrading Redmine with LDAP on Ubuntu

Peter Demais sørensen:

Thank you very much for your script! It saves a lot of time - I've just migrated a sqlite3 db to mysql recently. Your script works like a charm.

Peter Demais sørensen
The script worked really well.
Thanks a ton!

Thank you!

The python script works fine but I had to change some parts of the output in order to import it to mysql:

1. PRIMARY KEY
   • output is not in line with mysql requirements
   • output of python script:
     • CREATE TABLE IF NOT EXISTS `wiki_extensions_votes` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY AUTO_INCREMENT NOT NULL, `keystr` varchar, `target_class_name` varchar, `target_id` integer, `count` integer);
   • changed version:
     • CREATE TABLE IF NOT EXISTS `wiki_extensions_votes` (`id` INTEGER AUTO_INCREMENT NOT NULL, `keystr` varchar(255), `target_class_name` varchar(255), `target_id` integer, `count` integer, PRIMARY KEY (`id`) );
2. VARCHAR
   • mysql seems to need a length definition for varchar variables
   • output of python script:
     • CREATE TABLE IF NOT EXISTS `wiki_extensions_votes` (`id` INTEGER AUTO_INCREMENT PRIMARY KEY AUTO_INCREMENT NOT NULL, `keystr` varchar, `target_class_name` varchar, `target_id` integer, `count` integer);
   • changed version:
     • CREATE TABLE IF NOT EXISTS `wiki_extensions_votes` (`id` INTEGER AUTO_INCREMENT NOT NULL, `keystr` varchar(255), `target_class_name` varchar(255), `target_id` integer, `count` integer, PRIMARY KEY);

Thank you!

Edited script python

changed type boolean to INT(11)
changed type varchar to varchar(255)

Hi
Thanks for this python script
But stile has some error.
These tables not create and when alter for create index on sql get error:

1. wiki_content_versions
2. roles_managed_roles
3. time_entries

I recommend using yaml_db to switch databases.