Successful Migration Kanboard 1.2.35 - Githubissues

oliviermaridat / kanboard-sqlite2mysql

Guidelines to migrate a Kanboard SQLite database to a MySQL database

44 stars 11 forks source link

Successful Migration Kanboard 1.2.35 #36

Open glimfindel opened 6 months ago

glimfindel commented 6 months ago

I just did a migration with Kanboard 1.2.35, PHP 8.1, Ubuntu 22.04. As already mentioned in #30 I stumbled into the issue concerning the misspelled line feed character "\n" and some not available fields. The solution I found included "sed" and the integrated db migration script, so I ended up with this step-by-step list (using bash):

Source system:

./kanboard-sqlite2mysql.sh \<kanban directory> -o kanboard-mysql.sql
sed -i 's/\\n/\n/g' kanboard-mysql.sql

Destination system:

\<cd into the kanban directory>
systemctl stop apache2
mysql -h localhost -u kanboard -p kanboard < app/Schema/Sql/mysql.sql
systemctl start apache2
\<open the login page with yout browser, but don't log in>
mysql -h localhost -u kanboard -p kanboard < kanboard-mysql.sql