Difference between revisions of "Backup html folder, backup SQL Database and download locally"
Jump to navigation
Jump to search
Line 38: | Line 38: | ||
#!/bin/bash | #!/bin/bash | ||
ssh -i ~/.ssh/linode root@ | ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/html_backup.sh | ||
echo "" | echo "" | ||
echo "" | echo "" | ||
Line 48: | Line 48: | ||
echo "" | echo "" | ||
echo "+++++++++++Running SQL Backup script ++++++" | echo "+++++++++++Running SQL Backup script ++++++" | ||
ssh -i ~/.ssh/linode root@ | ssh -i ~/.ssh/linode root@10.1.1.1 /var/www/scripts/sql_backup.sh | ||
echo "" | echo "" | ||
echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | ||
</pre> | |||
<h4 class="yellowbackground"> </h4> | |||
''' ''' | |||
<pre> | |||
</pre> | |||
<h4 class="yellowbackground">clientscripts/./client_dlzipsql_cpto_synology.sh</h4> | |||
'''Download zip and sql files and copy to synology''' | |||
<pre> | |||
</pre> | |||
<h4 class="yellowbackground"> </h4> | |||
''' ''' | |||
<pre> | |||
#!/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 | |||
</pre> | |||
<h4 class="yellowbackground"> </h4> | |||
''' ''' | |||
<pre> | |||
</pre> | |||
<h4 class="yellowbackground"> </h4> | |||
''' ''' | |||
<pre> | |||
</pre> | |||
<h4 class="yellowbackground"> </h4> | |||
''' ''' | |||
<pre> | |||
</pre> | </pre> |
Revision as of 13:38, 15 June 2023
Master Script
echo "-----------------------------------" echo "" echo "++++++++++ Running backup script, zipping dir and dump sql database ++++++++++" echo "" clientscripts/./client_run_backup_sql_zip.sh sleep 5 echo "-----------------------------------" echo "" echo "++++++++++ Download zip and sql files and copy to synology ++++++++++" echo "" echo "" clientscripts/./client_dlzipsql_cpto_synology.sh sleep 5 echo "-----------------------------------" echo "" echo "++++++++++ Delete zip and sql files on server ++++++++++" echo "" echo "" clientscripts/./client_delete_zipsql.sh echo "-----------------------------------" echo "" echo "++++++++++ All scripts ran ++++++++++" echo "" echo ""
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 "" 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