I've recently increased my General Purpose SSD storage up from 1000Gb to 6000Gb in an accident. Now i'm trying to bring the storage size down to the original 1000Gb but i can't do it over the console.
I also tried taking a snapshot and then allocating a smaller storage size down but once the snapshot is restored it goes back to 6000Gb.
My next option is to backup 900Gb worth of data from my current db and import into a new RDS instance using workbench import sql data (very slow).
Is there something else that i can do to either bring the size down, or a faster way to export and import data from the oversized rds instance to a new smaller instance?