Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums
  • Feature tour
    Feature tour

Content

You are here:
  1. Forums
  2. Support Installation & Updates

Migrating and upgrading

Added by Phason Electronics about 6 years ago

Hello,

We have OpenProject 7.4.7 running on an Ubuntu 14.04 server. We are setting up a new server with Ubuntu 18.04 and have installed OpenProject 8.0 on it. We need to migrate our data from the old server to the new one. What is the best method to do this? Can we simply export the data from 7.4.7 and then import it into the 8.0 database?

Regards,

Chris


Replies (1)

RE: Migrating and upgrading - Added by Oliver Günther about 6 years ago

Hello Chris,

yes, this will work without issues. You can create a backup of your entire installation with openproject run backup. Note that in versions before 8.0. the backup script was not able to dump PostgreSQL databases. This has been added in 8.0. If you have a PostgreSQL installation, you can backport the script from 8.0. For more information, see here: https://community.openproject.com/topics/9755

openproject run backup  will output multiple files into /var/db/openproject/backup

attachments-.tar.gz>: The attachments from /var/db/openproject/files. On a new machine, simply extract this archive there and ensure permissions are set correctly with chown -R openproject:openproject /var/db/openproject/files

conf-.tar.gz: The configuration files from /etc/openproject. This contains your input to the wizard upon first installation. Please note that some values will have to be changed on a new machine such as server/hostname or (if configured) the MySQL passwords. In doubt, leave that step out and use openproject configure on the new machine to run through all configuration steps again.

mysql-dump-.sql.gz / postgresql-dump-.pgdump: The database dump, on your new machine, restore this with

  • (MySQL): > zcat mysql-dump-.sql.gz | mysql -u -h -p
  • (PSQL): > pg_restore -h -u -W postgresql-dump-.pgdump

svn/git-repositories-.tar.gz: The dump of the repositories (if any) from /var/db/openproject/svn or /var/db/openproject/git (unless you have configured these folders to be elsewhere). Same as attachments, copy to new location and restore.

Also note that you need to run openproject configure on the restored database at least once with your 8.0 installed version to ensure that migrations are being run. This is the same step as upgrading the old machine.

In part, this has been documented in the Backup Guide for packaged installations and the Migration Guide for packaged installations. However both guides are lacking somewhat, I have upgraded them accordingly.

Best regards,

Oliver

Resources

  • Packaged installation backup guide (linked above)
  • Manual installation backup guide
  • Docker-based installation backup guide
  • Migration to a new environment on packaged installations (linked above)
  • (1 - 1/1)
Loading...