dump and convert SQL instructions from MySQL to Sqlite

1
2
3

mysqldump --skip-extended-insert --compact -p kanboard > db-myql.sql

mysql2sqlite db-mysql.sql > db-sqlite.sql

create a new kanboard instance with sqlite and dump the DB

1

sqlite3 db.sqlite .dump > db-new.sql

spot schema differences between db-myql.sql / db-new.sql

schema changes in v1.2.47

1. add data for new columns in table:
   • users -- is_admin, is_project_admin
   • projects -- is_everybody_allowed, default_swimlane, show_default_swimlane
   • project_has_users -- is_owner
2. specify column insert order for table tasks
3. prepend pragma statements:

1
2
3
4

PRAGMA journal_mode = WAL;
PRAGMA synchronous  = NORMAL;
PRAGMA foreign_keys = OFF;
PRAGMA user_version = 128;

create the new DB

1

sqlite3 db.sqlite < db-sqlite_patched.sql