1

AWS doesn't let you shrink DB storage. If this is required, they suggest to either user their Migration Service or use mysqldump. See the following Docs

The Migration Service doesn't create an exact replica (e.g. issues with auto increment fields as raised on this question. so mysqldump seems better solution.

I am aware that the mysqldump needs to exclude the default and I am also happy with copying the permissions across (e.g. see this link), but this requires the users to exist in the first place.

How do I move all the users across (without knowing or resetting their passwords)?

Glorfindel
  • 1,213
  • 4
  • 15
  • 22
Rob
  • 227
  • 2
  • 6
  • 1
    Look at the triggers RDS creates on the grant tables (e.g. mysql.user). Some actions are blocked but I don't think you're prevented from inserting rows. – Michael - sqlbot Dec 06 '19 at 18:41

0 Answers0