{"id":398,"date":"2012-02-23T09:33:08","date_gmt":"2012-02-23T08:33:08","guid":{"rendered":"http:\/\/blog.protagonist.nl\/?p=398"},"modified":"2012-02-23T09:33:08","modified_gmt":"2012-02-23T08:33:08","slug":"geplande-database-backup-maken","status":"publish","type":"post","link":"https:\/\/www.protagonist.nl\/blog\/blog\/2012\/02\/geplande-database-backup-maken\/","title":{"rendered":"Geplande database-backup maken"},"content":{"rendered":"<p>Om een backup te maken van uw database, moet u deze &#8220;dumpen&#8221;. Dit houdt in dat de gehele structuur en inhoud van de database wordt weggeschreven naar een tekstbestand, welke u later weer kunt importeren om een backup terug te zetten. Het Plesk control panel maakt het voor u mogelijk om via zogenaamde cron-tabs automatisch een opdracht uit te laten voeren, op een vooraf ingestelde interval. Zo kunt u dus ook automatisch een backup van uw database laten maken.<\/p>\n<p><!--more--><\/p>\n<p>De volgende twee commando&#8217;s kunt u door het Plesk control panel uit laten voeren onder het kopje <strong>Ingeroosterde taken<\/strong>. Daar maakt u een nieuwe taak aan, met de onderstaande instellingen. Deze instellingen maken het mogelijk dat er elke dag om 23:00 uur een backup wordt gemaakt van uw database. Uiteraard kunt u altijd de waarden hiervan veranderen.<\/p>\n<ul>\n<li>Ingeschakeld: <strong>Ja<\/strong><\/li>\n<li>Minuut: <strong>0<\/strong><\/li>\n<li>Uur: <strong>23<\/strong><\/li>\n<li>Dag van de maand: <strong>*<\/strong><\/li>\n<li>Maand: <strong>*<\/strong><\/li>\n<li>Dag van de week: <strong>*<\/strong><\/li>\n<\/ul>\n<p>In het invoerveld <strong>Opdracht<\/strong> voert u \u00e9\u00e9n van de volgende twee opdrachten in, waarbij u alle <strong>[WAARDEN]<\/strong> vervangt met de informatie van uw database. De eerste opdracht stuurt de complete dump van de database naar uw e-mailadres. De tweede opdracht maakt een backup in de vorm van een .sql-bestand in de <em>private<\/em>-map van uw FTP-account.<\/p>\n<p><code>\/usr\/bin\/mysqldump -u '<strong>[MYSQL-GEBRUIKERSNAAM]<\/strong>' --password='<strong>[MYSQL-WACHTWOORD]<\/strong>' --databases '<strong>[MYSQL-DATABASE]<\/strong>' | mail -s 'Database Backup '`\/bin\/date +%Y%m%d` '<strong>[EMAIL-ADRES]<\/strong>'<\/code><\/p>\n<p><code>\/usr\/bin\/mysqldump -u '<strong>[MYSQL-GEBRUIKERSNAAM]<\/strong>' --password='<strong>[MYSQL-WACHTWOORD]<\/strong>' --databases '<strong>[MYSQL-DATABASE]<\/strong>' &gt; \/var\/www\/vhosts\/<strong>[DOMEINNAAM]<\/strong>\/private\/dump_`\/bin\/date +%Y%m%d`.sql<\/code><\/p>\n<p>Uiteraard bent u vrij om de inhoud van de ingeroosterde taken naar eigen wens in te vullen. U kunt bijvoorbeeld twee keer per dag een opdracht uit laten voeren, zodat u een backup van &#8216;s ochtends en &#8216;s avonds heeft. Onze support-afdeling staat u graag te woord over al uw vragen over de zogenaamde &#8220;cron-jobs&#8221;. U kunt ons bereiken via het e-mailadres <a href=\"mailto:support@protagonist.nl\">support@protagonist.nl<\/a> of het telefoonnummer 088-333 44 44 (optie 2).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Om een backup te maken van uw database, moet u deze &#8220;dumpen&#8221;. Dit houdt in dat de gehele structuur en inhoud van de database wordt weggeschreven naar een tekstbestand, welke u later weer kunt importeren om een backup terug te zetten. Het Plesk control panel maakt het voor u mogelijk om via zogenaamde cron-tabs automatisch\u2026 <a class=\"moretag text-primary text-nowrap d-block mt-3\" href=\"https:\/\/www.protagonist.nl\/blog\/blog\/2012\/02\/geplande-database-backup-maken\/\">Lees meer \u203a<\/a><\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[52,75,119,123],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-backup-2","tag-database","tag-mysql-2","tag-opslaan"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Geplande database-backup maken - Protagonist<\/title>\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.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Geplande database-backup maken - Protagonist\" \/>\n<meta property=\"og:description\" content=\"Om een backup te maken van uw database, moet u deze &#8220;dumpen&#8221;. Dit houdt in dat de gehele structuur en inhoud van de database wordt weggeschreven naar een tekstbestand, welke u later weer kunt importeren om een backup terug te zetten. Het Plesk control panel maakt het voor u mogelijk om via zogenaamde cron-tabs automatisch\u2026 Lees meer \u203a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/\" \/>\n<meta property=\"og:site_name\" content=\"Protagonist\" \/>\n<meta property=\"article:published_time\" content=\"2012-02-23T08:33:08+00:00\" \/>\n<meta name=\"author\" content=\"Krzysztof Chak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Krzysztof Chak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/\"},\"author\":{\"name\":\"Krzysztof Chak\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/#\\\/schema\\\/person\\\/3b7c51204915b7744a9af2cd380200ae\"},\"headline\":\"Geplande database-backup maken\",\"datePublished\":\"2012-02-23T08:33:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/\"},\"wordCount\":277,\"commentCount\":0,\"keywords\":[\"Backup\",\"Database\",\"MySQL\",\"Opslaan\"],\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/\",\"url\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/\",\"name\":\"Geplande database-backup maken - Protagonist\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/#website\"},\"datePublished\":\"2012-02-23T08:33:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/#\\\/schema\\\/person\\\/3b7c51204915b7744a9af2cd380200ae\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/2012\\\/02\\\/geplande-database-backup-maken\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Webhosting\",\"item\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/category\\\/webhosting\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/category\\\/webhosting\\\/mysql\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Geplande database-backup maken\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/\",\"name\":\"Protagonist\",\"description\":\"Protagonist blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/#\\\/schema\\\/person\\\/3b7c51204915b7744a9af2cd380200ae\",\"name\":\"Krzysztof Chak\",\"url\":\"https:\\\/\\\/www.protagonist.nl\\\/blog\\\/blog\\\/author\\\/krzysztof-chak\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Geplande database-backup maken - Protagonist","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.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/","og_locale":"en_US","og_type":"article","og_title":"Geplande database-backup maken - Protagonist","og_description":"Om een backup te maken van uw database, moet u deze &#8220;dumpen&#8221;. Dit houdt in dat de gehele structuur en inhoud van de database wordt weggeschreven naar een tekstbestand, welke u later weer kunt importeren om een backup terug te zetten. Het Plesk control panel maakt het voor u mogelijk om via zogenaamde cron-tabs automatisch\u2026 Lees meer \u203a","og_url":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/","og_site_name":"Protagonist","article_published_time":"2012-02-23T08:33:08+00:00","author":"Krzysztof Chak","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Krzysztof Chak","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/#article","isPartOf":{"@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/"},"author":{"name":"Krzysztof Chak","@id":"https:\/\/www.protagonist.nl\/blog\/#\/schema\/person\/3b7c51204915b7744a9af2cd380200ae"},"headline":"Geplande database-backup maken","datePublished":"2012-02-23T08:33:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/"},"wordCount":277,"commentCount":0,"keywords":["Backup","Database","MySQL","Opslaan"],"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/","url":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/","name":"Geplande database-backup maken - Protagonist","isPartOf":{"@id":"https:\/\/www.protagonist.nl\/blog\/#website"},"datePublished":"2012-02-23T08:33:08+00:00","author":{"@id":"https:\/\/www.protagonist.nl\/blog\/#\/schema\/person\/3b7c51204915b7744a9af2cd380200ae"},"breadcrumb":{"@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.protagonist.nl\/blog\/2012\/02\/geplande-database-backup-maken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Webhosting","item":"https:\/\/www.protagonist.nl\/blog\/category\/webhosting\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/www.protagonist.nl\/blog\/category\/webhosting\/mysql\/"},{"@type":"ListItem","position":3,"name":"Geplande database-backup maken"}]},{"@type":"WebSite","@id":"https:\/\/www.protagonist.nl\/blog\/#website","url":"https:\/\/www.protagonist.nl\/blog\/","name":"Protagonist","description":"Protagonist blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.protagonist.nl\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.protagonist.nl\/blog\/#\/schema\/person\/3b7c51204915b7744a9af2cd380200ae","name":"Krzysztof Chak","url":"https:\/\/www.protagonist.nl\/blog\/blog\/author\/krzysztof-chak\/"}]}},"meta_box":{"video-url_1":""},"_links":{"self":[{"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/comments?post=398"}],"version-history":[{"count":0,"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/posts\/398\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/media?parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/categories?post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.protagonist.nl\/blog\/wp-json\/wp\/v2\/tags?post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}