{"id":1408,"date":"2022-01-18T22:14:56","date_gmt":"2022-01-18T16:44:56","guid":{"rendered":"https:\/\/myfreeonlinetools.com\/blog\/?p=1408"},"modified":"2022-01-18T22:15:34","modified_gmt":"2022-01-18T16:45:34","slug":"create-import-and-export-database-in-mysql-or-mariadb-by-putty","status":"publish","type":"post","link":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/","title":{"rendered":"Create, Import and Export Database in MySQL or MariaDB by Putty"},"content":{"rendered":"<h2>How to import, export, and create a database in MySQL or MariaDB<\/h2>\n<h3>Create a new database in MySQL or MariaDB<\/h3>\n<p>First login to MySQL shell or MariaDB in putty using the below command.<\/p>\n<pre>mysql -u root -p<\/pre>\n<h4>Create new database<\/h4>\n<pre>mysql&gt; create database new_website;<\/pre>\n<h4>Check your database create or not use<\/h4>\n<pre>mysql&gt; show databases;<\/pre>\n<p>List of all databases will show in tables format.<\/p>\n<p>&nbsp;<\/p>\n<h3>Export MySQL or MariaDB database<\/h3>\n<pre>mysqldump -u username -p database_name &gt; data-dump.sql;<\/pre>\n<p>for example<\/p>\n<pre>mysqldump -u root -p new_website &gt; ~\/backup-database.sql;<\/pre>\n<p>~\/ its use for export SQL file in root directory.<\/p>\n<p>&nbsp;<\/p>\n<h3>Import MySQL or MariaDB database<\/h3>\n<h4>Create new database<\/h4>\n<pre>mysql&gt; create database new_website;<\/pre>\n<h4>import your database.sql file database into newly create database<\/h4>\n<pre>mysql -u [username] -p newdatabase &lt; [database name].sql<\/pre>\n<pre>mysql -u root -p new_website &lt; ~\/backup-database.sql;<\/pre>\n<h4>SQL script for import SQL file for import SQL data into database<\/h4>\n<pre>mysql&gt; use db_name;\r\nmysql&gt; source ~\/file_name.sql;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>How to import, export, and create a database in MySQL or MariaDB Create a new database in MySQL or MariaDB First login to MySQL shell or MariaDB in putty using [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[46,45],"tags":[],"class_list":["post-1408","post","type-post","status-publish","format-standard","hentry","category-mysql","category-ssh-commands"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools<\/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:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools\" \/>\n<meta property=\"og:description\" content=\"How to import, export, and create a database in MySQL or MariaDB Create a new database in MySQL or MariaDB First login to MySQL shell or MariaDB in putty using [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\" \/>\n<meta property=\"og:site_name\" content=\"MyFreeOnlineTools\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-18T16:44:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-18T16:45:34+00:00\" \/>\n<meta name=\"author\" content=\"myfreeonlinetools\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"myfreeonlinetools\" \/>\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:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\"},\"author\":{\"name\":\"myfreeonlinetools\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\"},\"headline\":\"Create, Import and Export Database in MySQL or MariaDB by Putty\",\"datePublished\":\"2022-01-18T16:44:56+00:00\",\"dateModified\":\"2022-01-18T16:45:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\"},\"wordCount\":111,\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"articleSection\":[\"MySQL\",\"SSH Commands\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\",\"name\":\"Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools\",\"isPartOf\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\"},\"datePublished\":\"2022-01-18T16:44:56+00:00\",\"dateModified\":\"2022-01-18T16:45:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/myfreeonlinetools.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create, Import and Export Database in MySQL or MariaDB by Putty\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#website\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"name\":\"MyFreeOnlineTools\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#organization\",\"name\":\"MyFreeOnlineTools\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"contentUrl\":\"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png\",\"width\":387,\"height\":79,\"caption\":\"MyFreeOnlineTools\"},\"image\":{\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c\",\"name\":\"myfreeonlinetools\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g\",\"caption\":\"myfreeonlinetools\"},\"description\":\"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.\",\"sameAs\":[\"https:\/\/myfreeonlinetools.com\/\",\"https:\/\/www.facebook.com\/LearnSchoolOnline\/\",\"https:\/\/www.youtube.com\/learnschoolonline\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools","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:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/","og_locale":"en_US","og_type":"article","og_title":"Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools","og_description":"How to import, export, and create a database in MySQL or MariaDB Create a new database in MySQL or MariaDB First login to MySQL shell or MariaDB in putty using [&hellip;]","og_url":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/","og_site_name":"MyFreeOnlineTools","article_author":"https:\/\/www.facebook.com\/LearnSchoolOnline\/","article_published_time":"2022-01-18T16:44:56+00:00","article_modified_time":"2022-01-18T16:45:34+00:00","author":"myfreeonlinetools","twitter_card":"summary_large_image","twitter_misc":{"Written by":"myfreeonlinetools","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#article","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/"},"author":{"name":"myfreeonlinetools","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c"},"headline":"Create, Import and Export Database in MySQL or MariaDB by Putty","datePublished":"2022-01-18T16:44:56+00:00","dateModified":"2022-01-18T16:45:34+00:00","mainEntityOfPage":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/"},"wordCount":111,"publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"articleSection":["MySQL","SSH Commands"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/","url":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/","name":"Create, Import and Export Database in MySQL or MariaDB by Putty - MyFreeOnlineTools","isPartOf":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#website"},"datePublished":"2022-01-18T16:44:56+00:00","dateModified":"2022-01-18T16:45:34+00:00","breadcrumb":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/myfreeonlinetools.com\/blog\/create-import-and-export-database-in-mysql-or-mariadb-by-putty\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/myfreeonlinetools.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Create, Import and Export Database in MySQL or MariaDB by Putty"}]},{"@type":"WebSite","@id":"https:\/\/myfreeonlinetools.com\/blog\/#website","url":"https:\/\/myfreeonlinetools.com\/blog\/","name":"MyFreeOnlineTools","description":"","publisher":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/myfreeonlinetools.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/myfreeonlinetools.com\/blog\/#organization","name":"MyFreeOnlineTools","url":"https:\/\/myfreeonlinetools.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","contentUrl":"https:\/\/myfreeonlinetools.com\/blog\/wp-content\/uploads\/2019\/11\/myfreeonlinetools-blue.png","width":387,"height":79,"caption":"MyFreeOnlineTools"},"image":{"@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/b1eb72e57c554e3b33cfeec477efcc3c","name":"myfreeonlinetools","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/myfreeonlinetools.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b870b17c6c7e3b75d7fe0b8bebfc9cf5?s=96&d=mm&r=g","caption":"myfreeonlinetools"},"description":"Live in Delhi, Working in Gurgaon as Web Designer and Graphic Designer. Developed and Design myfreeonlinetools for online free tools. Also having youtube channel Name with LearnSchoolOnline. Traveling, watching movies, coding are the hobbies.","sameAs":["https:\/\/myfreeonlinetools.com\/","https:\/\/www.facebook.com\/LearnSchoolOnline\/","https:\/\/www.youtube.com\/learnschoolonline"]}]}},"_links":{"self":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/comments?post=1408"}],"version-history":[{"count":0,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/posts\/1408\/revisions"}],"wp:attachment":[{"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/media?parent=1408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/categories?post=1408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myfreeonlinetools.com\/blog\/wp-json\/wp\/v2\/tags?post=1408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}