mysql backup shell script # your mysql login information # the directory for story your backup file. # date format for backup file (dd-mm-yyyy) # mysql, mysqldump and some other bin’s path # check the directory for store backup is writeable # the directory for story the newest backup # get all databases for db in $all_db # delete the oldest backup # rotate backup directory exit 0; <\/P> mysql backup shell script#!\/bin\/sh# mysql_backup.sh: backup mysql databases and keep newest 5 days backup.## Last updated: 2006.9.6# ———————————————————————-# This is a free shell script under GNU GPL version# Feedback\/comment\/suggestions : http:\/\/www.strongd.net# ———————————————————————- # your mysql login information# db_user is mysql username# db_passwd is mysql password# db_host is mysql host# —————————–db_user=”root”db_passwd=”passwd”db_host=”localhost” # the directory for story … Continue reading mysql backup shell script<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[133],"class_list":["post-441","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql-backup"],"_links":{"self":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=441"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/441\/revisions"}],"predecessor-version":[{"id":936,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/441\/revisions\/936"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
#!\/bin\/sh
# mysql_backup.sh: backup mysql databases and keep newest 5 days backup.
#
# Last updated: 2006.9.6
# ———————————————————————-
# This is a free shell script under GNU GPL version
# Feedback\/comment\/suggestions : http:\/\/www.strongd.net<\/A>
# ———————————————————————-<\/P>
\n
# db_user is mysql username
# db_passwd is mysql password
# db_host is mysql host
# —————————–
db_user=”root”
db_passwd=”passwd”
db_host=”localhost”<\/P>
\n
backup_dir=”\/backup”<\/P>
\n
time=”$(date +”%d-%m-%Y”)”<\/P>
\n
MYSQL=”$(which mysql)”
MYSQLDUMP=”$(which mysqldump)”
MKDIR=”$(which mkdir)”
RM=”$(which rm)”
MV=”$(which mv)”
GZIP=”$(which gzip)”<\/P>
\n
test ! -w $backup_dir && echo “Error: $backup_dir is un-writeable.” && exit 0<\/P>
\n
test ! -d “$backup_dir\/backup.0\/” && $MKDIR “$backup_dir\/backup.0\/”<\/P>
\n
all_db=”$($MYSQL -u $db_user -h $db_host -p$db_passwd -Bse ‘show databases’)”<\/P>
\n
do
$MYSQLDUMP -u $db_user -h $db_host -p$db_passwd $db | $GZIP -9 > “$backup_dir\/backup.0\/$time.$db.gz”
done<\/P>
\n
test -d “$backup_dir\/backup.5\/” && $RM -rf “$backup_dir\/backup.5”<\/P>
\n
for int in 4 3 2 1 0
do
if(test -d “$backup_dir”\/backup.”$int”)
then
next_int=`expr $int + 1`
$MV “$backup_dir”\/backup.”$int” “$backup_dir”\/backup.”$next_int”
fi
done<\/P>
\n
\n