How do I switch db from sqlite to mysql from a Debian installation?

1

I am setting up Vikunja using the Debian package. How do I change the database away from sqlite to mysql? I updated the database section in /etc/vikunja/config.yml. How do I tell Vikunja to generate the scheme in mysql?

2

I migrated from sqllite to mysql on Ubuntu with the following steps:

  1. make a backup of my vikunja data with the vikunja cli
  2. create a mysql user and database (empty, no scheme) for vikunja
  3. edit config.yml user and database
  4. restart vikunja
  5. import my vikunja backup via cli

Hope that helps!

3

So far the only way for me to create the new schema is by spinning up an instance using Docker, export out the scheme from Docker and then import it into mysql.

4

Dump and restore are the only way to do this in Vikunja.