What to backup #

Vikunja does not store any data outside of the database. So, all you need to backup are the contents of that database and maybe the config file.

MySQL #

To create a backup from mysql use the mysqldump command:

mysqldump -u <user> -p -h <db-host> <database> > vkunja-backup.sql

You will be prompted for the password of the mysql user.

To restore it, simply pipe it back into the mysql command:

mysql -u <user> -p -h <db-host> <database> < vkunja-backup.sql

PostgreSQL #

To create a backup from PostgreSQL use the pg_dump command:

pg_dump -U <user> -h <db-host> <database> > vikunja-backup.sql

You might be prompted for the password of the database user.

To restore it, simply pipe it back into the psql command:

psql -U <user> -h <db-host> <database> < vikunja-backup.sql

For more information, please visit the relevant PostgreSQL documentation.

SQLite #

To backup sqllite databases, it is enough to copy the database elsewhere.