Here are two scripts I wrote that I needed to easily backup databases and some websites.<\/p>\n
Having the fact that I use SELinux .. with a custom data dir. I needed to this on my server:<\/p>\n
\r\nyum install rssh\r\nmkdir \/backup\/.ssh\r\ncd \/backup\/.ssh\r\nssh-keygen -t rsa -f .\/backup\r\ncat backup.pub >authorized_keys\r\nsed -i 's\/#allowsftp\/allowsftp\/g' \/etc\/rssh.conf\r\nadduser -m backup -s \/usr\/bin\/rssh\r\nsemanage fcontext -at user_home_dir_t \/backup\/\r\nsemanage fcontext -at ssh_home_t \/backup\/.ssh\/\r\nsemanage fcontext -at ssh_home_t \/backup\/.ssh\/authorized_keys\r\nrestorecon -Rv \/backup\r\n<\/pre>\nYou just need to get \/backup\/.ssh\/backup private key file to the servers (make sure it’s chmod 0600 on the clients too ) you want to backup from so they can use it to connect to this server.<\/p>\n
I’ve put the following script on my mysql server<\/p>\n
\r\nmkdir -p \/root\/scripts\r\ncat >\/root\/scripts\/backup.sh<<_EOF_\r\n#!\/bin\/bash\r\n\r\nUSER=\"root\"\r\nPASSWORD='l33tP4ssw0rd'\r\nHOST=\"localhost\"\r\nOUTPUT=\"\/backup\"\r\nPORT=5522\r\nKEY=\"\/root\/.ssh\/backup\"\r\nDEST=\"backup@192.168.1.1:\"\r\n\r\nmkdir \"${OUTPUT}\"\r\ndatabases=$(mysql --host=${HOST} --user=${USER} --password=${PASSWORD} --skip-column-names -s -N -e \"SHOW DATABASES;\")\r\n\r\nfor db in $databases; do\r\n if [[ \"$db\" == \"information_schema\" ]] ; then\r\n continue\r\n fi\r\n if [[ \"$db\" == \"performance_schema\" ]] ; then \r\n continue\r\n fi\r\n if [[ \"$db\" != _* ]] ; then\r\n file=sql_$db.`date +%Y%m%d_%s`.sql.gz\r\n mysqldump --force --opt --host=${HOST} --user=$USER --password=${PASSWORD} --databases $db | gzip > $OUTPUT\/${file}\r\n scp -oPort=${PORT} -i ${KEY} $OUTPUT\/${file} ${DEST}\r\n rm -rf \"${OUTPUT}\/*\"\r\n fi\r\ndone\r\n_EOF_\r\n\r\nchmod +x \/root\/scripts\/backup.sh\r\necho '0 2 * * * root nice \/root\/scripts\/backup.sh >\/dev\/null 2>&1' >> \/etc\/crontab\r\n<\/pre>\nI’ve put the following script on my web server, feel free to adapt.<\/p>\n
\r\nmkdir -p \/root\/scripts\r\ncat >\/root\/scripts\/backup.sh<<_EOF_\r\n#!\/bin\/bash\r\n\r\nOUTPUT=\"\/backup\"\r\nSOURCE=\"\/var\/www\/\"\r\nPORT=5522\r\nKEY=\"\/root\/.ssh\/backup\"\r\nDEST=\"backup@192.168.1.1:\"\r\n\r\nmkdir \"${OUTPUT}\"\r\n\r\nfor site in $(ls \"${SOURCE}\" | grep -Ev '(cgi-bin|html)')\r\ndo\r\n file=site_$site.`date +%Y%m%d_%s`.tar.gz\r\n tar -czf $OUTPUT\/${file} -C \/var\/www ${site}\r\n scp -oPort=${PORT} -i ${KEY} $OUTPUT\/${file} ${DEST}\r\n rm -rf \"${OUTPUT}\/*\"\r\ndone\r\nchmod +x \/root\/scripts\/backup.sh\r\necho '0 2 * * * root nice \/root\/scripts\/backup.sh >\/dev\/null 2>&1' >> \/etc\/crontab\r\n<\/pre>\nYou should probably do a scp connection to the server first so you can accept the newly learned key for the client.<\/p>\n","protected":false},"excerpt":{"rendered":"
Here are two scripts I wrote that I needed to easily backup databases and some websites. Having the fact that I use SELinux .. with a custom data dir. I needed to this on my server: yum install rssh mkdir \/backup\/.ssh cd \/backup\/.ssh ssh-keygen -t rsa -f .\/backup cat backup.pub >authorized_keys sed -i ‘s\/#allowsftp\/allowsftp\/g’ \/etc\/rssh.conf … Continue reading Simple off-site mysql and website backup<\/span>