{"id":801,"date":"2023-07-02T12:45:26","date_gmt":"2023-07-02T10:45:26","guid":{"rendered":"https:\/\/pcmacb.de\/?page_id=801"},"modified":"2023-07-02T12:49:54","modified_gmt":"2023-07-02T10:49:54","slug":"backup-sql-datenbanken","status":"publish","type":"page","link":"https:\/\/pcmacb.de\/?page_id=801","title":{"rendered":"Backup-Skript f\u00fcr SQL Datenbanken"},"content":{"rendered":"\n<p>ein Beispielscript zur t\u00e4glichen Sicherung von SQL Datenbanken. In diesem Fall haupts\u00e4chlich zur Sicherung von NEXTCLOUD.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/sh\n#vars\nTIME=\"$(date +%d.%b_%H-%M-%S)\"\nLOG=\"\/root\/scripts\/log\/$TIME-sqlbak.log\"\nBACKUPDIR=\"\/BAK\/mysql-bak\"\nTO=\"Die-EMAIL-ADRESSE-an-die-log-gesendet-werden-soll\"\nUSERNAME=root\nmkdir -p $BACKUPDIR 2&gt;\/dev\/null\n\n#functions\n#maintenance NEXTCLOUD\nocc-on()\n{\n   sudo -u www-data php \/var\/www\/nextcloud\/occ maintenance:mode --on\n}\nocc-off()\n{\n   sudo -u www-data php \/var\/www\/nextcloud\/occ maintenance:mode --off\n}\n#Mail function\nlogmail()\n{\n    echo \"Subject: t\u00e4gliches SQL Backup\" &gt;&gt; $LOG\n    echo \"Content-Type: text\/plain; charset=\"utf-8\"\" &gt;&gt; $LOG\n    HDD=\"$(df -h)\"; echo -e \"\\n \\n$HDD \\n\" &gt;&gt; $LOG\n    echo \"Um $TIME wurde das SQL Backup gemacht: $FLIST\" &gt;&gt; $LOG\n    \/usr\/sbin\/sendmail -bm $TO &lt; $LOG\n}\n    \ncd $BACKUPDIR\nocc-on\nfor DATABASE in nextcloud mysql rainloop wordpressdb; do\n       mysqldump -u$USERNAME $DATABASE &gt; ${DATABASE}-$(date +%F_%H%M).sql\ndone\nocc-off\n\nFLIST=$(ls -l $BACKUPDIR)\nlogmail\n\n# Alte Backups l\u00f6schen\nfind \/BAK\/mysql-bak -type f -mtime +20 -exec rm -f {} \\;\nfind \/root\/scripts\/log\/ -maxdepth 1 -type f -mtime +40 -exec rm -f {} \\;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>ein Beispielscript zur t\u00e4glichen Sicherung von SQL Datenbanken. In diesem Fall haupts\u00e4chlich zur Sicherung von NEXTCLOUD.<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"class_list":["post-801","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/801","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/pcmacb.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=801"}],"version-history":[{"count":5,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/801\/revisions"}],"predecessor-version":[{"id":807,"href":"https:\/\/pcmacb.de\/index.php?rest_route=\/wp\/v2\/pages\/801\/revisions\/807"}],"wp:attachment":[{"href":"https:\/\/pcmacb.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}