# How to encrypt Percona MySQL Server backups using mysqldump for large database with compression?

**URL:** <https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656>\
**Category:** MySQL & MariaDB\
**Tags:** percona\
**Created:** [February 22, 2024, 3:23pm UTC](https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656 "2024-02-22T15:23:24Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramasamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramasamy/32/16466_2.png) [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Post date:** [February 22, 2024, 3:23pm UTC](https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656/1 "2024-02-22T15:23:24Z")

</div>

Can anyone please provide the steps for encrypting Percona MySQL Server backups using mysqldump for large database with compression?

We are looking only for mysqldump utility and not xtrabackup.

An early response is highly appreciated.

Thank you

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 22, 2024, 3:38pm UTC](https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656/2 "2024-02-22T15:38:53Z")

</div>

@Ramasamy,

> <https://stackoverflow.com/questions/16056135/how-to-use-openssl-to-encrypt-decrypt-files>

Since mysqldump outputs the dump to stdout, you can simply redirect the output into openssl and encrypt it. Or you can redirect to zstd to compress, then redirect that output into openssl.

---

<div class="post-metadata">

**Author:** ![Ramasamy](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ramasamy/32/16466_2.png) [@Ramasamy](https://forums.percona.com/u/Ramasamy)\
**Post date:** [February 22, 2024, 8:48pm UTC](https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656/3 "2024-02-22T20:48:14Z")

</div>

Thank you Matthew.

We would like have a command/statement with encryption and compression at the sametime on RHEL 8.

Could you please advice.

Thank you

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [February 23, 2024, 12:17am UTC](https://forums.percona.com/t/how-to-encrypt-percona-mysql-server-backups-using-mysqldump-for-large-database-with-compression/28656/4 "2024-02-23T00:17:05Z")

</div>

Hi @Ramasamy,  
Simplified example: `mysqldump | openssl enc | zstd >backup.zst` You will have to provide the various flags specific to your situation. If you need more hands-on assistance, I suggest contacting our [support department](https://percona.com/support).