{"id":597,"date":"2018-06-27T04:30:10","date_gmt":"2018-06-27T09:30:10","guid":{"rendered":"https:\/\/linuxhostsupport.com\/blog\/?p=597"},"modified":"2018-06-29T04:23:42","modified_gmt":"2018-06-29T09:23:42","slug":"how-to-import-an-sql-file-into-mysql-database","status":"publish","type":"post","link":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/","title":{"rendered":"How to Import an SQL File Into MySQL Database"},"content":{"rendered":"<div id=\"linux-1317534813\" class=\"linux-before-1st-paragraph linux-entity-placement\" style=\"margin-top: 15px;margin-bottom: 15px;\"><a href=\"https:\/\/www.rosehosting.com\/managed-vps-hosting\/?mtm_campaign=blogs&#038;mtm_source=lhs&#038;mtm_medium=blog&#038;mtm_content=managed-vps&#038;mtm_cid=1339&#038;mtm_placement=inline\" aria-label=\"Untitled\"><img src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322.jpg\" alt=\"\"  srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322.jpg 728w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340090_NVMeGoogleAds_728x90_041322-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" width=\"728\" height=\"90\"  style=\"display: inline-block;\" \/><\/a><\/div><p>MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of the LAMP (Linux, Apache, MySQL and PHP) open-source web application stack. In this tutorial, we will show you how to import an SQL file into MySQL database on a Linux VPS. This will help you when you need to transfer your database from one server to another or to restore a database backup.<\/p>\n<p><!--more--><\/p>\n<p>Before we start, make sure that you have full root access to your Linux server, or at least you have a system user with sudo privileges which you can use to connect to your server. Once you connect to your server via SSH run the following command to check if the MySQL database server is installed and which version it is:<\/p>\n<pre>mysql -V<\/pre>\n<p>Depending on which version you have installed, the output should be similar to this:<\/p>\n<pre>mysql Ver 14.14 Distrib 5.7.22, for Linux (x86_64) using EditLine wrapper<\/pre>\n<p>If you need to connect to the MySQL database server through the command line as user root run the following command:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>MySQL will ask you to enter the password for the MySQL root user. In case you don&#8217;t have a password set up for the MySQL root user, you can connect with the following command instead:<\/p>\n<pre>mysql -u root<\/pre>\n<p>Of course, it is always recommended to keep your services secure, so if you haven\u2019t set up the\u00a0MySQL root password yet, you can do that now using the <strong>mysql_secure_installation<\/strong> command:<\/p>\n<pre>mysql_secure_installation<\/pre>\n<p>Then, follow the on-screen instructions to finish the setup:<\/p>\n<pre>Would you like to setup VALIDATE PASSWORD plugin?\r\nPress y|Y for Yes, any other key for No: y\r\n\r\nPlease set the password for root here.\r\nNew password:\r\n\r\nDo you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y\r\n\r\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\r\n\r\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\r\n\r\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\r\n\r\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\r\n\r\nAll done!<\/pre>\n<p>That&#8217;s it, you can now connect to the MySQL database server as the MySQL root user using your new password.<\/p>\n<h2>Import an SQL file into MySQL database<\/h2>\n<p>We will now show you how to import an SQL file into an existing MySQL database.<\/p>\n<p>To list all existing databases in your MySQL database server, first connect to your database server with:<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>and then run the following command:<\/p>\n<pre>mysql&gt; show databases;<\/pre>\n<p>This will list all databases created in MySQL, giving you an output similar to this:<\/p>\n<pre>mysql&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| mysql              |\r\n| performance_schema |\r\n| sys                |\r\n+--------------------+\r\n4 rows in set (0.00 sec)<\/pre>\n<p>If you want to create a new database for the SQL file, you can do it with the following command:<\/p>\n<pre>mysql&gt; CREATE DATABASE DatabaseName;<\/pre>\n<p>To create a MySQL user and assign a new password to it, run the following command:<\/p>\n<pre>mysql&gt; CREATE USER 'DatabaseUser'@'localhost' IDENTIFIED BY 'password';<\/pre>\n<p>To give the new or existing user access to the new databases, run the following:<\/p>\n<pre>mysql&gt; GRANT ALL ON DatabaseName.* TO 'DatabaseUser'@\"localhost\";<\/pre>\n<p>Lastly, reload all the privileges with:<\/p>\n<pre>mysql&gt; FLUSH PRIVILEGES;<\/pre>\n<p>and exit the MySQL server with:<\/p>\n<pre>mysql&gt; exit;<\/pre>\n<p>Your database is now ready, and we can now import the SQL file.<\/p>\n<p>To import the SQL file, for example, BackupDatabase.sql, into your new database, simply run the following command:<\/p>\n<pre>mysql -u DatabaseUser -p DatabaseName &lt; BackupDatabase.sql<\/pre>\n<p>You will be asked for the password of the database user to which the database is assigned. Enter your database user password to finish the import.<\/p>\n<p>With this, the BackupDatabase.sql file has been successfully imported.<\/p>\n<h2>Export a MySQL database into SQLfile<\/h2>\n<p>Additionally, we will also show you how to easily export an existing MySQL database into a SQL file. This can be done with the\u00a0<strong>mysqldump<\/strong> command. For example:<\/p>\n<pre>mysqldump -u DatabaseUser -p DatabaseName &gt; BackupDatabase.sql<\/pre>\n<p>Again, you will be asked for the database user password, and it will create an SQL file of your database which you can store it as a backup, and import it later if needed.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-599\" src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/Import-SQL-File-Into-MySQL-Database.jpg\" alt=\" Import SQL File Into MySQL Database\" width=\"90\" height=\"101\" \/>Of course, you don\u2019t have to import your SQL files in MySQL,\u00a0 if you are using one of our <a href=\"https:\/\/linuxhostsupport.com\">outsourced Linux server management services<\/a>, in which case you can simply ask our expert Linux admins to help you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p>PS. If you liked this post on how to Import an SQL file into MySQL Database, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks<\/p><div id=\"linux-2328790990\" class=\"linux-after-8th-paragraph linux-entity-placement\" style=\"margin-top: 15px;margin-bottom: 15px;\"><a href=\"https:\/\/www.rosehosting.com\/managed-vps-hosting\/?mtm_campaign=blogs&#038;mtm_source=lhs&#038;mtm_medium=blog&#038;mtm_content=managed-vps&#038;mtm_cid=1340&#038;mtm_placement=inline\" aria-label=\"Untitled\"><img src=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622.jpg\" alt=\"\"  srcset=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622.jpg 728w, https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2020\/12\/1340095_VPSGoogleAds_728x90_042622-300x37.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" width=\"728\" height=\"90\"  style=\"display: inline-block;\" \/><\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of the LAMP (Linux, Apache, MySQL and PHP) open-source web application stack. In this tutorial, we will show you how to import an SQL file into MySQL database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":602,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[107,77],"class_list":["post-597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-import","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Import an SQL File Into MySQL Database | LinuxHostSupport<\/title>\n<meta name=\"description\" content=\"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import an SQL File Into MySQL Database | LinuxHostSupport\" \/>\n<meta property=\"og:description\" content=\"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of\" \/>\n<meta property=\"og:url\" content=\"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"LinuxHostSupport\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/linuxhostsupport\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-27T09:30:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-06-29T09:23:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"410\" \/>\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:creator\" content=\"@lnxhostsupport\" \/>\n<meta name=\"twitter:site\" content=\"@lnxhostsupport\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\"},\"headline\":\"How to Import an SQL File Into MySQL Database\",\"datePublished\":\"2018-06-27T09:30:10+00:00\",\"dateModified\":\"2018-06-29T09:23:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/\"},\"wordCount\":634,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/How-to-Import-an-SQL-File-into-MySQL-database.jpg\",\"keywords\":[\"import\",\"mysql\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/\",\"name\":\"How to Import an SQL File Into MySQL Database | LinuxHostSupport\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/How-to-Import-an-SQL-File-into-MySQL-database.jpg\",\"datePublished\":\"2018-06-27T09:30:10+00:00\",\"dateModified\":\"2018-06-29T09:23:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\"},\"description\":\"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/How-to-Import-an-SQL-File-into-MySQL-database.jpg\",\"contentUrl\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/How-to-Import-an-SQL-File-into-MySQL-database.jpg\",\"width\":750,\"height\":410,\"caption\":\"How to Import an SQL File into MySQL database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/how-to-import-an-sql-file-into-mysql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import an SQL File Into MySQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/\",\"name\":\"LinuxHostSupport\",\"description\":\"Linux Tutorials and Guides\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/#\\\/schema\\\/person\\\/53a9571ea078cdf350137a1e97423cfb\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/linuxhostsupport.com\\\/blog\\\/author\\\/r0s3admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import an SQL File Into MySQL Database | LinuxHostSupport","description":"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of","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:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Import an SQL File Into MySQL Database | LinuxHostSupport","og_description":"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of","og_url":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/","og_site_name":"LinuxHostSupport","article_publisher":"https:\/\/www.facebook.com\/linuxhostsupport","article_published_time":"2018-06-27T09:30:10+00:00","article_modified_time":"2018-06-29T09:23:42+00:00","og_image":[{"width":750,"height":410,"url":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@lnxhostsupport","twitter_site":"@lnxhostsupport","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#article","isPartOf":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/"},"author":{"name":"admin","@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb"},"headline":"How to Import an SQL File Into MySQL Database","datePublished":"2018-06-27T09:30:10+00:00","dateModified":"2018-06-29T09:23:42+00:00","mainEntityOfPage":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/"},"wordCount":634,"commentCount":1,"image":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg","keywords":["import","mysql"],"articleSection":["Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/","url":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/","name":"How to Import an SQL File Into MySQL Database | LinuxHostSupport","isPartOf":{"@id":"https:\/\/linuxhostsupport.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg","datePublished":"2018-06-27T09:30:10+00:00","dateModified":"2018-06-29T09:23:42+00:00","author":{"@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb"},"description":"MySQL is one of the most popular database management systems. It is most often used for web-based application and it is also one of the main components of","breadcrumb":{"@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#primaryimage","url":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg","contentUrl":"https:\/\/linuxhostsupport.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Import-an-SQL-File-into-MySQL-database.jpg","width":750,"height":410,"caption":"How to Import an SQL File into MySQL database"},{"@type":"BreadcrumbList","@id":"https:\/\/linuxhostsupport.com\/blog\/how-to-import-an-sql-file-into-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/linuxhostsupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Import an SQL File Into MySQL Database"}]},{"@type":"WebSite","@id":"https:\/\/linuxhostsupport.com\/blog\/#website","url":"https:\/\/linuxhostsupport.com\/blog\/","name":"LinuxHostSupport","description":"Linux Tutorials and Guides","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/linuxhostsupport.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/linuxhostsupport.com\/blog\/#\/schema\/person\/53a9571ea078cdf350137a1e97423cfb","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed83c63a34114218f977e1f913be03906d17c7d9c800788fcac345f5edaf6cfa?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/linuxhostsupport.com\/blog\/author\/r0s3admin\/"}]}},"_links":{"self":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/comments?post=597"}],"version-history":[{"count":2,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"predecessor-version":[{"id":601,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/posts\/597\/revisions\/601"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/media\/602"}],"wp:attachment":[{"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/categories?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostsupport.com\/blog\/wp-json\/wp\/v2\/tags?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}