@Aman Sehgal , In Azure, for such migrations, I used Azure Data Factory. It was just table copy and data copy (so no indexes). In AWS equivalent is AWS glue but I don't have experience in practice with that. In Azure Data Factory, there is a connector to S3 and Mysql so that you could try it with a multi-cloud approach.
Eventually, you can write your script on Databricks. If it is not a one-time copy but regular, I probably would sit and write all logic - list tables, create tables, register tables in hive metastore, copy data between them, etc.