search

awslabs / aws-support-tools

Tools and sample code provided by AWS Premium Support.
https://aws.amazon.com/premiumsupport/
Apache License 2.0
1.46k stars 801 forks source link

Data Pipeline's "MySQL to PostgreSQL" script doesn't work with MySQL 8.0.11 or later #192

Open mythosil opened 2 years ago

mythosil commented 2 years ago

I'd like to use Data Pipeline's template "Full Copy of Amazon RDS MySQL Table to Amazon Redshift". The template uses dbconv-mysqlRDS-to-postgresqlRDS.sh in this repo.

The problem is that the shell script doesn't work with MySQL 8.0.11+ because of --compatible=postgresql option which can't be used any more. https://github.com/awslabs/aws-support-tools/blob/1fa6b704ac6b6066122cf711215519d9f5cf2589/DataPipeline/MySqlRdsToPostgreSqlRds/dbconv-mysqlRDS-to-postgresqlRDS.sh#L119

Do you have a plan to support MySQL 8.0.11 or later, or is there any workaround for this problem?