1. #!/bin/bash
2. #https://github.com/PJanisio/bash-tools
3. #--------------------------------------
4. #create mysql dump of database and tars it.
5. #than it can be stored on cloud service like dropbox ;)
6.  
7. #Predefined variables - do not touch
8. date=$(date +"%d-%b-%Y")
9.  
10. #Database and user credentials
11. user='user'
12. password='password'
13. host='localhost'
14. db_name='database'
15.  
16. #Backup directory
17. backup_path='/home/user/backup/backup-sql/'
18.  
19. #Dump database into SQL file
20. mysqldump --user=$user --password=$password --host=$host $db_name > $backup_path/$db_name-$date.sql
21.  
22. cd $backup_path
23. tar czvf $db_name-$date.tar.gz $db_name-$date.sql
24. rm -rf $db_name-$date.sql
25.  
26. #Upload to dropbox
27. #uncomment following code to enable pasting it to dropbox
28. #dependecies: https://github.com/andreafabrizi/Dropbox-Uploader
29.  
30. dropbox_uploader_path = '/root/dropbox-up/'
31. echo 'It can take several minutes to upload. Please wait'
32. $dropbox_uploader_path/dropbox_uploader.sh upload $backup_path/$db_name-$date.tar.gz $db_name-$date.tar.gz