{"id":14890,"date":"2024-03-03T12:46:57","date_gmt":"2024-03-03T09:16:57","guid":{"rendered":"https:\/\/www.itpiran.net\/blog\/?p=14890"},"modified":"2024-03-03T12:46:57","modified_gmt":"2024-03-03T09:16:57","slug":"%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7","status":"publish","type":"post","link":"https:\/\/www.itpiran.net\/blog\/de\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/","title":{"rendered":"Wie man Datenbanken in MySQL oder MariaDB importiert und exportiert"},"content":{"rendered":"<h2 id=\"%d9%85%d9%82%d8%af%d9%85%d9%87\">Einf\u00fchrung:<\/h2>\n<p>Das Importieren und Exportieren von Datenbanken ist eine g\u00e4ngige Aufgabe in der Softwareentwicklung. Mithilfe von Datensicherungen k\u00f6nnen Sie Ihre Daten sichern und wiederherstellen. Sie k\u00f6nnen diese Funktion auch verwenden, um Daten auf einen neuen Server oder eine neue Entwicklungsumgebung zu migrieren.<\/p>\n<p>In diesem Tutorial arbeiten Sie mit Datenbank-Dumps in MySQL oder MariaDB (die Befehle sind austauschbar). Konkret exportieren Sie eine Datenbank und importieren diese anschlie\u00dfend aus der Dump-Datei.<\/p>\n<h5 id=\"%d9%be%db%8c%d8%b4-%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\">Voraussetzungen<\/h5>\n<ul>\n<li>Eine virtuelle Maschine mit einem sudo-Benutzer ohne Root-Rechte.<\/li>\n<li>MySQL oder MariaDB installiert<\/li>\n<li>Eine auf Ihrem Datenbankserver erstellte Beispieldatenbank<\/li>\n<\/ul>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-1-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%db%8c%da%a9-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-mysql-%db%8c%d8%a7-mariadb\">Schritt 1 \u2013 Exportieren einer MySQL- oder MariaDB-Datenbank<\/h2>\n<p>Konsolentool <code>mysqldump<\/code> Exportiert Datenbanken in SQL-Textdateien. Dies vereinfacht die Migration und den Wechsel von Datenbanken. Sie ben\u00f6tigen den Namen Ihrer Datenbank und die Anmeldeinformationen eines Kontos mit mindestens vollst\u00e4ndigem Lesezugriff auf die Datenbank.<\/p>\n<p>Aus <code>mysqldump<\/code> Zum Exportieren Ihrer Datenbank verwenden Sie:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>mysqldump -u username -p database_name &gt; data-dump.sql<\/code><\/pre>\n<\/div>\n<ul>\n<li><code>Benutzername<\/code>: ist der Benutzername, mit dem Sie sich in die Datenbank einloggen k\u00f6nnen.<\/li>\n<li><code>Datenbankname<\/code> Der Name der zu exportierenden Datenbank lautet:<\/li>\n<li><code>data-dump.sql<\/code> Eine Datei im aktuellen Verzeichnis, die die Ausgabe speichert.<\/li>\n<\/ul>\n<p>Dieser Befehl erzeugt keine visuelle Ausgabe, aber Sie k\u00f6nnen den Inhalt anzeigen. <code>data-dump.sql<\/code> Pr\u00fcfen Sie, ob es sich um eine legitime SQL-Dump-Datei handelt.<\/p>\n<p>F\u00fchren Sie folgenden Befehl aus:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>head -n 5 data-dump.sql<\/code><\/pre>\n<\/div>\n<p>Der Anfang der Datei sollte in etwa so aussehen und enth\u00e4lt einen MySQL-Wrapper f\u00fcr eine Datenbank namens <code>Datenbankname<\/code> Das zeigt sich.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>SQL dump fragment\r\n-- MySQL dump 10.13 Distrib 5.7.16, for Linux (x86_64)\r\n--\r\n-- Host: localhost Database: database_name\r\n-- ------------------------------------------------------\r\n-- Server version 5.7.16-0ubuntu0.16.04.1<\/code><\/pre>\n<\/div>\n<p>Wenn w\u00e4hrend des Exportvorgangs ein Fehler auftritt, <code>mysqldump<\/code> Es druckt sie auf dem Bildschirm aus.<\/p>\n<h2 id=\"%d9%85%d8%b1%d8%ad%d9%84%d9%87-2-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%db%8c%da%a9-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d8%af%d8%a7%d8%af%d9%87-mysql-%db%8c%d8%a7-mariadb\">Schritt 2 \u2013 Importieren einer MySQL- oder MariaDB-Datenbank<\/h2>\n<p>Um eine bestehende Dump-Datei in MySQL oder MariaDB zu importieren, m\u00fcssen Sie eine neue Datenbank erstellen. Diese wird die importierten Datenbanken aufnehmen.<\/p>\n<p>Melden Sie sich zun\u00e4chst als Root oder ein anderer Benutzer mit ausreichenden Berechtigungen zum Erstellen einer neuen Datenbank bei MySQL an:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>mysql -u root -p<\/code><\/pre>\n<\/div>\n<p>Dieser Befehl f\u00fchrt Sie zur MySQL-Shell. Erstellen Sie anschlie\u00dfend mit dem folgenden Befehl eine neue Datenbank. In diesem Beispiel lautet die neue Datenbank <code>neue_Datenbank<\/code> Es hei\u00dft:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE DATABASE new_database;<\/code><\/pre>\n<\/div>\n<p>Sie sehen diese Ausgabe, die die Erstellung der Datenbank best\u00e4tigt.<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-plain\" data-lang=\"Plain Text\"><code>Output\r\nQuery OK, 1 row affected (0.00 sec)<\/code><\/pre>\n<\/div>\n<p>Dann durch Dr\u00fccken <code>STRG+D<\/code> Beenden Sie die MySQL-Shell. \u00dcber die regul\u00e4re Befehlszeile k\u00f6nnen Sie die Dump-Datei mit folgendem Befehl importieren:<\/p>\n<div class=\"hcb_wrap\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>mysql -u username -p new_database &lt; data-dump.sql<\/code><\/pre>\n<\/div>\n<ul>\n<li><code>BENUTZERNAME<\/code> Dies ist der Benutzername, mit dem Sie sich in die Datenbank einloggen k\u00f6nnen.<\/li>\n<li><code>neue Datenbank<\/code> Der Name der neu erstellten Datenbank<\/li>\n<li><code>data-dump.sql<\/code> Die Dump-Datei enth\u00e4lt die zu importierenden Daten und befindet sich im aktuellen Verzeichnis.<\/li>\n<\/ul>\n<p>Wird der Befehl erfolgreich ausgef\u00fchrt, erfolgt keine Ausgabe. Tritt w\u00e4hrend der Ausf\u00fchrung ein Fehler auf, <code>MySQL<\/code> Die Daten werden im Terminal ausgegeben. Um zu \u00fcberpr\u00fcfen, ob der Import erfolgreich war, melden Sie sich in der MySQL-Shell an und pr\u00fcfen Sie die Daten. W\u00e4hlen Sie die neue Datenbank mit USE aus. <code>neue_Datenbank<\/code> und dann verwenden <code>TABELLEN ANZEIGEN.<\/code> Oder ein \u00e4hnlicher Befehl, um einige Daten anzuzeigen.<\/p>\n<h2 id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\">Ergebnis<\/h2>\n<p>In diesem Tutorial haben Sie eine Datenbank aus einer MySQL- oder MariaDB-Datenbank erstellt und diese Daten anschlie\u00dfend in eine neue Datenbank importiert. mysqldump bietet zus\u00e4tzliche Einstellungen, mit denen Sie die Erstellung des Daten-Dumps anpassen k\u00f6nnen. Weitere Informationen finden Sie in der offiziellen Dokumentation zu mysqldump.<\/p>","protected":false},"excerpt":{"rendered":"Einleitung: Das Importieren und Exportieren von Datenbanken ist eine h\u00e4ufige Aufgabe in der Softwareentwicklung. Sie k\u00f6nnen dazu die Funktion \u201eDaten exportieren\u201c verwenden\u2026","protected":false},"author":1,"featured_media":14892,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_yoast_wpseo_focuskw":"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL","_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"","_yoast_wpseo_canonical":"","_yoast_wpseo_opengraph-description":"","_yoast_wpseo_opengraph-image":"","_yoast_wpseo_twitter-description":"","_yoast_wpseo_twitter-image":"","_yoast_wpseo_focuskeywords":"","_yoast_wpseo_primary_category":"193","footnotes":""},"categories":[193,349],"tags":[403,391],"class_list":{"0":"post-14890","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-tutorials","8":"category-database","9":"tag-data-base","10":"tag-mysql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB - \u0628\u0644\u0627\u06af ITPiran<\/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.itpiran.net\/blog\/de\/tutorials\/\u0646\u062d\u0648\u0647-\u0648\u0627\u0631\u062f-\u06a9\u0631\u062f\u0646-\u0648-\u0635\u0627\u062f\u0631-\u06a9\u0631\u062f\u0646-\u067e\u0627\u06cc\u06af\u0627\u0647-\u0647\u0627\u06cc-\u062f\u0627\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB - \u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"og:description\" content=\"\u0645\u0642\u062f\u0645\u0647: \u0648\u0627\u0631\u062f\u0627\u062a \u0648 \u0635\u0627\u062f\u0631\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u062f\u0631 \u062a\u0648\u0633\u0639\u0647 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0627\u0633\u062a. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc dump&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.itpiran.net\/blog\/de\/tutorials\/\u0646\u062d\u0648\u0647-\u0648\u0627\u0631\u062f-\u06a9\u0631\u062f\u0646-\u0648-\u0635\u0627\u062f\u0631-\u06a9\u0631\u062f\u0646-\u067e\u0627\u06cc\u06af\u0627\u0647-\u0647\u0627\u06cc-\u062f\u0627\/\" \/>\n<meta property=\"og:site_name\" content=\"\u0628\u0644\u0627\u06af ITPiran\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-03T09:16:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1793\" \/>\n\t<meta property=\"og:image:height\" content=\"1110\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\"},\"headline\":\"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB\",\"datePublished\":\"2024-03-03T09:16:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/\"},\"wordCount\":34,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/03\\\/03122433\\\/SQL.jpg\",\"keywords\":[\"data base\",\"MySQL\"],\"articleSection\":[\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/\",\"name\":\"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB - \u0628\u0644\u0627\u06af ITPiran\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/03\\\/03122433\\\/SQL.jpg\",\"datePublished\":\"2024-03-03T09:16:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#primaryimage\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/03\\\/03122433\\\/SQL.jpg\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2024\\\/03\\\/03122433\\\/SQL.jpg\",\"width\":1793,\"height\":1110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/tutorials\\\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0622\u0645\u0648\u0632\u0634\u06cc\",\"item\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/category\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"name\":\"\u0628\u0644\u0627\u06af ITPiran\",\"description\":\"\u0627\u062e\u0628\u0627\u0631 \u0648 \u0645\u0642\u0627\u0644\u0627\u062a \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#organization\",\"name\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\",\"alternateName\":\"ITPIran Blog\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/cdn.itpiran.net\\\/2023\\\/12\\\/27150508\\\/cropped-ITPIRAN-BLOG-LOGO-2.png\",\"width\":512,\"height\":512,\"caption\":\"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646\"},\"image\":{\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/#\\\/schema\\\/person\\\/04ed27b919baca468a2273f8e4318f81\",\"name\":\"admin\",\"url\":\"https:\\\/\\\/www.itpiran.net\\\/blog\\\/de\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie man Datenbanken in MySQL oder MariaDB importiert und exportiert \u2013 ITPiran-Blog","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.itpiran.net\/blog\/de\/tutorials\/\u0646\u062d\u0648\u0647-\u0648\u0627\u0631\u062f-\u06a9\u0631\u062f\u0646-\u0648-\u0635\u0627\u062f\u0631-\u06a9\u0631\u062f\u0646-\u067e\u0627\u06cc\u06af\u0627\u0647-\u0647\u0627\u06cc-\u062f\u0627\/","og_locale":"de_DE","og_type":"article","og_title":"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB - \u0628\u0644\u0627\u06af ITPiran","og_description":"\u0645\u0642\u062f\u0645\u0647: \u0648\u0627\u0631\u062f\u0627\u062a \u0648 \u0635\u0627\u062f\u0631\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u06cc\u06a9 \u06a9\u0627\u0631 \u0631\u0627\u06cc\u062c \u062f\u0631 \u062a\u0648\u0633\u0639\u0647 \u0646\u0631\u0645 \u0627\u0641\u0632\u0627\u0631 \u0627\u0633\u062a. \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc dump&hellip;","og_url":"https:\/\/www.itpiran.net\/blog\/de\/tutorials\/\u0646\u062d\u0648\u0647-\u0648\u0627\u0631\u062f-\u06a9\u0631\u062f\u0646-\u0648-\u0635\u0627\u062f\u0631-\u06a9\u0631\u062f\u0646-\u067e\u0627\u06cc\u06af\u0627\u0647-\u0647\u0627\u06cc-\u062f\u0627\/","og_site_name":"\u0628\u0644\u0627\u06af ITPiran","article_published_time":"2024-03-03T09:16:57+00:00","og_image":[{"width":1793,"height":1110,"url":"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"admin","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#article","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/"},"author":{"name":"admin","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81"},"headline":"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB","datePublished":"2024-03-03T09:16:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/"},"wordCount":34,"commentCount":0,"publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg","keywords":["data base","MySQL"],"articleSection":["\u0622\u0645\u0648\u0632\u0634\u06cc","\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/","url":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/","name":"Wie man Datenbanken in MySQL oder MariaDB importiert und exportiert \u2013 ITPiran-Blog","isPartOf":{"@id":"https:\/\/www.itpiran.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#primaryimage"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg","datePublished":"2024-03-03T09:16:57+00:00","breadcrumb":{"@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#primaryimage","url":"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg","contentUrl":"https:\/\/cdn.itpiran.net\/2024\/03\/03122433\/SQL.jpg","width":1793,"height":1110},{"@type":"BreadcrumbList","@id":"https:\/\/www.itpiran.net\/blog\/tutorials\/%d9%86%d8%ad%d9%88%d9%87-%d9%88%d8%a7%d8%b1%d8%af-%da%a9%d8%b1%d8%af%d9%86-%d9%88-%d8%b5%d8%a7%d8%af%d8%b1-%da%a9%d8%b1%d8%af%d9%86-%d9%be%d8%a7%db%8c%da%af%d8%a7%d9%87-%d9%87%d8%a7%db%8c-%d8%af%d8%a7\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.itpiran.net\/blog\/"},{"@type":"ListItem","position":2,"name":"\u0622\u0645\u0648\u0632\u0634\u06cc","item":"https:\/\/www.itpiran.net\/blog\/category\/tutorials\/"},{"@type":"ListItem","position":3,"name":"\u0646\u062d\u0648\u0647 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0646 \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0631\u062f\u0646 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u062f\u0631 MySQL \u06cc\u0627 MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.itpiran.net\/blog\/#website","url":"https:\/\/www.itpiran.net\/blog\/","name":"ITPiran Blog","description":"Iranische Nachrichten und Artikel zum Thema nachhaltiger Handel","publisher":{"@id":"https:\/\/www.itpiran.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.itpiran.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"Nachhaltiger iranischer Unternehmensblog","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","contentUrl":"https:\/\/cdn.itpiran.net\/2023\/12\/27150508\/cropped-ITPIRAN-BLOG-LOGO-2.png","width":512,"height":512,"caption":"\u0628\u0644\u0627\u06af \u062a\u062c\u0627\u0631\u062a \u067e\u0627\u06cc\u062f\u0627\u0631 \u0627\u06cc\u0631\u0627\u0646\u06cc\u0627\u0646"},"image":{"@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.itpiran.net\/blog\/#\/schema\/person\/04ed27b919baca468a2273f8e4318f81","name":"Administrator","url":"https:\/\/www.itpiran.net\/blog\/de\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/posts\/14890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/comments?post=14890"}],"version-history":[{"count":2,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/posts\/14890\/revisions"}],"predecessor-version":[{"id":14893,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/posts\/14890\/revisions\/14893"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/media\/14892"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/media?parent=14890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/categories?post=14890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/de\/wp-json\/wp\/v2\/tags?post=14890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}