One of the challenges many face when running a secure encrypted MySQL backup on Linux is using managed or scheduled mysqldumps without exposing them.

1. The data – within the mysqldump backup file
2. The credentials – that are used connect into mysql

So, how might this be accomplished? I’ll show you one option. It starts with the installation of Gazzang’s ezNcrypt. Its not open source, but it is inexpensive and provides you a simple and secure means to protect and encrypt data transparently with the flexibly to map to your environment and applications.

This technique also applies to other backup tools such as xtrabackup.

This can also go along with transparently encrypting your mysql data.  I discussed this on oursql  podcast …