Michael.mast at 20:05, 17 May 2016

2016-05-17T20:05:22Z

Michael.mast: Created page with " #!/bin/bash date=$(date +%Y-%m-%d) olddate=$(date --date="1 week ago" +%Y-%m-%d) mysqldump --all-databases -p /root/dbbackup/database..."

2016-05-17T20:01:12Z

Created page with "<syntaxhighlight lang="BASH"> #!/bin/bash date=$(date +%Y-%m-%d) olddate=$(date --date="1 week ago" +%Y-%m-%d) mysqldump --all-databases -p<DBPassword> /root/dbbackup/database..."

New page

<syntaxhighlight lang="BASH">
#!/bin/bash
date=$(date +%Y-%m-%d)
olddate=$(date --date="1 week ago" +%Y-%m-%d)
mysqldump --all-databases -p<DBPassword> /root/dbbackup/database_$date.sql
rm -f /dbbackup/database_$olddate.sql
cp -r /root/webbackup /root/sitebackup/daily_$date
rsync -av --delete /var/www /root/webbackup/
rm -f /root/sitebackup/daily_%olddate

####The following is for managing disk space, will be visited later.
#df -lh /dev/sda2 --output=ipcent > /tmp/percent
#grep '^ ' /tmp/percent > /tmp/percent1
#rm /tmp/percent
#disk=$(sed 's/^\ \ \ //' /tmp/percent1)
#diskused=$(sed 's/%//' < $disk)
#unset disk
#if ( $diskused <= 10 ); then
#rm /root/old/*
</syntaxhighlight>

@@ Line 4: / Line 4: @@
 olddate=$(date --date="1 week ago" +%Y-%m-%d)
 mysqldump --all-databases -p<DBPassword> /root/dbbackup/database_$date.sql
-rm -f /dbbackup/database_$olddate.sql
+rm -f /root/dbbackup/database_$olddate.sql
 cp -r /root/webbackup /root/sitebackup/daily_$date
 rsync -av --delete /var/www /root/webbackup/

Backup Website Data w/ MySQL - Revision history

Michael.mast at 20:05, 17 May 2016

Michael.mast: Created page with " #!/bin/bash date=$(date +%Y-%m-%d) olddate=$(date --date="1 week ago" +%Y-%m-%d) mysqldump --all-databases -p /root/dbbackup/database..."