Difference between revisions of "Backup html folder, backup SQL Database and download locally"

From rbachwiki
Jump to navigation Jump to search
Line 2: Line 2:
<pre>
<pre>
echo "-----------------------------------"
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 ""
echo "++++++++++ Download zip and sql files and copy to synology ++++++++++"
echo "++++++++++ Download zip and sql files and copy to synology ++++++++++"
echo ""
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 ""
echo "++++++++++ Delete zip and sql files on server ++++++++++"
echo "++++++++++ Delete zip and sql files on server ++++++++++"
echo ""
echo ""


clientscripts/./client_delete_zipsql.sh
clientscripts/./client_delete_zipsql.sh


echo "-----------------------------------"
echo "-----------------------------------"
echo ""
echo "++++++++++ All scripts ran ++++++++++"
echo "++++++++++ All scripts ran ++++++++++"
echo ""
echo ""
</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 ""
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