Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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 join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant