Skip to content
This repository has been archived by the owner on Oct 4, 2024. It is now read-only.

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

Open
mythosil opened this issue Feb 22, 2022 · 0 comments

Comments

@mythosil
Copy link

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.

`mysqldump -h $RDSHost --port=$RDSPort -u $RDSUsr --password=$RDSPwd --compatible=postgresql --default-character-set=utf8 -n -d -r $MySQLFile $MySQLDb $RDSTbl`

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

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant