Successful migration / Kanboard 1.2.9 / 17GB SQLite file

[xenadmin]

Thank you very much for this project. I don't want to sound rude, but the readme needs some polish.

Here are my steps:
Starting point:

• Debian 10
• SQLite Database with ~17GB
• SQLite Schema 120
• MariaDB 10.3
• Kanboard Version: 1.2.9

1. Shutdown the VMware VM, create a Snapshot
2. Install LVM2 and create a new logical drive for the MariaDB /var/lib/mysql
3. Mount a 100GB temp HDD for the dump
4. Stop Apache2, so not database changes occur during the dump.
5. Create the MySQL Dump: ./kanboard-sqlite2mysql.sh /var/www/html/kanboard -o /mnt/db-mysql.sql
6. Edit the Dump (text) file and add the three lines for the encoding
7. Install the missing dependency apt install php-mysql
8. Create the database, import the database schema:

CREATE DATABASE kanboard CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALTER, CREATE, DELETE, DROP, INDEX, INSERT, REFERENCES, SELECT, UPDATE, LOCK TABLES ON kanboard.* TO 'kanboard'@'LOCALHOST' IDENTIFIED BY 'password';
export DATABASE_URL="mysql://kanboard:password@localhost/kanboard"
php /var/www/html/kanboard/app/common.php

10. Import the dump: mysql -u root -p kanboard < db-mysql.sql
11. Wait 3 and a half days because you forgot to tune the default MariaDB settings. (I let the import run in a tmux session)
12. Edit or copy to you have a config.php and configure it for MySQL/MariaDB
13. Start Apache2
14. Profit.

Nice to know, my 17GB SQLite Database uses now 21GB of the LVM2 volume.

I will now upgrade to the current Kanboard version.