Report this

What is the reason for this report?

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

Posted on March 13, 2018

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.



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!

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.

This comment has been deleted

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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.