Here is my script to backup a certain MySql db and certain directory files<\/p>\n
FYI: this script only can working on Unix\/Linux environtment<\/p>\n
Example, We will backup one mysql db & directory files under \/var\/www and transfer it to remote ftp to another server and save it on incremental folder by date<\/p>\n
db : test<\/p>\n
user : root<\/p>\n
pass : passwordrootmysql<\/p>\n
Remote Ftp Server (Vsftpd):<\/p>\n
ip : 10.10.1.3<\/p>\n
user : usertest<\/p>\n
pass : usertestpassword<\/p>\n
#!\/bin\/bash<\/p>\n
# Shell script to backup MySql database<\/p>\n
# By Adityo<\/p>\n
MyUSER=”root” \u00a0 \u00a0 # USERNAME<\/p>\n
MyPASS=”passwordrootmysql” \u00a0 \u00a0 \u00a0 # PASSWORD<\/p>\n
MyHOST=”localhost” \u00a0 \u00a0 \u00a0 \u00a0 \u00a0# Hostname<\/p>\n
# Linux bin paths, change this if it can’t be autodetected via which command<\/p>\n
MYSQL=”$(which mysql)”<\/p>\n
MYSQLDUMP=”$(which mysqldump)”<\/p>\n
CHOWN=”$(which chown)”<\/p>\n
CHMOD=”$(which chmod)”<\/p>\n
GZIP=”$(which gzip)”<\/p>\n
# Get data in dd-mm-yyyy format<\/p>\n
NOW=”$(date +”%d-%m-%Y”)”<\/p>\n
# Backup Dest directory, change this if you have someother location<\/p>\n
DEST=”\/backup\/mysqlscript”<\/p>\n
# Main directory inside the backup Dest directory (DEST) where backup will be stored<\/p>\n
MBD=”$DEST\/mysql\/$NOW”<\/p>\n
# Get hostname<\/p>\n
HOST=”$(hostname)”<\/p>\n
# File to store current backup file<\/p>\n
FILE=””<\/p>\n
# Store list of databases<\/p>\n
DBS=””<\/p>\n
# DO NOT BACKUP these databases , you can choose another db that you did not want to backup and split it with space in this example i exclude the mysql , information_schema and backup database an di only backup the test db<\/p>\n
IGGY=”mysql information_schema backup”<\/p>\n
[ ! -d $MBD ] && mkdir -p $MBD || :<\/p>\n
# Only root can access it!<\/p>\n
$CHOWN 0.0 -R $DEST<\/p>\n
$CHMOD 0600 $DEST<\/p>\n
# Get all database list first<\/p>\n
DBS=”$($MYSQL -u $MyUSER -h $MyHOST -p$MyPASS -Bse ‘show databases’)”<\/p>\n
for db in $DBS<\/p>\n
do<\/p>\n
skipdb=-1<\/p>\n
if [ “$IGGY” != “” ];<\/p>\n
then<\/p>\n
for i in $IGGY<\/p>\n
do<\/p>\n
[ “$db” == “$i” ] && skipdb=1 || :<\/p>\n
done<\/p>\n
fi<\/p>\n
if [ “$skipdb” == “-1″ ] ; then<\/p>\n
FILE=”$MBD\/$db.$HOST.$NOW.sql.gz”<\/p>\n
# do all inone job in pipe,<\/p>\n
# connect to mysql using mysqldump for select mysql database<\/p>\n
# and pipe it out to gz file in backup dir \ud83d\ude42<\/p>\n
$MYSQLDUMP -u $MyUSER -h $MyHOST -p$MyPASS $db –lock-tables=false \u00a0| $GZIP -9 > $FILE<\/p>\n
fi<\/p>\n
done<\/p>\n
### Start backup files on didirectory \/var\/www<\/p>\n
mkdir -p \/backup\/mysqlscript\/data\/$NOW<\/p>\n
cd \/backup\/mysqlscript\/data\/$NOW<\/p>\n
FILE=”blogbinusian-file-www-$NOW.tar.gz”<\/p>\n
tar -cvf $FILE \/var\/www<\/p>\n
### FTP server Setup ###<\/p>\n
FTPD=”\/\/incremental”<\/p>\n
FTPU=”usertest”<\/p>\n
FTPP=”usertestpassword”<\/p>\n
FTPS=”10.10.1.3″<\/p>\n
NCFTP=”$(which ncftpput)”<\/p>\n
### Dump backup using FTP ###<\/p>\n
#Start FTP backup using ncftp and transfer file to remote server<\/p>\n
ncftp -u”$FTPU” -p”$FTPP” $FTPS<<EOF # connect to target ftp service<\/p>\n
mkdir $FTPD\/$NOW\/ \u00a0 \u00a0 \u00a0# it will create directory \/home\/usertest\/incremental\/$NOW<\/p>\n
cd \u00a0 \u00a0$FTPD\/$NOW\/ \u00a0 \u00a0 \u00a0 \u00a0#\u00a0\u00a0it will changes directory \/home\/usertest\/incremental\/$NOW<\/p>\n
lcd \/backup\/mysqlscript\/mysql\/$NOW \u00a0# it will goes to source server directory\u00a0\/backup\/mysqlscript\/mysql\/$NOW<\/p>\n
mput * \u00a0# upload all files on\u00a0\/backup\/mysqlscript\/mysql\/$NOW<\/p>\n
lcd \/backup\/mysqlscript\/data\/$NOW\u00a0# it will goes to source server directory\u00a0\/backup\/mysqlscript\/data\/$NOW<\/p>\n
mput *\u00a0\u00a0# upload all files on\u00a0\/backup\/mysqlscript\/mysql\/$NOW<\/p>\n
quit # stop<\/p>\n
EOF<\/p>\n","protected":false},"excerpt":{"rendered":"
Here is my script to backup a certain MySql db and certain directory files FYI: this script only can working on Unix\/Linux environtment Example, We will backup one mysql db & directory files under \/var\/www and transfer it to remote ftp to another server and save it on incremental folder by date db : test […]<\/p>\n","protected":false},"author":386,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[491],"tags":[],"class_list":["post-367","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/users\/386"}],"replies":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=367"}],"version-history":[{"count":9,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/367\/revisions"}],"predecessor-version":[{"id":519,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/367\/revisions\/519"}],"wp:attachment":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}