PipelineFX Forum

Pipelinefx => Announcements => Topic started by: shinya on November 28, 2018, 07:39:39 AM

Title: Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL)
Post by: shinya on November 28, 2018, 07:39:39 AM
Greetings, all!

We have discovered that the supervisor DB migration process from Qube 6.x to 7.x, from MySQL to PostgreSQL, can fail if the Qube 6.x supervisor has gone through upgrades.

We have patched the export_data_from_mysql.py script, and also added an additional required SQL script, fix_mysql_column_orders.sql, and made them available
for download on our "db_migration_tools" download page at http://repo.pipelinefx.com/downloads/pub/db_migration_tools/ .

If you're having difficulty importing the data into PostgreSQL, please (re-)download both of these files and start over with the updated instructions available at:
http://docs.pipelinefx.com/display/QUBE/Transferring+data+from+MySQL+to+PostgreSQL