Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

https://docs.openproject.org/installation-and-operations/misc/migration/

Get Backup Files:

sudo openproject run backup
cp /var/db/openproject/backup/*
tar -czvf etcopenproject.tgz /etc/openproject/*

Import database:

PostgreSQL:


pg_restore -U openproject  -d openproject -1 postgresql-dump-*.pgdump


MySQL: (Deprecated)

mysql_secure_installation
mysql -u root -p
CREATE DATABASE openproject CHARACTER SET utf8;
CREATE USER 'openproject'@'localhost' IDENTIFIED BY 'openproject';
GRANT ALL PRIVILEGES ON openproject.* TO 'openproject'@'localhost';
GRANT ALL PRIVILEGES ON openproject_development.* TO 'openproject'@'localhost';
GRANT ALL PRIVILEGES ON openproject_test.* TO 'openproject'@'localhost';
\q
zcat mysql-dump-*.sql.gz | mysql -u openproject -h localhost -p openproject
zcat mysql-dump-*.sql.gz | mysql -u <dbuser> -h <dbhost> -p <dbname>

Extract attachments:

tar -xvf attachments-*.tar.gz
mkdir /var/db/openproject/files/
cp attachment /var/db/openproject/files/ -R
chown openproject:openproject /var/db/openproject/files/ -R

Configurations:

tar -xvf etcopenproject.tgz
cp etc/openproject/* /etc/openproject/ -R
chown openproject:openproject /etc/openproject/ -R
nano /etc/openproject/installer.dat
nano /etc/openproject/conf.d/database
openproject configure
  • No labels