{"id":89,"date":"2006-12-05T00:37:04","date_gmt":"2006-12-04T22:37:04","guid":{"rendered":"http:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/"},"modified":"2009-08-29T21:23:36","modified_gmt":"2009-08-29T20:23:36","slug":"mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper","status":"publish","type":"post","link":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/","title":{"rendered":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:68,&quot;href&quot;:&quot;http:\\\/\\\/www.phpmyadmin.net&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20251012171531\\\/https:\\\/\\\/www.phpmyadmin.net\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-03 17:18:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-08 16:51:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-15 10:34:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 16:47:33&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 01:34:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-05 14:27:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-13 07:21:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-20 02:18:32&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-23 12:12:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-30 09:31:57&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-05 21:10:06&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-02-09 16:02:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-14 09:06:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-18 04:19:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 19:59:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-28 22:44:11&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-06 18:21:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-10 13:00:59&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-18 02:11:36&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-22 05:01:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-25 09:25:06&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-28 09:49:34&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-31 10:52:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 01:16:17&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-07 10:08:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-11 02:57:58&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-14 20:06:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-18 03:50:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-21 08:07:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-24 09:40:38&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-27 10:40:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-01 04:50:13&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-01 04:50:13&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:650,&quot;href&quot;:&quot;http:\\\/\\\/www.mysqldumper.de&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250724063856\\\/https:\\\/\\\/www.mysqldumper.de\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-04 02:17:21&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-10 16:39:35&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-15 19:37:37&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-21 08:26:07&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-26 10:10:01&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-31 06:42:48&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-06 22:54:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-11 21:29:05&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-16 12:30:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-26 07:27:53&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-02 07:32:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-09 19:11:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-17 19:34:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-23 19:31:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-27 08:33:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-30 11:58:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-04 01:16:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 11:31:31&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-12 22:13:42&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-16 10:26:37&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-19 19:30:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-22 22:13:09&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-26 23:47:06&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-26 23:47:06&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;},{&quot;id&quot;:2415,&quot;href&quot;:&quot;http:\\\/\\\/www.phpmybackuppro.net&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250816035435\\\/https:\\\/\\\/phpmybackuppro.net\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-05 07:50:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-15 19:37:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-21 22:52:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-06 23:06:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-26 04:31:54&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-09 19:11:48&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-24 05:31:22&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-27 11:23:48&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-03-30 11:58:27&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-04 03:46:50&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-09 18:36:07&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-15 15:58:25&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-19 19:31:06&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-25 11:07:59&quot;,&quot;http_code&quot;:404},{&quot;date&quot;:&quot;2026-04-28 21:24:32&quot;,&quot;http_code&quot;:404}],&quot;broken&quot;:true,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-04-28 21:24:32&quot;,&quot;http_code&quot;:404},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png\" alt=\"\" width=\"344\" height=\"67\" \/><\/p>\n<p>Wer einen MySQL-Datenbank-Server auf einem Shared Hosting Account benutzt, hat in aller Regel nur beschr\u00e4nkten Zugriff darauf. Das Sichern einer Datenbank\u00a0in eine SQL-Datei\u00a0zwecks Backup oder Migration ist dann schwierig, und dasselbe gilt f\u00fcr das Einlesen einer solchen Datei. Das Standard-Tool <a href=\"http:\/\/www.phpmyadmin.net\">phpMyAdmin<\/a> bietet zwar die M\u00f6glichkeit, Datenbanken zu exportieren und importieren, allerdings kastrieren viele Hoster diese Funktion durch die Beschr\u00e4nkung der zul\u00e4ssigen Dateigr\u00f6sse. Ein anderer Weg f\u00fchrt \u00fcber MySQL Frontends wie z.B. <a href=\"http:\/\/www.workshop.ch\/openmind\/2006\/11\/28\/heidisql-neues-frontend-fr-mysql-datenbanken\/\">HeidiSQL<\/a>, aber auch hier machen einem Timeouts und\u00a0Sicherheitsmechanismen der Hoster\u00a0das Leben schwer.<\/p>\n<p>Eine ebenso einfache wie leistungsf\u00e4hige L\u00f6sung f\u00fcr die oben geschilderten Probleme stellt <a href=\"http:\/\/www.mysqldumper.de\/\">MySQL Dumper<\/a> dar. Das PHP-Skript sichert Datenbanken\u00a0(oder\u00a0einzelne Tabellen daraus) in\u00a0platzsparende GZ-Archive und spielt sie auch wieder zur\u00fcck.\u00a0Backups k\u00f6nnen auch\u00a0automatisiert durchgef\u00fchrt, per\u00a0E-Mail best\u00e4tigt und per FTP-Transfer ausgelagert werden. Das Skript \u00fcberzeugt durch eine sehr \u00fcbersichtliche Benutzeroberfl\u00e4che und eine gepflegte Website mit detaillierten Screenshots plus einer deutschen Video-Einf\u00fchrung.\u00a0MySQL Dumper untersteht der GNU General Public License.\u00a0(Danke f\u00fcr den Tipp, Matthias!)<\/p>\n<p>P.S. Ein weiteres Tool, das im Prinzip denselben Zweck erf\u00fcllt, ist <a href=\"http:\/\/www.phpmybackuppro.net\">phpMyBackupPro<\/a>.<\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Wer einen MySQL-Datenbank-Server auf einem Shared Hosting Account benutzt, hat in aller Regel nur beschr\u00e4nkten Zugriff darauf. Das Sichern einer Datenbank\u00a0in eine SQL-Datei\u00a0zwecks Backup oder Migration ist dann schwierig, und dasselbe gilt f\u00fcr das Einlesen einer solchen Datei. Das Standard-Tool phpMyAdmin bietet zwar die M\u00f6glichkeit, Datenbanken zu exportieren und importieren, allerdings kastrieren viele Hoster diese &#8230; <a title=\"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper\" class=\"read-more\" href=\"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/\" aria-label=\"Read more about MySQL-Datenbanken backupen und migrieren mit MySQL Dumper\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":""},"categories":[1542],"tags":[969,103,165,336],"class_list":["post-89","post","type-post","status-publish","format-standard","hentry","category-datenbanken","tag-archivierung","tag-backup","tag-mysql","tag-mysql-dumper"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind<\/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.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind\" \/>\n<meta property=\"og:description\" content=\"Wer einen MySQL-Datenbank-Server auf einem Shared Hosting Account benutzt, hat in aller Regel nur beschr\u00e4nkten Zugriff darauf. Das Sichern einer Datenbank\u00a0in eine SQL-Datei\u00a0zwecks Backup oder Migration ist dann schwierig, und dasselbe gilt f\u00fcr das Einlesen einer solchen Datei. Das Standard-Tool phpMyAdmin bietet zwar die M\u00f6glichkeit, Datenbanken zu exportieren und importieren, allerdings kastrieren viele Hoster diese ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/\" \/>\n<meta property=\"og:site_name\" content=\"Open Mind\" \/>\n<meta property=\"article:published_time\" content=\"2006-12-04T22:37:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2009-08-29T20:23:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png\" \/>\n<meta name=\"author\" content=\"The Open Source Guy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschrieben von\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Open Source Guy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/\"},\"author\":{\"name\":\"The Open Source Guy\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"headline\":\"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper\",\"datePublished\":\"2006-12-04T22:37:04+00:00\",\"dateModified\":\"2009-08-29T20:23:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/\"},\"wordCount\":203,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2006\\\/12\\\/WindowsLiveWriter\\\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\\\/image%7B0%7D%5B2%5D.png\",\"keywords\":[\"Archivierung\",\"Backup\",\"MySQL\",\"MySQL Dumper\"],\"articleSection\":[\"Datenbanken\"],\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/\",\"name\":\"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2006\\\/12\\\/WindowsLiveWriter\\\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\\\/image%7B0%7D%5B2%5D.png\",\"datePublished\":\"2006-12-04T22:37:04+00:00\",\"dateModified\":\"2009-08-29T20:23:36+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#breadcrumb\"},\"inLanguage\":\"de-CH\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2006\\\/12\\\/WindowsLiveWriter\\\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\\\/image%7B0%7D%5B2%5D.png\",\"contentUrl\":\"http:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/uploads\\\/2006\\\/12\\\/WindowsLiveWriter\\\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\\\/image%7B0%7D%5B2%5D.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/2006\\\/12\\\/05\\\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#website\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/\",\"name\":\"Open Mind\",\"description\":\"Open Source &amp; Open Content\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de-CH\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/#\\\/schema\\\/person\\\/74ece7dcefab45da1c0cc78b2e48d793\",\"name\":\"The Open Source Guy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de-CH\",\"@id\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"contentUrl\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\\\/wp-content\\\/plugins\\\/avatar-privacy\\\/public\\\/images\\\/mystery.svg\",\"caption\":\"The Open Source Guy\"},\"url\":\"https:\\\/\\\/www.workshop.ch\\\/openmind\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind","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.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/","og_locale":"de_DE","og_type":"article","og_title":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind","og_description":"Wer einen MySQL-Datenbank-Server auf einem Shared Hosting Account benutzt, hat in aller Regel nur beschr\u00e4nkten Zugriff darauf. Das Sichern einer Datenbank\u00a0in eine SQL-Datei\u00a0zwecks Backup oder Migration ist dann schwierig, und dasselbe gilt f\u00fcr das Einlesen einer solchen Datei. Das Standard-Tool phpMyAdmin bietet zwar die M\u00f6glichkeit, Datenbanken zu exportieren und importieren, allerdings kastrieren viele Hoster diese ... Read more","og_url":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/","og_site_name":"Open Mind","article_published_time":"2006-12-04T22:37:04+00:00","article_modified_time":"2009-08-29T20:23:36+00:00","og_image":[{"url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png","type":"","width":"","height":""}],"author":"The Open Source Guy","twitter_card":"summary_large_image","twitter_misc":{"Geschrieben von":"The Open Source Guy","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#article","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/"},"author":{"name":"The Open Source Guy","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"headline":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper","datePublished":"2006-12-04T22:37:04+00:00","dateModified":"2009-08-29T20:23:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/"},"wordCount":203,"commentCount":1,"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png","keywords":["Archivierung","Backup","MySQL","MySQL Dumper"],"articleSection":["Datenbanken"],"inLanguage":"de-CH","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/","url":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/","name":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper - Open Mind","isPartOf":{"@id":"https:\/\/www.workshop.ch\/openmind\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#primaryimage"},"image":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#primaryimage"},"thumbnailUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png","datePublished":"2006-12-04T22:37:04+00:00","dateModified":"2009-08-29T20:23:36+00:00","author":{"@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793"},"breadcrumb":{"@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#breadcrumb"},"inLanguage":"de-CH","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/"]}]},{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#primaryimage","url":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png","contentUrl":"http:\/\/www.workshop.ch\/openmind\/wp-content\/uploads\/2006\/12\/WindowsLiveWriter\/MySQLDatenbankenbackupenundmigrierenmitM_14BA9\/image%7B0%7D%5B2%5D.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.workshop.ch\/openmind\/2006\/12\/05\/mysql-datenbanken-backupen-und-migrieren-mit-mysql-dumper\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.workshop.ch\/openmind\/"},{"@type":"ListItem","position":2,"name":"MySQL-Datenbanken backupen und migrieren mit MySQL Dumper"}]},{"@type":"WebSite","@id":"https:\/\/www.workshop.ch\/openmind\/#website","url":"https:\/\/www.workshop.ch\/openmind\/","name":"Open Mind","description":"Open Source &amp; Open Content","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.workshop.ch\/openmind\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de-CH"},{"@type":"Person","@id":"https:\/\/www.workshop.ch\/openmind\/#\/schema\/person\/74ece7dcefab45da1c0cc78b2e48d793","name":"The Open Source Guy","image":{"@type":"ImageObject","inLanguage":"de-CH","@id":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","url":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","contentUrl":"https:\/\/www.workshop.ch\/openmind\/wp-content\/plugins\/avatar-privacy\/public\/images\/mystery.svg","caption":"The Open Source Guy"},"url":"https:\/\/www.workshop.ch\/openmind"}]}},"_links":{"self":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/89","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/comments?post=89"}],"version-history":[{"count":1,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":1531,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/posts\/89\/revisions\/1531"}],"wp:attachment":[{"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.workshop.ch\/openmind\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}