Backup, Compress and Encrypt MySQL Database On Linux System

backup.txt

Below are the steps on how you can backup your MySQL database, compress it, then finally encrypt it.

Backup = uses native mysqldump command by Oracle Corporation
Compress = uses zip by Phil Katz
Encrypt = uses ccrypt by Peter Selinger

STEP 1.
Install ccrpyt
sudo apt-get install ccrypt

STEP 2.
Install zip
sudo apt-get install zip

STEP 3.
Create ccrypt backup key
echo 'MyPassword123' > .backup.key

STEP 4.
Create shell script for mysql backup
#!/bin/bash
filename_sql=ProjectName_$(date +%m%d%Y_%H%M).sql
filename_zip=ProjectName_$(date +%m%d%Y_%H%M).zip
filename_cpt=ProjectName_$(date +%m%d%Y_%H%M).cpt
mysqldump -u MySQLUsername -pMySQLPassword mydatabasename > directory/$filename_sql
sleep 5
cd /directory
sleep 5
zip $filename_zip $filename_sql
sleep 5
rm $filename_sql
sleep 5
ccrypt $filename_zip -k .backup.key

STEP 5.
Create crontab entry
crontab -e

0 * * * * /directory/mysqldump.sh

=============================

To Decrypt:
ccrypt filename -d

=============================

DISCLAIMER (Important!)

THE GUIDE ABOVE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHOR OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THIS GUIDE OR THE USE OR OTHER DEALINGS IN THE
ABOVE GUIDE.