Content

Convert SQLite into MySQL

MysqlSqlite

This manual guides how to convert sqlite database into mysql, for example if you want to migrate data from Redmine with SQLite into Easy Redmine.

Preconditions:

Easy Redmine on Linux environment, python installed (2.7.12), sqlite3 3.11.0 installed (by default available in our provided VMs)

  1. From your current Redmine machine create sqlite3 dump and transfer into the ER machine.
  2. Create new mysql database
    mysql -u root -p
    create database sqlite3_convert char set utf8mb4 row_format = dynamic;
    exit;
  3. Download this converter and place it on your server
  4. From root user (or sudo) run the next command
    sqlite3 SQLITE3_DUMP_FILE.sqlite3 .dump | python sqlite3-to-mysql.py | mysql -u root -p sqlite3_convert
  5. Wait. It will take about 10 minutes for script to fill in your new database with converted data

Easy Redmine 2019 Free Trial

Full-featured, 30 Days, SSL protected, Daily Backups, In your Geo Location

or