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
    • Upgrade to Enterprise edition
    • 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

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. [SOLVED][PostgreSQL] Error during migration: File not found

[SOLVED][PostgreSQL] Error during migration: File not found

Added by Johan Bouduin over 5 years ago

I'm trying to migrate from MySQL to PostgresSQL in order to upgrade OpenProject to v.10.

OpenProject v.8.3.2 is running on Ubuntu 18.04.

I follow all the steps explained here:
https://www.openproject.org/operations/migration-guides/migrating-packaged-openproject-database-postgresql/

Everything's fine until I try to run the migration tool, where it says that './docker/mysql-to-postgres/bin/migrate-mysql-to-postgres' is not found.

Should I first update to V9.x to get that file?

any help appreciated

Johan


Replies (3)

RE: [PostgreSQL] Error during migration: File not found - Added by stefano marty over 5 years ago

Well, I'm not an expert, but I think you should upgrade to v.9 before migrating to PostgresSQL, as explained in this page:
https://www.openproject.org/deprecating-mysql-support/

BTW, I'm having a different error while running the migration tool:
https://community.openproject.com/topics/11271

Hope you can migrate your DB without errors.

Best.

RE: [PostgreSQL] Error during migration: File not found - Added by Oliver Günther over 5 years ago

Hi Johan,

yes the migration script was added in 9.0.. You can safely upgrade your package to 10.0 before running the migration script. Your database will be unchanged until you run openproject configure (which in 10.0., would fail if you still use MySQL).

So either works:

  1. Upgrade to 9.0.3
  2. Convert the database
  3. Upgrade to 10.0

or

  1. Upgrade to 10.0
  2. Run the postgres migration
  3. Run openproject configure after the migration

Best,

Oliver

RE: [PostgreSQL] Error during migration: File not found - Added by Johan Bouduin over 5 years ago

Hi Oliver,

I used the second scenario (upgrade directly to V10) and I can tell: it worked like a charm!
So I'm excited to discover all the new features myself now.

Thanks  a lot
Johan

  • (1 - 3/3)
Loading...