Login
Register
Home
Help
Search
Login
Register
<< back to pipelinefx.com
PipelineFX Forum
Pipelinefx
Announcements
(Moderator:
jburk
)
Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL)
« previous
next »
Print
Pages: [
1
]
Author
Topic: Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL) (Read 11842 times)
shinya
Administrator
Posts: 232
Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL)
«
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
Logged
Print
Pages: [
1
]
« previous
next »
PipelineFX Forum
Pipelinefx
Announcements
(Moderator:
jburk
)
Fix for DB migration/transfer process from Qube 6.x to 7.x (MySQL to PostgreSQL)