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. Migrating from MySQL to PostgreSQL

Migrating from MySQL to PostgreSQL

Added by Dennis Aspö over 5 years ago

I'm trying to migrate from MySQL to PostgreSQL and I am following the guides, but I have two problems.

  • The guide says "Please note: Ensure that the URL starts with mysql:// , not with ` mysql2://` !"

Well it does start with mysql2 for me. What am I supposed to do about that? The guide only says this is important but not why or what can be done about it.

  • I went through all the steps anyway and tried running the migration script but I get this error

sudo openproject run ./docker/mysql-to-postgres/bin/migrate-mysql-to-postgres
sh: /opt/openproject/docker/mysql-to-postgres/bin/migrate-mysql-to-postgres: File or catalog does not exist

So I am lacking this file for migrating, Is it because my version of OpenProject is too old? It's version 7.4.7


Replies (2)

RE: Migrating from MySQL to PostgreSQL - Added by Dennis Aspö over 5 years ago

I installed the latest OpenProject and I also had to install the latest PostgreSQL and then the migration worked. 

However NOW it refuses to work when I run openproject reconfigure. I get this same bug:

https://community.openproject.com/projects/openproject/work_packages/31567/activity

I need to have openproject running and I can't wait for this to be fixed, if it ever will be fixed. Needing this running now.

RE: Migrating from MySQL to PostgreSQL - Added by Dennis Aspö over 5 years ago

Skipping the migration of the offending module helped me get the new openproject running.

openproject OPENPROJECT_SKIP_TEXTILE_MIGRATION="true"

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