{"id":664,"date":"2021-05-10T19:20:20","date_gmt":"2021-05-10T19:20:20","guid":{"rendered":"https:\/\/www.sydspost.nl\/?p=664"},"modified":"2021-06-01T19:34:52","modified_gmt":"2021-06-01T19:34:52","slug":"backup-maken","status":"publish","type":"post","link":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/","title":{"rendered":"Backup maken"},"content":{"rendered":"<p>Je Pi kan stuk gaan, of je formatteert per ongeluk je SD-kaartje, de bliksem slaat in &#8230; kortom een ongelukje zit in een klein hoekje. Het is dan ook belangrijk om van je databases en instellingen een backup te maken op een plek bij voorkeur buitenhuis. Ik heb ervoor gekozen om de backup&#8217;s in Google Drive te zetten.<\/p>\n<p>Ik maak een backup van de volgende databases:<\/p>\n<ul>\n<li>Domoticz<\/li>\n<li>WordPress (deze blog)<\/li>\n<li>Energy (Database met gegevens van mijn energie dataloggers)<\/li>\n<\/ul>\n<p>Benodigheden<\/p>\n<ul>\n<li>geen<\/li>\n<\/ul>\n<p>Reeds up-and-running<\/p>\n<ul>\n<li>Google account<\/li>\n<\/ul>\n<p>Hieronder het stappenplan om dagelijks een backup te maken van je belangrijke databases.<\/p>\n<p>Stap 1. Software installeren die de connectie verzorgt tussen je Pi en Google Drive<\/p>\n<ul>\n<li>Ik gebruik hiervoor rclone, deze software verzorgt de connectie tussen je Raspberry PI en Google Drive. Rclone installeer je als volgt:<\/li>\n<\/ul>\n<p><code>curl <a class=\"ck hp\" href=\"https:\/\/rclone.org\/install.sh\" rel=\"noopener nofollow\">https:\/\/rclone.org\/install.sh<\/a> | sudo bash<\/code><\/p>\n<p>Stap 2. Google Drive API credentials aanmaken voor rclone<\/p>\n<ul>\n<li>Login met je Google account op\u00a0 <a href=\"https:\/\/console.cloud.google.com\/\">https:\/\/console.cloud.google.com\/<\/a><\/li>\n<li>Klik links bovenin op het Navigatiemenu, open APIs &amp; Services, en daarna Library<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-665\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-300x225.jpg\" alt=\"\" width=\"300\" height=\"225\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-300x225.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-440x330.jpg 440w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos.jpg 620w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li>Zoek naar Google Drive API, en enable die<\/li>\n<\/ul>\n<div id='gallery-1' class='gallery galleryid-664 gallery-columns-2 gallery-size-medium'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/naamloos-2\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"194\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-1-300x194.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-1-300x194.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-1.jpg 718w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/naamloos-3\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"194\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-2-300x194.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-2-300x194.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Naamloos-2.jpg 718w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<ul>\n<li>Cre\u00eber Google Drive API credentials voor rclone<\/li>\n<li>Klik binnen APIs &amp; Services op OAuth consent screen, kies voor External en klik op CREATE<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-670\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-6-300x201.jpg\" alt=\"\" width=\"300\" height=\"201\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-6-300x201.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-6-1024x687.jpg 1024w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-6-768x515.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-6.jpg 1046w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<ul>\n<li>Vul bij App name &#8220;rclone&#8221; in, en bij User support email en Developer contact information je mailadres, klik daarna op SAVE AND CONTINUE<\/li>\n<\/ul>\n<div id='gallery-2' class='gallery galleryid-664 gallery-columns-2 gallery-size-medium'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/knipsel-38\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"200\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-7-300x200.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-7-300x200.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-7-1024x684.jpg 1024w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-7-768x513.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-7.jpg 1408w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/knipsel1-7\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"201\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-2-300x201.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-2-300x201.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-2-1024x685.jpg 1024w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-2-768x513.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-2.jpg 1406w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<ul>\n<li>Klik op &#8216;ADD OR REMOVE SCOPES, filter op API: Google Drive API en selecteer Google Drive API &#8220;&#8230;\/auth\/drive&#8221;, klik onderaan op UPDATE, daarna op SAVE AND CONTINUE<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-673\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8-300x149.jpg\" alt=\"\" width=\"725\" height=\"360\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8-300x149.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8-1024x508.jpg 1024w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8-768x381.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8-1536x762.jpg 1536w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-8.jpg 1905w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/p>\n<ul>\n<li>Klik binnen APIs &amp; Services op Credentials, en kies voor +CREATE CREDENTIALS, en daarna voor &#8220;Oauth client ID&#8221;<\/li>\n<li>Kies voor Application type: Desktop app, geef de naam &#8220;rclone&#8221;, en klik op CREATE<\/li>\n<\/ul>\n<div id='gallery-3' class='gallery galleryid-664 gallery-columns-3 gallery-size-medium'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/knipsel-40\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"165\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-9-300x165.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-9-300x165.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-9-768x422.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-9.jpg 920w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/knipsel1-8\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"136\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-3-300x136.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-3-300x136.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-3-1024x463.jpg 1024w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-3-768x347.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel1-3.jpg 1110w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/knipsel-41\/'><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"178\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-10-300x178.jpg\" class=\"attachment-medium size-medium\" alt=\"\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-10-300x178.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-10-768x455.jpg 768w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-10.jpg 1008w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<ul>\n<li>Een client ID &amp; Client Secret wordt nu aangemaakt, deze zijn in de volgende stap nodig<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-677\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/tempsnip-300x260.jpg\" alt=\"\" width=\"300\" height=\"260\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/tempsnip-300x260.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/tempsnip.jpg 648w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Stap 3. rclone configureren<\/p>\n<ul>\n<li>start het configureren met <code># rclone config<\/code><\/li>\n<li>vul achter een volgens de volgende waarden in\n<ul>\n<li>n om een nieuwe remote aan te maken<\/li>\n<li>name: gdrive<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: 'courier new', courier; font-size: 10pt;\"><code>pi@raspberrypi:~ $ rclone config<br \/>\nCurrent remotes:<br \/>\nName Type<br \/>\n==== ====<br \/>\ndrive drive<br \/>\ne) Edit existing remote<br \/>\nn) New remote<br \/>\nd) Delete remote<br \/>\nr) Rename remote<br \/>\nc) Copy remote<br \/>\ns) Set configuration password<br \/>\nq) Quit config<br \/>\ne\/n\/d\/r\/c\/s\/q&gt; n<br \/>\nname&gt; gdrive<\/code><\/span><\/p>\n<ul>\n<li>kies uit de lijst met storage providers het nummer corresponderend met Google Drive \\ &#8220;drive&#8221;, in mijn voorbeeld nummer 15<\/li>\n<\/ul>\n<p><span style=\"font-family: 'courier new', courier; font-size: 10pt;\"><code>15 \/ Google Drive<br \/>\n\\ \"drive\"<\/code><\/span><\/p>\n<ul>\n<li>Google application client id: neem over uit vorige stap<\/li>\n<li>client secret: neem over uit vorige stap<\/li>\n<li>scope: 1 \/Full access all files, excluding Application Data Folder: \\&#8221;drive&#8221;<\/li>\n<li>root_folder_id: leeg laten<\/li>\n<li>service_account_file: leeg laten<\/li>\n<li>edit advanced config: N<\/li>\n<li>remote config use auto config: Y<\/li>\n<li>open de gegenereerde url in je browser en maak het authenticatie proces af, ga terug naar je terminal sessie<\/li>\n<li>team drive: N<\/li>\n<li>Y om de configuratie te bevestigen<\/li>\n<li>q om de configuratie te be\u00ebindigen<\/li>\n<li>test of je toegang hebt tot google drive met <code># rclone ls gdrive:\/<\/code><\/li>\n<\/ul>\n<p>Stap 4. Backup.sh<\/p>\n<ul>\n<li>Plaats onderstaand script in \/backup.sh<\/li>\n<\/ul>\n<p><code><br \/>\npi@raspberrypi:\/ $ cat \/backup.sh<br \/>\n#!\/bin\/bash<br \/>\n##this script will backup mysql and upload it to google drive<br \/>\n##directory name<br \/>\ndirname=$1;<br \/>\n##database name<br \/>\ndatabase=$2;<br \/>\n##database username<br \/>\ndbuser=$3;<br \/>\n##database password<br \/>\ndbpass=$4;<br \/>\n## rclone remote name<br \/>\nrcloneRemoteName=$5;<br \/>\n##google drive folder name<br \/>\ngdrivefoldername=$6;<br \/>\n##condition to check folder exist or not<br \/>\nif [ ! -d \"$dirname\" ]<br \/>\nthen<br \/>\n##create directory<br \/>\nmkdir .\/$dirname<br \/>\nfi<br \/>\n##dump mysql database on server<br \/>\nmysqldump -u $dbuser -p$dbpass $database | gzip&gt;\".\/$dirname\/$database($(date +\\%Y-\\%m-\\%d-\\%H)).sql.gz\"<br \/>\n##wait for 10 seconds<br \/>\nsleep 10<br \/>\n##upload it to google drive<br \/>\nrclone copy \".\/$dirname\/$database($(date +\\%Y-\\%m-\\%d-\\%H)).sql.gz\" $rcloneRemoteName:$gdrivefoldername<br \/>\n## backup wp-content<br \/>\nif [ \"$database\" = \"wordpress\" ]<br \/>\nthen<br \/>\n## zip entire wp-content dir<br \/>\ngzip -cr \/var\/www\/html\/sydspost.nl\/wp-content\/uploads &gt; \".\/$dirname\/wp-contect($(date +\\%Y-\\%m-\\%d-\\%H)).gz\"<br \/>\n##wait for 10 seconds<br \/>\nsleep 10<br \/>\n##upload it to google drive<br \/>\nrclone copy \".\/$dirname\/wp-contect($(date +\\%Y-\\%m-\\%d-\\%H)).gz\" $rcloneRemoteName:$gdrivefoldername<br \/>\n##<br \/>\nfi<\/code><\/p>\n<p>##delete 3 days older file on server to save disk space(this command is optional)<br \/>\nfind .\/$dirname -mtime +3 -type f -delete<\/p>\n<p>exit 0;<\/p>\n<p>Stap 5. Maak crontab regels aan<\/p>\n<ul>\n<li><code>crontab -e<\/code><\/li>\n<li>plaats de volgende regel(s) in de crontab van root of een andere user met voldoende rechten<\/li>\n<\/ul>\n<p><code>0 23 * * * \/backup.sh mysqlbackup energy root &lt;wachtwoord&gt; gdrive BackupFolder<br \/>\n15 23 * * * \/backup.sh mysqlbackup wordpress root &lt;wachtwoord&gt; gdrive BackupFolder<br \/>\n30 23 * * * \/home\/pi\/domoticz\/backups\/backup.sh gdrive BackupFolder<\/code><\/p>\n<p>Toelichting:<\/p>\n<p>Om 23:00 uur wordt het script \/backup.sh gestart met de argumenten:<\/p>\n<ul>\n<li>mysqlbackup: directory naam<\/li>\n<li>energy: database naam<\/li>\n<li>root: mariadb user met rechten op database<\/li>\n<li>&lt;wachtwoord&gt;: wachtwoord van de root user<\/li>\n<li>gdrive: rclone configuratie van Google Drive<\/li>\n<li>BackupFolder: Foldernaam binnen Google Drive waar de backup files terecht komen<\/li>\n<\/ul>\n<p>Om 23:30 uur wordt er een backup van de Domoticz database gemaakt met de argumenten:<\/p>\n<ul>\n<li>gdrive: rclone configuratie van Google Drive<\/li>\n<li>BackupFolder: Foldernaam binnen Google Drive waar de backup files terecht komen<\/li>\n<\/ul>\n<p>Het eindresultaat:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-678\" src=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-11-300x133.jpg\" alt=\"\" width=\"300\" height=\"133\" srcset=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-11-300x133.jpg 300w, https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-11.jpg 676w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Je Pi kan stuk gaan, of je formatteert per ongeluk je SD-kaartje, de bliksem slaat in &#8230; kortom een ongelukje<\/p>\n<p><a href=\"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/\" class=\"more-link\">Verder lezen<span class=\"screen-reader-text\">Backup maken<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":681,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[43],"tags":[99,12,98,66,97],"class_list":["post-664","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-domotica-software","tag-backup","tag-domoticz","tag-google-drive","tag-mariadb","tag-rclone"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Backup maken - Mijn domotica projecten<\/title>\n<meta name=\"description\" content=\"Backup maken van MariaDB en Domoticz database in Google Drive\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Backup maken - Mijn domotica projecten\" \/>\n<meta property=\"og:description\" content=\"Backup maken van MariaDB en Domoticz database in Google Drive\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/\" \/>\n<meta property=\"og:site_name\" content=\"Mijn domotica projecten\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/syds.post\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-10T19:20:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-01T19:34:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"591\" \/>\n\t<meta property=\"og:image:height\" content=\"168\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Syds\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Syds\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/\"},\"author\":{\"name\":\"Syds\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#\\\/schema\\\/person\\\/429f92898f98d9c4e01b8fad60975b21\"},\"headline\":\"Backup maken\",\"datePublished\":\"2021-05-10T19:20:20+00:00\",\"dateModified\":\"2021-06-01T19:34:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/\"},\"wordCount\":578,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Knipsel-12.jpg\",\"keywords\":[\"backup\",\"Domoticz\",\"Google Drive\",\"MariaDB\",\"rclone\"],\"articleSection\":[\"Software\"],\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/\",\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/\",\"name\":\"Backup maken - Mijn domotica projecten\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Knipsel-12.jpg\",\"datePublished\":\"2021-05-10T19:20:20+00:00\",\"dateModified\":\"2021-06-01T19:34:52+00:00\",\"description\":\"Backup maken van MariaDB en Domoticz database in Google Drive\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Knipsel-12.jpg\",\"contentUrl\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/Knipsel-12.jpg\",\"width\":591,\"height\":168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/2021\\\/05\\\/10\\\/backup-maken\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sydspost.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backup maken\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#website\",\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/\",\"name\":\"Mijn domotica projecten\",\"description\":\"met Domoticz\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sydspost.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#organization\",\"name\":\"Mijn domotica projecten\",\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Domoticz-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.sydspost.nl\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Domoticz-logo.png\",\"width\":256,\"height\":256,\"caption\":\"Mijn domotica projecten\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sydspost.nl\\\/#\\\/schema\\\/person\\\/429f92898f98d9c4e01b8fad60975b21\",\"name\":\"Syds\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g\",\"caption\":\"Syds\"},\"sameAs\":[\"https:\\\/\\\/www.sydspost.nl\",\"https:\\\/\\\/www.facebook.com\\\/syds.post\\\/\"],\"url\":\"https:\\\/\\\/www.sydspost.nl\\\/index.php\\\/author\\\/wp_admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Backup maken - Mijn domotica projecten","description":"Backup maken van MariaDB en Domoticz database in Google Drive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/","og_locale":"nl_NL","og_type":"article","og_title":"Backup maken - Mijn domotica projecten","og_description":"Backup maken van MariaDB en Domoticz database in Google Drive","og_url":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/","og_site_name":"Mijn domotica projecten","article_author":"https:\/\/www.facebook.com\/syds.post\/","article_published_time":"2021-05-10T19:20:20+00:00","article_modified_time":"2021-06-01T19:34:52+00:00","og_image":[{"width":591,"height":168,"url":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","type":"image\/jpeg"}],"author":"Syds","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Syds","Geschatte leestijd":"5 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#article","isPartOf":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/"},"author":{"name":"Syds","@id":"https:\/\/www.sydspost.nl\/#\/schema\/person\/429f92898f98d9c4e01b8fad60975b21"},"headline":"Backup maken","datePublished":"2021-05-10T19:20:20+00:00","dateModified":"2021-06-01T19:34:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/"},"wordCount":578,"commentCount":0,"publisher":{"@id":"https:\/\/www.sydspost.nl\/#organization"},"image":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","keywords":["backup","Domoticz","Google Drive","MariaDB","rclone"],"articleSection":["Software"],"inLanguage":"nl-NL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/","url":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/","name":"Backup maken - Mijn domotica projecten","isPartOf":{"@id":"https:\/\/www.sydspost.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#primaryimage"},"image":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","datePublished":"2021-05-10T19:20:20+00:00","dateModified":"2021-06-01T19:34:52+00:00","description":"Backup maken van MariaDB en Domoticz database in Google Drive","breadcrumb":{"@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#primaryimage","url":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","contentUrl":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","width":591,"height":168},{"@type":"BreadcrumbList","@id":"https:\/\/www.sydspost.nl\/index.php\/2021\/05\/10\/backup-maken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sydspost.nl\/"},{"@type":"ListItem","position":2,"name":"Backup maken"}]},{"@type":"WebSite","@id":"https:\/\/www.sydspost.nl\/#website","url":"https:\/\/www.sydspost.nl\/","name":"Mijn domotica projecten","description":"met Domoticz","publisher":{"@id":"https:\/\/www.sydspost.nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sydspost.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/www.sydspost.nl\/#organization","name":"Mijn domotica projecten","url":"https:\/\/www.sydspost.nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/www.sydspost.nl\/#\/schema\/logo\/image\/","url":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2020\/12\/Domoticz-logo.png","contentUrl":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2020\/12\/Domoticz-logo.png","width":256,"height":256,"caption":"Mijn domotica projecten"},"image":{"@id":"https:\/\/www.sydspost.nl\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.sydspost.nl\/#\/schema\/person\/429f92898f98d9c4e01b8fad60975b21","name":"Syds","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/secure.gravatar.com\/avatar\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fe78554f84c2c27fe1c643dcb3f2d0231d9a2dcdb96cc25f3538e38d9465e24d?s=96&d=mm&r=g","caption":"Syds"},"sameAs":["https:\/\/www.sydspost.nl","https:\/\/www.facebook.com\/syds.post\/"],"url":"https:\/\/www.sydspost.nl\/index.php\/author\/wp_admin\/"}]}},"modified_by":"Syds","jetpack_featured_media_url":"https:\/\/www.sydspost.nl\/wp-content\/uploads\/2021\/05\/Knipsel-12.jpg","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/posts\/664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/comments?post=664"}],"version-history":[{"count":5,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/posts\/664\/revisions"}],"predecessor-version":[{"id":984,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/posts\/664\/revisions\/984"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/media\/681"}],"wp:attachment":[{"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/media?parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/categories?post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sydspost.nl\/index.php\/wp-json\/wp\/v2\/tags?post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}