Backing up Aurora MySQL
AWS Aurora MySQL doesn’t allow us to take backup of individual tables or database other than doing a regular mysqldump which can be difficult to restore.
The option is to take a backup of the entire database instance. Restoring an individual or a set of tables can be a cumbersome process. I wrote a quick python code that takes two parameters : a secret name that contains the credentials to connect to the mysql and then a config file name that contains the database, list of tables and the S3 location for storing the extract. The code stores the data in a pqt file format for efficiency
Use it at your own risk.