appastair · April 12, 2019 22:29
diff --git a/crontab b/crontab
 @midnight "sh /home/user/mysqldiff-backup.sh"
diff --git a/mysqldiff-backup.sh b/mysqldiff-backup.sh
 #!/bin/sh
 mysqldump -u $(whoami) --password='password' --skip-opt --all-databases > dbdump-$(date +%Y-%m-%d).sql
 diff --suppress-common-lines $(ls|awk '{print $1}'|grep \dbdump|tail -2) > dbdump-$(date +%Y-%m-%d).sql.diff
diff --git a/mysqldiff-restore.sh b/mysqldiff-restore.sh
 #!/bin/sh
 patch $(find . -name dbdump-*.sql|awk '{print $1}'|head -1) < $(find . -name dbdump-*.sql.diff|awk '{print $1}'|grep \dbdump|tail -1)
	#!/bin/sh
	mysqldump -u $(whoami) --password='password' --skip-opt --all-databases > dbdump-$(date +%Y-%m-%d).sql
	diff --suppress-common-lines $(ls\|awk '{print $1}'\|grep \dbdump\|tail -2) > dbdump-$(date +%Y-%m-%d).sql.diff
	#!/bin/sh
	patch $(find . -name dbdump-.sql\|awk '{print $1}'\|head -1) < $(find . -name dbdump-.sql.diff\|awk '{print $1}'\|grep \dbdump\|tail -1)