Question

Does anyone know if you can encrypt the database backup using AutoMYSQLBackup on Ubuntu 14.04?

Does anyone know if you can encrypt the database backup using AutoMYSQLBackup on Ubuntu 14.04? I’ve tried adding the parameter to encrypt but it doesn’t work.

If not do you have a recommendation for how to do it?

Any help is much appreciated.

Show comments

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

Thanks. I think that is the problem. I just installed this on Ubuntu 14.04 and it looks like it is using version 2.6. However in the tutorial they are installing version 3.0 automysqlbackup-v3.0_rc6.tar.gz.

I also checked Ubuntu 16.04 and 17.10 and they are all using this old version. It is possible that this feature was not added until a later version.

In order to get this to work, I would uninstall the version that you installed with apt apt-get remove automysqlbackup and install this manually with the following steps.

mkdir /opt/automysqlbackup

cd /opt/automysqlbackup

wget http://ufpr.dl.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz

tar zxf automysqlbackup-v3.0_rc6.tar.gz

./install.sh

Once you have ran the install script, you should see the up to date file located in /etc/automysqlbackup/automysqlbackup.conf and be able to change the settings for encryption. They should look something like this:

# Do you wish to encrypt your backups using openssl?
CONFIG_encrypt='yes'
# Choose a password to encrypt the backups.
CONFIG_encrypt_password='$YOUR_PASSWORD'

Be sure to replace $YOUR_PASSWORD with whatever password you want to use.

This comment has been deleted