It’s been a while i haven’t post anything \ud83d\ude42 , i got this request on how to backup all of mysql databaseand since the hdd is not quite big it also required to delete the old backup. So here is the backup script<\/p>\n
###################################################################################################<\/p>\n
#!\/bin\/sh<\/p>\n
DATE=`date +%d%b-%H%M%S`<\/p>\n
unset PATH
\n# USER VARIABLES
\nMYSQLUSER=user
\nMYSQLPWD=password
\nMYSQLHOST=localhost
\nMYSQLBACKUPDIR=\/home\/backup\/mysql\/mysql_backup$DATE<\/p>\n
FILE=$MYSQLBACKUPDIR.tgz; # No need to modify this one<\/p>\n
# PATH VARIABLES – It depend on your server program
\nMK=\/bin\/mkdir;
\nRM=\/bin\/rm;
\nGREP=\/bin\/grep;
\nMYSQL=\/usr\/local\/mysql\/bin\/mysql;
\nMYSQLDUMP=\/usr\/local\/mysql\/bin\/mysqldump;
\nXARGS=\/usr\/bin\/xargs;
\nFIND=\/usr\/bin\/find;
\nTAR=\/bin\/tar;
\nUUENCODE=\/usr\/bin\/uuencode;<\/p>\n
# CREATE MYSQL BACKUP<\/p>\n
# Delete the old ones. The +7 means 7 days ago
\n$FIND \/home\/backup\/mysql\/ -mtime +7 |$XARGS $RM -rf<\/p>\n
# Create new backup dir
\n$MK -p $MYSQLBACKUPDIR<\/p>\n
#Dump new files
\nfor i in $(echo ‘SHOW DATABASES;’ | $MYSQL -u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST|$GREP -v ‘^Database$’); do
\n$MYSQLDUMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \\
\n-u$MYSQLUSER -p$MYSQLPWD -h$MYSQLHOST\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \\
\n-Q -c -C –add-drop-table –add-locks –quick –skip-lock-tables\u00a0\u00a0 \\
\n$i > $MYSQLBACKUPDIR\/$i.sql;
\ndone;<\/p>\n
# collect and compress the sqls
\n$TAR -cvzpf $MYSQLBACKUPDIR.tgz $MYSQLBACKUPDIR
\n$RM -r $MYSQLBACKUPDIR<\/p>\n
###################################################################################################<\/p>\n
Then save it , i save it as mysql_backup file. Then open the crontab to run it weekly<\/p>\n
# crontab -e<\/p>\n
then put this<\/p>\n
0 0 * * 0 \/root\/mysql_backup > \/dev\/null 2>&1<\/p>\n","protected":false},"excerpt":{"rendered":"
It’s been a while i haven’t post anything \ud83d\ude42 , i got this request on how to backup all of mysql databaseand since the hdd is not quite big it also required to delete the old backup. So here is the backup script ################################################################################################### #!\/bin\/sh DATE=`date +%d%b-%H%M%S` unset PATH # USER VARIABLES MYSQLUSER=user MYSQLPWD=password MYSQLHOST=localhost […]<\/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":[6631],"class_list":["post-796","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql-backup-script"],"_links":{"self":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/796","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=796"}],"version-history":[{"count":3,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/796\/revisions"}],"predecessor-version":[{"id":798,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/796\/revisions\/798"}],"wp:attachment":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=796"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=796"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=796"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}