Skip to content

Instantly share code, notes, and snippets.

@kurozumi
Created January 6, 2016 08:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kurozumi/3cdc97dd511f01fa2cbb to your computer and use it in GitHub Desktop.
Save kurozumi/3cdc97dd511f01fa2cbb to your computer and use it in GitHub Desktop.
【シェルスクリプト】一週間分だけ定期的にデータベースをバックアップする方法
#!/bin/sh
period=7
filename=`date +%y%m%d`
oldfile=`date --date "$period days ago" +%y%m%d`
dir_path="/home/username/db_backup"
mysqldump -u username -ppasswd database_name > $dir_path/$filename.sql
chmod 700 $dir_path/$filename.sql
rm -f $dir_path/$oldfile.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment