All versions of this manual
X
 

User-data store: Migrating to MySQL

The default storage system for Linkurious is SQLite.

Configuring Linkurious to work with MySQL is a really easy procedure if you don't need to migrate data from SQLite.

Migrating data from SQLite to MySQL is possible but it is a procedure we would recommend only if restarting from scratch with MySQL is not a viable option.

This is the procedure to dump data from SQLite:

sqlite3 ./linkurious/data/server/database.sqlite .dump > export.sql

This is the procedure to import data into MySQL:

mysql -u MY_MYSQL_USER -p -h 127.0.0.1 linkurious < export.sql

The SQL file format from SQLite and MySQL is not exactly the same. If you need help with the procedure please contact us at support@linkurio.us.