{"id":771,"date":"2009-08-01T20:09:17","date_gmt":"2009-08-01T19:09:17","guid":{"rendered":"http:\/\/helgekoenig.de\/?p=771"},"modified":"2010-03-20T19:37:48","modified_gmt":"2010-03-20T18:37:48","slug":"backup-von-dateien-mysql-dbs-via-ftp","status":"publish","type":"post","link":"https:\/\/helgekoenig.de\/?p=771","title":{"rendered":"Backup von Dateien & MySQL DBs via FTP"},"content":{"rendered":"

Nachdem ich den unglaublich weiten Interwebs kein Shell-Script gefunden habe, das mir zusagt (oder das ich mit meinen Wissensstand verstehe) habe ich jetzt selber eines geschrieben. Das war f\u00fcr mich schon eine ziemliche Herausforderung, da ich so gut wie \u00fcber keine Kenntnisse verf\u00fcge.<\/p>\n

Da es aber recht gut gelungen ist, dachte ich stelle es mal hier in den Blog, auf das es anderen Hilft.
\n(Zum Lesen des Scripts den Button dr\u00fccken)<\/p>\n

<\/p>\n

#! \/bin\/bash
\n# Script to backup files by compressing them local and transfer to ftp
\n# Don’t copy this script in the $BACKUPPATH, it will be deleted at the end of this script. Same goes for the folder itself
\n# to run this script by a crontab on mondays at 6am type „crontab -e“ and add the line „* 6 * * 1 \/root\/Scripts\/ftp_backup.sh“
\n# If you change the file path and \/ or name of this script, change your crontab entry
\n# Give execute rights by „chmod u+x ftp_backup.sh“
\n#
\n# Created by Helge K\u00f6nig (HelgeKoenig@GMX.de)
\n# Mail me for comments or suggestions<\/p>\n

# Parameters not to change
\nDATE_VAR=$(date +“%Y%m%d“)<\/p>\n

# Parameters to change
\nBACKUPPATH=“\/backup“\t# path to the local backup folder
\nSCRIPTPATH=“\/root\/Scripts“\t# path to this script, needed for self backup
\nSQL_USER=“root“\t# SQL root user for DB Backup
\nSQL_PW=“pw“\t# see SQL_USER
\nFTP_IP=“192.168.0.10″\t# IP or Adress for the backup ftp server
\nFTP_USER=“user“\t# Should be self-explaining
\nFTP_PW=“pw“\t# see FTP_USER<\/p>\n

# check for $BACKUP folder and if fails creating
\nif [ ! -d $BACKUPPATH ]; then mkdir $BACKUPPATH; fi<\/p>\n

# Let teh backup beginz!
\nif [ `whoami` = root ] # check for root user
\nthen {
\ntar cvz -f $BACKUPPATH\/etc_$DATE_VAR.tgz \/etc\/\t# backup of the \/etc\/ (sub)-folder(s)
\ntar cvz -f $BACKUPPATH\/root-scripts_$DATE_VAR.tgz $SCRIPTPATH\t# backup of root scripts<\/p>\n

# change DB_NAME to actual DB name
\n# don’t forget to change the DB Name in the FTP Backup Section too
\nmysqldump –user=$SQL_USER –password=$SQL_PW „DB_Name“ > „$BACKUPPATH\/DB_NAME_$DATE_VAR.sql“
\ngzip „$BACKUPPATH\/DB_NAME_$DATE_VAR.sql“<\/p>\n

# begin FTP backup
\nftp -pinv $FTP_IP <<\/p>\n

user $FTP_USER $FTP_PW
\nbin
\nput $BACKUPPATH\/etc_$DATE_VAR.tgz \/etc_$DATE_VAR.tgz
\nput $SCRIPTPATH\/root-scripts_$DATE_VAR.tgz \/root-scripts_$DATE_VAR.tgz
\nput $BACKUPPATH\/DB_NAME_$DATE_VAR.gz \/DB_NAME_$DATE_VAR.tgz
\nbye
\nEOFTP<\/p>\n

# clean $BACKUPPATH
\nrm -R $BACKUPPATH
\n}
\nelse echo „This script need root user“; exit;
\nfi<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Nachdem ich den unglaublich weiten Interwebs kein Shell-Script gefunden habe, das mir zusagt (oder das ich mit meinen Wissensstand verstehe) habe ich jetzt selber eines geschrieben. Das war f\u00fcr mich schon eine ziemliche Herausforderung, da ich so gut wie \u00fcber … Weiter<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[211],"tags":[167,170,168,173,169,171,172],"class_list":["post-771","post","type-post","status-publish","format-standard","hentry","category-netzkultur-it-stuff","tag-backup","tag-bash","tag-ftp","tag-linux","tag-mysql","tag-shell","tag-ubuntu"],"_links":{"self":[{"href":"https:\/\/helgekoenig.de\/index.php?rest_route=\/wp\/v2\/posts\/771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helgekoenig.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helgekoenig.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helgekoenig.de\/index.php?rest_route=\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/helgekoenig.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=771"}],"version-history":[{"count":0,"href":"https:\/\/helgekoenig.de\/index.php?rest_route=\/wp\/v2\/posts\/771\/revisions"}],"wp:attachment":[{"href":"https:\/\/helgekoenig.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helgekoenig.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helgekoenig.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}