Posted on 21st Nov 2016
For some companies running a website the site is the company - once it has gone the company cannot function.
I recently worked for a company in Laindon, Essex who were using a PHP + MySQL based system as their primary database for adding jobs , to my surprise it was not being backed up at all. I created a DROPBOX free account as the amount of data they were backing up was not too large - so the steps I went through were as follows:
1. create a FREE DROPBOX account and obtain the API and Secret key - these are different from the normal dropbox login as they allow a remote program to have access to the dropbox account.
2. I created a script - I no longer pocess the original script ... but it was something like this:
I used the dropbox uploader: https://github.com/andreafabrizi/Dropbox-Uploader
tar cvzf files.tar.gz var/www/html/
mysqldump -u root -ppassword crm > crm.sql
tar cvzf database.tar.gz var/www/html/
dropbox_uploader.sh /var/www/html/ *.zip /
The script runs in a cron job every hour.
REMEMBER TO BACKUP when possible!!!