# Export AWS RDS mysql Database to S3 Bucket using xtrabackup or any other method

**URL:** <https://forums.percona.com/t/export-aws-rds-mysql-database-to-s3-bucket-using-xtrabackup-or-any-other-method/11730>\
**Category:** Percona XtraBackup\
**Tags:** mysql, percona\
**Created:** [August 11, 2021, 6:45am UTC](https://forums.percona.com/t/export-aws-rds-mysql-database-to-s3-bucket-using-xtrabackup-or-any-other-method/11730 "2021-08-11T06:45:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hirennamera](https://avatars.discourse-cdn.com/v4/letter/h/4bbf92/32.png) [@hirennamera](https://forums.percona.com/u/hirennamera)\
**Post date:** [August 11, 2021, 6:45am UTC](https://forums.percona.com/t/export-aws-rds-mysql-database-to-s3-bucket-using-xtrabackup-or-any-other-method/11730/1 "2021-08-11T06:45:21Z")

</div>

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

```bash
sudo ./xtrabackup --backup --user=user --host=project.eu-central-1.rds.amazonaws.com --password=password --databases=database--port=3306

```

Error was like

```auto
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/

```

---

<div class="post-metadata">

**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\
**Post date:** [August 11, 2021, 12:54pm UTC](https://forums.percona.com/t/export-aws-rds-mysql-database-to-s3-bucket-using-xtrabackup-or-any-other-method/11730/2 "2021-08-11T12:54:18Z")

</div>

Hi @hirennamera .

Xtrabackup require physical access to the files it’s backing up, meaning you cannot use it to backup RDS instances.

I suggest you take a look at :  
mysqldump - [MySQL :: MySQL 5.7 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program](https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html)  
mydumper - [GitHub - mydumper/mydumper: Official MyDumper project](https://github.com/maxbube/mydumper)

those two tools will take logical backups and can be used to backup remote hosts.