Skip to content

Latest commit

 

History

History
39 lines (23 loc) · 944 Bytes

README.md

File metadata and controls

39 lines (23 loc) · 944 Bytes
Raw

This is the very first draft for making backups of mysql databases and drop them elsewhere.

Requirements:

  • dropbox account
  • mysql client
  • pigz (you actually don't "need" it, replace with your favourite compressing utility)

Usage

Configure as nedded

Of course, you must configure Dropbox-uploader

Add a proper backup.ini file with your settings.

Create a cron job

Just drop a file in /etc/cron.d folder with this content to run the script at 3 am:

00 3 * * * root /opt/backup/backup.sh

Check your backups

login into your dropbox account and be delighted with the view of your daily backups.

To do

A bunch of stuff:

  • allow external configuration file
  • add a restore option
  • add some options besides dropbox
  • send a mail with the result
  • add parameter of number of backups to keep (i.e. last 7 days only)
  • add md5sum check
  • add minimum size warning (case current backup is smaller than last backup