migrate database schema and data from RDS Mysql 5.7 to Mysql 8.0


When I migrate data from RDS Mysql 5.7 to RDS Mysql 8.0, the auto_increment and restet the auto_increment are missing in the new RDS Mysql 8.0. Do you have a solution for this case?

  • Can you claify you are Migrating data vs upgrading your RDS instance from 5.7 to 8? How have you been migrating the data so far if thats the case?

  • I do both. I migrate data from RDS 5.7 to another RDS 8.0.. I migrated the data using DMS and the auto_incremenet isn't migrated.

2 Answers


Thank you for asking your question.

DMS has limitation on auto_increment as described in the document.

The AUTO_INCREMENT attribute on a column isn't migrated to a target database column.

To upgrade to RDS MySQL8.0 from RDS MySQL5.7, we have several option, in-place[1], snapshot/restore, and Amazon RDS Blue/Green Deployments[2].

For more information, please see AWS database blog Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database

[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html#USER_UpgradeDBInstance.MySQL.Major / https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html

[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html

I hope this might help.

answered a year ago

Hi, I'd suggest to use AWS DMS with MySQL as source: see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html

DMS will provide you with lots of flexibility in this migration via transformation rules, etc.
Also, if you use its CDC feature, you can create the new version in parallel of the current one and get it updated in quasi real-time to see how it behaves.

See https://aws.amazon.com/dms/features/ for all available features



profile pictureAWS
answered a year ago
  • I already tried DMS as my first solution but after using it, I find that the auto_increment and restet the auto_increment are missing from the tables.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions