Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Successful Migration Kanboard 1.2.35 #36

Open
glimfindel opened this issue May 13, 2024 · 0 comments
Open

Successful Migration Kanboard 1.2.35 #36

glimfindel opened this issue May 13, 2024 · 0 comments

Comments

@glimfindel
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant