Skip to main content
steven-matison
Platinum ⭐️⭐️
Dec 9, 2022 1:33 PM UTC

@KPG1 Here is a good post i found that describes the required steps to move postgres to mysql including a php to do the postgres to mysql conversion.

 

https://cloudera.ericlin.me/2016/10/hive-metastore-migration-from-embedded-postgres-to-mysql/

 

 

You may need to find a more modern tool for that conversion, but the process to dump, convert, and move metastores should be very similar.

 

1 reply

steven-matison
Platinum ⭐️⭐️
Platinum ⭐️⭐️
Dec 9, 2022 1:33 PM UTC

@KPG1 Here is a good post i found that describes the required steps to move postgres to mysql including a php to do the postgres to mysql conversion.

 

https://cloudera.ericlin.me/2016/10/hive-metastore-migration-from-embedded-postgres-to-mysql/

 

 

You may need to find a more modern tool for that conversion, but the process to dump, convert, and move metastores should be very similar.

 

Translate