How can I use mysqldump in AWS RDS database and attach the result to JIRA ticket

Question

Hello,

I wonder if someone could help me with the steps to take a backup of an RDS DB using mysqldump and attach the result to a JIRA ticket please

Many thanks in advance

YUTAKA_H · Answer

Thank you so much for asking your question.

To dump data from RDS MySQL database instance, you can use EC2 instance, and mysqldump, then compressed it and attache the results to a JIRA.
You can find the command detail on  [RDS document](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html#MySQL.Procedural.Exporting.NonRDSRepl.CopyData)(please see the step 2), and [MySQL document](https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html) (please select the version you are using from dropdown list).

RDS MySQL has some limitation on using mysqldump, please read [knowledge center](https://aws.amazon.com/premiumsupport/knowledge-center/mysqldump-error-rds-mysql-mariadb/) in advance.

How can I use mysqldump in AWS RDS database and attach the result to JIRA ticket

Relevant content