What to backup

There are two parts you need to back up: The database and attachment files.

Files #

To back up attachments and other files, it is enough to copy them from the attachments folder to some other place.

Database #

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 back up sqllite databases, it is enough to copy the database file to somewhere else.