<p>RDS already has an 'Export to S3' button. Alternatively you can use AWS Data Migration Service (DMS) to export the data to S3 in real-time.</p>
<p>And as you point out, regular <code>mydumper</code> will also work because RDS is a regular MySQL-compatible database.</p>

CC BY-SA 4.0
2021-08-12T21:43:22.883Z
2021-08-12T21:43:22.883Z
rjh
<p>We need to trace why data missing, we have taken backup many time from rds without any issues. We have more than 80gb data.
2ndly xtrabackup needs access to mysql data directory so can't be used with rds.</p>
<p>Just mysql dump can do the job. Also rds offers S3 export per table in few format like parquet etc</p>

CC BY-SA 4.0
2021-08-11T18:08:06.940Z
2021-08-11T18:08:06.940Z
Siddique Ahmad
<p>Xtrabackup forum come to the rescue and cleared our doubt  that it works only when we have physical access to the Database and suggested to use mydumper</p>
<p><a href="https://github.com/maxbube/mydumper" rel="nofollow noreferrer">mydumper - GitHub - maxbube/mydumper: Official mydumper project 1</a></p>
<p>It is working perfectly.</p>

CC BY-SA 4.0
2021-08-12T04:29:18.983Z
2021-08-12T04:29:18.983Z
Hiren Namera
<p>I have an AWS RDS MySQL Database. The size of the Database is around of 1.5 GB.
We are using MySQL 5.7.32.</p>
<p>We tried with SQL dump but in dump data is missing in Dump.</p>
<p>We found out that we can use xtrabackup. We are using xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64).</p>
<p>We used below command</p>
<pre class="lang-bash prettyprint-override"><code>sudo ./xtrabackup --backup --user=user --host=project.eu-central-1.rds.amazonaws.com --password=password --databases=database--port=3306
</code></pre>
<p>Error was like</p>
<pre><code>xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments: --backup=1 --user=user --host=project.eu-central-1.rds.amazonaws.com --password=* --databases=database --port=3306
210811 05:31:47  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=project.eu-central-1.rds.amazonaws.com;port=3306' as 'user'  (using password: YES).
210811 05:31:47  version_check Connected to MySQL server
210811 05:31:47  version_check Executing a version check against the server...
210811 05:31:48  version_check Done.
210811 05:31:48 Connecting to MySQL server host: project.eu-central-1.rds.amazonaws.com, user: user, password: set, port: 3306, socket: not set
Using server version 5.7.12-log
./xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64) (revision id: 5988af5)
xtrabackup: uses posix_fadvise().
xtrabackup: Can't change dir to '/rdsdbdata/db/' (Errcode: 2 - No such file or directory)
xtrabackup: cannot my_setwd /rdsdbdata/db/
</code></pre>

<amazon-web-services><mysql><amazon-rds><backup><disaster-recovery-plans>
Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method
Hiren Namera
# Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method

(Asked by: username_0 on 2021-08-11)

I have an AWS RDS MySQL Database. The size of the Database is around of 1.5 GB.
We are using MySQL 5.7.32.
We tried with SQL dump but in dump data is missing in Dump.
We found out that we can use xtrabackup. We are using xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64).
We used below command
sudo ./xtrabackup --backup --user=user --host=project.eu-central-1.rds.amazonaws.com --password=password --databases=database--port=3306

Error was like
xtrabackup: recognized server arguments:
xtrabackup: recognized client arguments: --backup=1 --user=user --host=project.eu-central-1.rds.amazonaws.com --password=* --databases=database --port=3306
210811 05:31:47  version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup;host=project.eu-central-1.rds.amazonaws.com;port=3306' as 'user'  (using password: YES).
210811 05:31:47  version_check Connected to MySQL server
210811 05:31:47  version_check Executing a version check against the server...
210811 05:31:48  version_check Done.
210811 05:31:48 Connecting to MySQL server host: project.eu-central-1.rds.amazonaws.com, user: user, password: set, port: 3306, socket: not set
Using server version 5.7.12-log
./xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64) (revision id: 5988af5)
xtrabackup: uses posix_fadvise().
xtrabackup: Can't change dir to '/rdsdbdata/db/' (Errcode: 2 - No such file or directory)
xtrabackup: cannot my_setwd /rdsdbdata/db/

**Tags:** amazon-web-services, mysql, amazon-rds, backup, disaster-recovery-plans


---

## 3 answers

### Answer by username_1 on 2021-08-12. Score: 0 | Accepted answer

RDS already has an 'Export to S3' button. Alternatively you can use AWS Data Migration Service (DMS) to export the data to S3 in real-time.

And as you point out, regular `mydumper` will also work because RDS is a regular MySQL-compatible database.


---

### Answer by username_2 on 2021-08-11. Score: 0

We need to trace why data missing, we have taken backup many time from rds without any issues. We have more than 80gb data.
2ndly xtrabackup needs access to mysql data directory so can't be used with rds.

Just mysql dump can do the job. Also rds offers S3 export per table in few format like parquet etc


---

### Answer by username_0 on 2021-08-12. Score: 0

Xtrabackup forum come to the rescue and cleared our doubt that it works only when we have physical access to the Database and suggested to use mydumper

[mydumper - GitHub - maxbube/mydumper: Official mydumper project 1](https://github.com/maxbube/mydumper)

It is working perfectly.


---

