{"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\/en\/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":"How to import and export databases in MySQL or MariaDB"},"content":{"rendered":"<h2 id=\"%d9%85%d9%82%d8%af%d9%85%d9%87\">Introduction:<\/h2>\n<p>Importing and exporting databases is a common task in software development. You can use dump data to back up and restore your data. You can also use it to migrate data to a new server or development environment.<\/p>\n<p>In this tutorial, you will work with database dumps in MySQL or MariaDB (the commands are interchangeable). Specifically, you will export a database and then import that database from the dump file.<\/p>\n<h5 id=\"%d9%be%db%8c%d8%b4-%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\">Prerequisites<\/h5>\n<ul>\n<li>A virtual machine with a non-root sudo user<\/li>\n<li>MySQL or MariaDB installed<\/li>\n<li>A sample database created on your database server<\/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\">Step 1 \u2013 Export a MySQL or MariaDB Database<\/h2>\n<p>Console tools <code>mysqldump<\/code> Exports databases to SQL text files. This makes it easier to migrate and move databases. You will need the name of your database and credentials for an account whose privileges give at least full read-only access to the database.<\/p>\n<p>From <code>mysqldump<\/code> To export your database, use:<\/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>Username<\/code>: is the username with which you can log in to the database<\/li>\n<li><code>database_name<\/code> The name of the database to export is<\/li>\n<li><code>data-dump.sql<\/code> A file in the current directory that stores the output.<\/li>\n<\/ul>\n<p>This command does not produce any visual output, but you can view the contents <code>data-dump.sql<\/code> Check to see if it is a legitimate SQL dump file.<\/p>\n<p>Run the following command:<\/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>The top of the file should look something like this, and it will contain a MySQL wrapper for a database called <code>database_name<\/code> It shows.<\/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>If an error occurs during the export process, <code>mysqldump<\/code> It prints them on the screen.<\/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\">Step 2 \u2013 Import a MySQL or MariaDB database<\/h2>\n<p>To import an existing dump file into MySQL or MariaDB, you need to create a new database. This will hold the imported databases.<\/p>\n<p>First, log in to MySQL as root or another user with sufficient privileges to create a new database:<\/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>This command will take you to the MySQL shell prompt. Then create a new database with the following command. In this example, the new database <code>new_database<\/code> It is called:<\/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>You will see this output confirming the database creation.<\/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>Then by pressing <code>CTRL+D<\/code> Exit the MySQL shell. From the regular command line, you can import the dump file with the following command:<\/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>USERNAME<\/code> This is the username with which you can log in to the database.<\/li>\n<li><code>newdatabase<\/code> The name of the newly created database<\/li>\n<li><code>data-dump.sql<\/code> The dump file is the data to be imported and is located in the current directory.<\/li>\n<\/ul>\n<p>If the command is executed successfully, it will not produce any output. If an error occurs during the process, <code>mysql<\/code> It prints them to the terminal. To verify that the import was successful, log in to the MySQL shell and check the data. Selecting the new database with USE <code>new_database<\/code> and then use <code>SHOW TABLES.<\/code> Or a similar command to view some data.<\/p>\n<h2 id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\">Result<\/h2>\n<p>In this tutorial, you created a database from a MySQL or MariaDB database. Then you imported that data into a new database. mysqldump has additional settings that you can use to change how the system creates the data dump. You can learn more from the official mysqldump documentation page.<\/p>","protected":false},"excerpt":{"rendered":"Introduction: Importing and exporting databases is a common task in software development. You can use dump data\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\/en\/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=\"en_US\" \/>\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\/en\/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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\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\":\"en-US\",\"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\":\"en-US\",\"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\":\"en-US\",\"@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\":\"en-US\"},{\"@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\":\"en-US\",\"@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\\\/en\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import and Export Databases in MySQL or MariaDB - 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\/en\/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":"en_US","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\/en\/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":{"Written by":"admin","Est. reading time":"1 minute"},"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":"en-US","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":"How to Import and Export Databases in MySQL or MariaDB - 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":"en-US","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":"en-US","@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":"Iranian Sustainable Trade News and Articles","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":"en-US"},{"@type":"Organization","@id":"https:\/\/www.itpiran.net\/blog\/#organization","name":"Sustainable Iranian Business Blog","alternateName":"ITPIran Blog","url":"https:\/\/www.itpiran.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@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\/en\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/comments?post=14890"}],"version-history":[{"count":2,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14890\/revisions"}],"predecessor-version":[{"id":14893,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/posts\/14890\/revisions\/14893"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media\/14892"}],"wp:attachment":[{"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/media?parent=14890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/categories?post=14890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itpiran.net\/blog\/en\/wp-json\/wp\/v2\/tags?post=14890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}