Difference between revisions of "Backup html folder, backup SQL Database and download locally"
Jump to navigation
Jump to search
(3 intermediate revisions by the same user not shown) | |||
Line 32: | Line 32: | ||
echo "" | echo "" | ||
echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | echo "+++++++++++++ Finish running SQL Backup script +++++++++++++++++" | ||
</pre> | |||
<hr> | |||
<p class="bluebackground">html_backup.sh </p> | |||
<pre> | |||
#!/bin/bash | |||
bkdate=`date +%F` | |||
cd /var/www/html/ | |||
sleep 1 | |||
filename=vortex-$bkdate.zip | |||
filenameadiva=adiva-$bkdate.zip | |||
filenameyoko=yoko-$bkdate.zip | |||
# zip htm folder | |||
zip -r $filename /var/www/html/website0 | |||
sleep 5 | |||
zip -r $filenameadiva /var/www/html/website1 | |||
sleep 5 | |||
zip -r $filenameyoko /var/www/html/website2 | |||
sleep 5 | |||
count=`ls -l *.zip | wc -l 2> /dev/null` | |||
if [ $count -ge 1 ]; then | |||
mv *.zip /var/www/backups/html | |||
fi | |||
</pre> | </pre> | ||
<p class="bluebackground">sql_backup.sh </p> | |||
<pre> | |||
#!/bin/bash | |||
mdate=`date +%F` | |||
cd /var/www/html/ | |||
mysqldump dbname1> dbname1-$mdate.sql | |||
sleep 5 | |||
mysqldump dbname> dbname-$mdate.sql | |||
sleep 2 | |||
ls *.sql > /var/www/html/sqlfiles.txt | |||
sleep 1 | |||
cd /var/www/html | |||
count=`ls -l *.sql | wc -l 2> /var/www/errorsql.txt` | |||
if [ $count -ge 1 ]; then | |||
mv *.sql /var/www/backups/sql | |||
fi | |||
</pre> | |||
<hr> | |||
<h4 class="yellowbackground">clientscripts/./client_dlzipsql_cpto_synology.sh</h4> | <h4 class="yellowbackground">clientscripts/./client_dlzipsql_cpto_synology.sh</h4> | ||
'''Download zip and sql files and copy to synology''' | '''Download zip and sql files and copy to synology''' | ||
Line 44: | Line 85: | ||
sleep 10 | sleep 10 | ||
echo "+++++++++++++++ Copying .zip and sql files to stan ++++++++++++++++++++++++++++++" | echo "+++++++++++++++ Copying .zip and sql files to stan ++++++++++++++++++++++++++++++" | ||
scp -i ~/.ssh/synology *.zip admin@192.168. | scp -i ~/.ssh/synology *.zip admin@192.168.2.120:/volume1/Linode/client | ||
scp -i ~/.ssh/synology *.sql admin@192.168. | scp -i ~/.ssh/synology *.sql admin@192.168.2.120:/volume1/Linode/client | ||
echo " +++++++++++++++++++++++++ Done copying to stan ++++++++++++++ " | echo " +++++++++++++++++++++++++ Done copying to stan ++++++++++++++ " | ||
sleep 5 | sleep 5 | ||
Line 58: | Line 99: | ||
ssh -i ~/.ssh/linode root@10.0.0.4 /var/www/scripts/delete_backups.sh | ssh -i ~/.ssh/linode root@10.0.0.4 /var/www/scripts/delete_backups.sh | ||
<p class="bluebackground">delete_backups.sh<p> | |||
<pre> | <pre> | ||
#!/bin/bash | #!/bin/bash | ||
echo " ++++++++++ Deleting backup files ++++++++" | echo " ++++++++++ Deleting backup files ++++++++" | ||
ls -la /var/www/backups/html | ls -la /var/www/backups/html | ||
ls -la /var/www/backups/sql | ls -la /var/www/backups/sql | ||
sleep 5 | sleep 5 | ||
rm /var/www/backups/html/*.zip | rm /var/www/backups/html/*.zip | ||
sleep 5 | sleep 5 | ||
rm /var/www/backups/sql/*.sql | rm /var/www/backups/sql/*.sql | ||
echo " +++++++++++++++++ done +++++++++++++++++" | echo " +++++++++++++++++ done +++++++++++++++++" | ||
ls -la /var/www/backups/html | ls -la /var/www/backups/html | ||
Line 75: | Line 115: | ||
</pre> | </pre> | ||
==[[Main_Page| Home]] - [[Scripts_used_on_Servers|Category]]== | |||
[[Category:Bash]] | |||
Latest revision as of 14:10, 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 +++++++++++++++++"
html_backup.sh
#!/bin/bash bkdate=`date +%F` cd /var/www/html/ sleep 1 filename=vortex-$bkdate.zip filenameadiva=adiva-$bkdate.zip filenameyoko=yoko-$bkdate.zip # zip htm folder zip -r $filename /var/www/html/website0 sleep 5 zip -r $filenameadiva /var/www/html/website1 sleep 5 zip -r $filenameyoko /var/www/html/website2 sleep 5 count=`ls -l *.zip | wc -l 2> /dev/null` if [ $count -ge 1 ]; then mv *.zip /var/www/backups/html fi
sql_backup.sh
#!/bin/bash mdate=`date +%F` cd /var/www/html/ mysqldump dbname1> dbname1-$mdate.sql sleep 5 mysqldump dbname> dbname-$mdate.sql sleep 2 ls *.sql > /var/www/html/sqlfiles.txt sleep 1 cd /var/www/html count=`ls -l *.sql | wc -l 2> /var/www/errorsql.txt` if [ $count -ge 1 ]; then mv *.sql /var/www/backups/sql fi
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.2.120:/volume1/Linode/client scp -i ~/.ssh/synology *.sql admin@192.168.2.120:/volume1/Linode/client echo " +++++++++++++++++++++++++ Done copying to stan ++++++++++++++ " sleep 5 echo "++++++++++++++++ deleting zip and sql files from local ++++++++++++++++++++++" rm *.zip rm *.sql
client_delete_zipsql.sh
Delete zip and sql files on server
ssh -i ~/.ssh/linode root@10.0.0.4 /var/www/scripts/delete_backups.sh
delete_backups.sh
#!/bin/bash echo " ++++++++++ Deleting backup files ++++++++" ls -la /var/www/backups/html ls -la /var/www/backups/sql sleep 5 rm /var/www/backups/html/*.zip sleep 5 rm /var/www/backups/sql/*.sql echo " +++++++++++++++++ done +++++++++++++++++" ls -la /var/www/backups/html ls -la /var/www/backups/sql