By bbeams
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!
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.
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.