I am researching for the most efficient way to get SQL backup from RDS database.
When using SQL GUI, it takes several hours to complete, which is not ideal in our operation.
Used MySQLdump in the command line before, which is very quick.
https://repost.aws/knowledge-center/rds-mysql-db-backup
However, our database is constantly growing.
Doing a MySQLdump saves the file in temporary storage before saving it to its final location.
If the temporary storage is not large enough to handle this, and it ends up bringing down the whole server or severely impacting it.
Beside from increasing the temporary storage, what would be the other way to approach this?
Thanks.