All versions of this manual

User-data store: Migrating to MySQL

The default storage system for Linkurious' user-data store is SQLite.

This is the procedure to migrate from SQLite to MySQL.

  1. Export the SQLite database to a file:
    sqlite3 ./linkurious/data/server/database.sqlite .dump > export.sql
  2. Load the exported database into MySQL:
    mysql -u MY_MYSQL_USER -p -h linkurious < export.sql
  3. Update Linkurious configuration to connect to MySQL