Issue when migrate Kanboard from sqlite3 to mysql (all table doesn't exist)

[minhhieple97]

I'm migrating kanboard from sqlite to mysql, i have created db-mysql.sql and run command souce db-mysql.sql. But it seem that file db-mysql.sql has not created tables like users, tasks.... The error shows up like this

I logged the first 50 lines of file sql dump and output looks like this

Has anyone encountered this problem ?

[oliviermaridat]

It's been a long time since I checked this script. On top of my head I have: "Are you sure you database is named kanboard?"

[minhhieple97]

thank you for replying, i have already database with kanboard

The problem I think is that the .sql dump file is missing the commands used to create tables like user, task.... This is the first 10 line of sql dump file, there is no command to create tables

Do you have any suggestion ?

[oliviermaridat]

To be honest I do not remember how this script is working, and currently no time to dig into it.

Since you have already well analyzed the issue ( :tophat: ), may I suggest:

• Verify other tickets to get sure no one already find a solution for that
• Dig in the beginning of the script to understand why the tables are not created

Good luck!

[PM84]

Yes your finding is correct. To fix the Problem.

1. Create a mysql db
2. Configure the board to use the mysql db
3. Just call the Url of the Board and login (User:admin pwd: admin)

=> the tables were created automatically.

4. Run the migration script