+- Sinisterly (https://sinister.li)
+-- Forum: Hacking (https://sinister.li/Forum-Hacking)
+--- Forum: Tutorials (https://sinister.li/Forum-Tutorials)
+--- Thread: Tutorial Free auto database backup to dropbox script [fully automated] (/Thread-Tutorial-Free-auto-database-backup-to-dropbox-script-fully-automated)
Free auto database backup to dropbox script [fully automated] - Quarantine - 05-05-2016
[Tutorial] Free auto database backup to dropbox script [fully automated]
Quote:Step 1 Register here for free webdev cloud dropbox account
https://dropbox.com/webdev/register
Step 2 download script backmeup.sh
https://raw.githubusercontent.com/Ardakilic/backmeup/master/backmeup.sh
Exp SQL Query:
DBUSER="root" #MySQL user that can dump all databases
DBPASSWORD="" #MySQL password
The script dumps all of your MySQL databases as separate files.
The script backs up all of your Web files (e.g: root of all of your virtual hosts).
The script compresses your web-root and databases to a single archive.
The script uploads the compressed archive into a folder in Dropbox.
After the upload, the script cleans the temporary files (dumps, the archive itself).
The script makes sure that you always have the newest Dropbox-uploader script.
You may easily add this script to your crontab, and just forget about it
And make sure the scripts are only readable by the owner, not group!! (chmod 700)