Difference between revisions of "Backup html folder, backup SQL Database and download locally"
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
<pre> | <pre> | ||
echo "-----------------------------------" | echo "-----------------------------------" | ||
echo "++++++++++ Running backup script, zipping dir and dump sql database ++++++++++" | echo "++++++++++ Running backup script, zipping dir and dump sql database ++++++++++" | ||
echo "" | echo "" | ||
Line 9: | Line 8: | ||
sleep 5 | sleep 5 | ||
echo "-----------------------------------" | echo "-----------------------------------" | ||
echo "++++++++++ Download zip and sql files and copy to synology ++++++++++" | echo "++++++++++ Download zip and sql files and copy to synology ++++++++++" | ||
echo "" | echo "" | ||
clientscripts/./client_dlzipsql_cpto_synology.sh | clientscripts/./client_dlzipsql_cpto_synology.sh | ||
Line 17: | Line 14: | ||
sleep 5 | sleep 5 | ||
echo "-----------------------------------" | echo "-----------------------------------" | ||
echo "++++++++++ Delete zip and sql files on server ++++++++++" | echo "++++++++++ Delete zip and sql files on server ++++++++++" | ||
clientscripts/./client_delete_zipsql.sh | clientscripts/./client_delete_zipsql.sh | ||
echo "-----------------------------------" | echo "-----------------------------------" | ||
echo "++++++++++ All scripts ran ++++++++++" | echo "++++++++++ All scripts ran ++++++++++" | ||
</pre> | </pre> | ||
Line 39: | Line 30: | ||
ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/html_backup.sh | ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/html_backup.sh | ||
echo "" | echo "" | ||
echo "++++++++++++++++++ Finished running html backup script ++++++++++++++++" | echo "++++++++++++++++++ Finished running html backup script ++++++++++++++++" | ||
echo "" | echo "" | ||
sleep 10 | sleep 10 | ||
echo "" | echo "" | ||
echo "+++++++++++Running SQL Backup script ++++++" | echo "+++++++++++Running SQL Backup script ++++++" | ||
Line 52: | Line 40: | ||
echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | ||
</pre> | </pre> | ||
<h4 class="yellowbackground">clientscripts/./client_dlzipsql_cpto_synology.sh</h4> | <h4 class="yellowbackground">clientscripts/./client_dlzipsql_cpto_synology.sh</h4> |
Revision as of 13:41, 15 June 2023
Master Script
echo "-----------------------------------" echo "++++++++++ Running backup script, zipping dir and dump sql database ++++++++++" echo "" clientscripts/./client_run_backup_sql_zip.sh sleep 5 echo "-----------------------------------" echo "++++++++++ Download zip and sql files and copy to synology ++++++++++" echo "" clientscripts/./client_dlzipsql_cpto_synology.sh sleep 5 echo "-----------------------------------" echo "++++++++++ Delete zip and sql files on server ++++++++++" clientscripts/./client_delete_zipsql.sh echo "-----------------------------------" echo "++++++++++ All scripts ran ++++++++++"
client_run_backup_sql_zip.sh
Running backup script, zipping dir and dump sql database
#!/bin/bash ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/html_backup.sh echo "" echo "++++++++++++++++++ Finished running html backup script ++++++++++++++++" echo "" sleep 10 echo "" echo "+++++++++++Running SQL Backup script ++++++" ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/sql_backup.sh echo "" echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++"
clientscripts/./client_dlzipsql_cpto_synology.sh
Download zip and sql files and copy to synology
#!/bin/bash scp -i ~/.ssh/linode 10.1.1.1:/var/www/backups/html/*.zip . sleep 10 scp -i ~/.ssh/linode 10.1.1.1:/var/www/backups/sql/*.sql . echo "+++++++++ done copying form Remote ++++++++++++++++++" sleep 10 echo "+++++++++++++++ Copying .zip and sql files to stan ++++++++++++++++++++++++++++++" scp -i ~/.ssh/synology *.zip admin@192.168.20.120:/volume1/Linode/client scp -i ~/.ssh/synology *.sql admin@192.168.20.120:/volume1/Linode/client echo " +++++++++++++++++++++++++ Done copying to stan ++++++++++++++ " sleep 5 echo "++++++++++++++++ deleting zip and sql files from local ++++++++++++++++++++++" rm *.zip rm *.sql