{"id":5605,"date":"2021-06-24T09:09:00","date_gmt":"2021-06-24T09:09:00","guid":{"rendered":"https:\/\/www.magetop.com\/blog\/?p=5605"},"modified":"2021-07-22T13:16:45","modified_gmt":"2021-07-22T13:16:45","slug":"import-and-export-database-in-mysql-or-mariadb","status":"publish","type":"post","link":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","title":{"rendered":"How To Import And Export Database In MySQL Or MariaDB"},"content":{"rendered":"\n<p>In this post, I will guide you on&nbsp;<strong>How To Import And Export Database In MySQL Or MariaDB<\/strong>. Use data dumps to back up and restore your information.<\/p>\n\n\n\n<p>You can use import and export database to backup and restore your data. In addition, you can also use them to migrate data to a new server or development environment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>MySQL or MariaDB installed.<\/li><li>A database created in your database server.<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Export Database<\/h2>\n\n\n\n<p>You will need your database name and credentials. We will use&nbsp;<code>mysqldump<\/code>&nbsp;to export the database:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysqldump -u username -p database-name &gt; data-dump.sql\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\"><li><code>username<\/code>&nbsp;is the username to log in to your database.<\/li><li><code>database_name<\/code>&nbsp;is the name of the database you want to export.<\/li><li><code>data-dump.sql<\/code>&nbsp;is the file in the current directory that stores the output.<\/li><\/ul>\n\n\n\n<p>Enter the password to continue if applicable.<\/p>\n\n\n\n<p>Inspect the contents of&nbsp;<code>data-dump.sq<\/code>l to check if it\u2019s a legitimate SQL dump file with the command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nhead -n 5 data-dump.sql\n<\/pre><\/div>\n\n\n<p>You can see output like this:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n-- MySQL dump 10.16  Distrib 10.1.44-MariaDB, for Linux (x86_64)\n--\n-- Host: localhost    Database: database-name\n-- ------------------------------------------------------\n-- Server version       10.1.44-MariaDB\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">Import Database<\/h2>\n\n\n\n<p>First, log in to MySQL as root or another user with privileges can create the database.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql -u root -p\n<\/pre><\/div>\n\n\n<p>Next, Create a new database with the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nCREATE DATABASE new_database;\n<\/pre><\/div>\n\n\n<p>Then exit the MySQL with the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nexit\n<\/pre><\/div>\n\n\n<p>Import the dump file with the following command:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nmysql -u username -p new_database &lt; data-dump.sql\n<\/pre><\/div>\n\n\n<ul class=\"wp-block-list\" id=\"block-38acd45b-855f-41cc-a2c2-19cbc2e7679d\"><li><code>username<\/code>&nbsp;is the username to log in to your database.<\/li><li><code>new_database<\/code>&nbsp;is the name of the database you want to import.<\/li><li><code>data-dump.sql<\/code>&nbsp;is the file in the current directory that stores the output.<\/li><\/ul>\n\n\n\n<p>You can log in to&nbsp;<code>mysql<\/code>, using the&nbsp;<code>USE new_database<\/code>&nbsp;and&nbsp;<code>SHOW TABLES;<\/code>&nbsp;commands respectively to check the result or use phpMyAdmin.<\/p>\n\n\n\n<p>This is the end of the&nbsp;post.<\/p>\n\n\n\n<p>Follow us for the more helpful posts!<\/p>\n\n\n\n<p>We hope this is a useful post for you&nbsp;<strong><a href=\"https:\/\/www.magetop.com\/blog\/magento-2-remove-delete-attribute-option-from-product-attribute\/\" target=\"_blank\" rel=\"noreferrer noopener\">How To Remove Delete Attribute Option From Product Attribute In Magento 2<\/a><\/strong>.<\/p>\n\n\n\n<p>Thank you for reading!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post, I will guide you on\u00a0How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore your information.<\/p>\n","protected":false},"author":106,"featured_media":6244,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[1355,1356,1353,1352,1354,1357,107],"class_list":["post-5605","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-magento-2-tutorials","tag-export-database","tag-how-to-import-and-export-database-in-mysql-or-mariadb","tag-import-and-export-database-in-mariadb","tag-import-and-export-database-in-mysql","tag-import-and-export-database-in-mysql-or-mariadb","tag-import-database","tag-magento-2-tutorials"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Import And Export Database In MySQL Or MariaDB - Magetop<\/title>\n<meta name=\"description\" content=\"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information\" \/>\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.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Import And Export Database In MySQL Or MariaDB - Magetop\" \/>\n<meta property=\"og:description\" content=\"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\" \/>\n<meta property=\"og:site_name\" content=\"Magetop Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/MagetopStore\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-24T09:09:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-22T13:16:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i2.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"948\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Aaron LX\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:site\" content=\"@MagetopStore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aaron LX\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\"},\"author\":{\"name\":\"Aaron LX\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\"},\"headline\":\"How To Import And Export Database In MySQL Or MariaDB\",\"datePublished\":\"2021-06-24T09:09:00+00:00\",\"dateModified\":\"2021-07-22T13:16:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\"},\"wordCount\":303,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1\",\"keywords\":[\"Export Database\",\"How To Import And Export Database In MySQL Or MariaDB\",\"Import And Export Database In MariaDB\",\"Import And Export Database In MySQL\",\"Import And Export Database In MySQL Or MariaDB\",\"Import Database\",\"magento 2 tutorials\"],\"articleSection\":[\"Magento 2 Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\",\"url\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\",\"name\":\"How To Import And Export Database In MySQL Or MariaDB - Magetop\",\"isPartOf\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1\",\"datePublished\":\"2021-06-24T09:09:00+00:00\",\"dateModified\":\"2021-07-22T13:16:45+00:00\",\"description\":\"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information\",\"breadcrumb\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1\",\"width\":1600,\"height\":948,\"caption\":\"How To Import And Export Database In MySQL Or MariaDB\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.magetop.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Import And Export Database In MySQL Or MariaDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#website\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"name\":\"Magetop Blog\",\"description\":\"Exploring Magento Tips, Tricks, and Trends\",\"publisher\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.magetop.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#organization\",\"name\":\"Magetop.com\",\"url\":\"https:\/\/www.magetop.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1\",\"width\":475,\"height\":475,\"caption\":\"Magetop.com\"},\"image\":{\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/MagetopStore\",\"https:\/\/x.com\/MagetopStore\",\"https:\/\/www.linkedin.com\/company\/magetop\",\"https:\/\/www.pinterest.com\/magetop\",\"https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7\",\"name\":\"Aaron LX\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1\",\"caption\":\"Aaron LX\"},\"description\":\"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.\",\"url\":\"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Import And Export Database In MySQL Or MariaDB - Magetop","description":"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information","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.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","og_locale":"en_US","og_type":"article","og_title":"How To Import And Export Database In MySQL Or MariaDB - Magetop","og_description":"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information","og_url":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","og_site_name":"Magetop Blog","article_publisher":"https:\/\/www.facebook.com\/MagetopStore","article_published_time":"2021-06-24T09:09:00+00:00","article_modified_time":"2021-07-22T13:16:45+00:00","og_image":[{"width":1600,"height":948,"url":"https:\/\/i2.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","type":"image\/png"}],"author":"Aaron LX","twitter_card":"summary_large_image","twitter_creator":"@MagetopStore","twitter_site":"@MagetopStore","twitter_misc":{"Written by":"Aaron LX","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#article","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/"},"author":{"name":"Aaron LX","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7"},"headline":"How To Import And Export Database In MySQL Or MariaDB","datePublished":"2021-06-24T09:09:00+00:00","dateModified":"2021-07-22T13:16:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/"},"wordCount":303,"commentCount":0,"publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","keywords":["Export Database","How To Import And Export Database In MySQL Or MariaDB","Import And Export Database In MariaDB","Import And Export Database In MySQL","Import And Export Database In MySQL Or MariaDB","Import Database","magento 2 tutorials"],"articleSection":["Magento 2 Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","url":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/","name":"How To Import And Export Database In MySQL Or MariaDB - Magetop","isPartOf":{"@id":"https:\/\/www.magetop.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","datePublished":"2021-06-24T09:09:00+00:00","dateModified":"2021-07-22T13:16:45+00:00","description":"In this post, I will guide you on How To Import And Export Database In MySQL Or MariaDB. Use data dumps to back up and restore information","breadcrumb":{"@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#primaryimage","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","width":1600,"height":948,"caption":"How To Import And Export Database In MySQL Or MariaDB"},{"@type":"BreadcrumbList","@id":"https:\/\/www.magetop.com\/blog\/import-and-export-database-in-mysql-or-mariadb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.magetop.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Import And Export Database In MySQL Or MariaDB"}]},{"@type":"WebSite","@id":"https:\/\/www.magetop.com\/blog\/#website","url":"https:\/\/www.magetop.com\/blog\/","name":"Magetop Blog","description":"Exploring Magento Tips, Tricks, and Trends","publisher":{"@id":"https:\/\/www.magetop.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.magetop.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.magetop.com\/blog\/#organization","name":"Magetop.com","url":"https:\/\/www.magetop.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/11\/logo.png?fit=475%2C475&ssl=1","width":475,"height":475,"caption":"Magetop.com"},"image":{"@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/MagetopStore","https:\/\/x.com\/MagetopStore","https:\/\/www.linkedin.com\/company\/magetop","https:\/\/www.pinterest.com\/magetop","https:\/\/www.youtube.com\/channel\/UCXoiJsz88OfPmwa8QpUkwOA"]},{"@type":"Person","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/b8770690a02cc53a273d6b7205229ff7","name":"Aaron LX","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.magetop.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/11\/475315059_122137709240563546_260104055231757176_n.jpg?fit=96%2C96&#038;ssl=1","caption":"Aaron LX"},"description":"Aaron is a passionate writer, crazy about shopping, eCommerce and trends. Besides his outstanding research skills and a positive mind, Aaron eagerly shares his experience with the readers.","url":"https:\/\/www.magetop.com\/blog\/author\/aaron-lx\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Import-And-Export-Database-In-MySQL-Or-MariaDB.png?fit=1600%2C948&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/paOdw5-1sp","jetpack-related-posts":[{"id":7256,"url":"https:\/\/www.magetop.com\/blog\/huong-dan-export-database-mysql\/","url_meta":{"origin":5605,"position":0},"title":"H\u01b0\u1edbng d\u1eabn Export Database Mysql, t\u1ea1o file backup Database Mysql","author":"Callula Huy","date":"August 10, 2021","format":false,"excerpt":"Trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch Export Database Mysql, c\u0169ng c\u00f3 th\u1ec3 g\u1ecdi l\u00e0 t\u1ea1o file backup Database Mysql.","rel":"","context":"In &quot;Magento 2 H\u01b0\u1edbng D\u1eabn Ti\u1ebfng Vi\u1ec7t&quot;","block_context":{"text":"Magento 2 H\u01b0\u1edbng D\u1eabn Ti\u1ebfng Vi\u1ec7t","link":"https:\/\/www.magetop.com\/blog\/vn\/"},"img":{"alt_text":"H\u01b0\u1edbng d\u1eabn Export Database Mysql","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/Huong-dan-Export-Database-Mysql.jpg?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":10049,"url":"https:\/\/www.magetop.com\/blog\/how-to-install-mariadb-on-ubuntu\/","url_meta":{"origin":5605,"position":1},"title":"How To Install MariaDB On Ubuntu","author":"Aaron LX","date":"April 3, 2025","format":false,"excerpt":"MariaDB is a popular, open-source relational database management system that is a fork of MySQL. It is highly performant, secure, and compatible with most MySQL tools. In this guide, we will walk you through How To Install MariaDB On Ubuntu step by step. Steps To Install MariaDB On Ubuntu 1.\u2026","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/04\/How-To-Install-MariaDB-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":5601,"url":"https:\/\/www.magetop.com\/blog\/change-admin-login-to-case-sensitive-in-magento-2\/","url_meta":{"origin":5605,"position":2},"title":"How To Change Admin Login To Case Sensitive In Magento 2","author":"Aaron LX","date":"June 25, 2021","format":false,"excerpt":"In this post, I will guide you on\u00a0How To Change Admin Login To Case Sensitive In Magento 2. Enhance the security of store accounts.","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Change Admin Login To Case Sensitive In Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Change-Admin-Login-To-Case-Sensitive-In-Magento-2.png?fit=1200%2C710&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Change-Admin-Login-To-Case-Sensitive-In-Magento-2.png?fit=1200%2C710&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Change-Admin-Login-To-Case-Sensitive-In-Magento-2.png?fit=1200%2C710&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Change-Admin-Login-To-Case-Sensitive-In-Magento-2.png?fit=1200%2C710&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/06\/How-To-Change-Admin-Login-To-Case-Sensitive-In-Magento-2.png?fit=1200%2C710&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":397,"url":"https:\/\/www.magetop.com\/blog\/magento-system-requirements\/","url_meta":{"origin":5605,"position":3},"title":"Magento 2.3.x System Requirements","author":"Adam Roger","date":"November 11, 2019","format":false,"excerpt":"Since Magento 2 was released with a more friendly interface,\u00a0better performance, and\u00a0more security, online store owners intend to alter store basement system to Magento 2. The question is how to take all advantages of Magento 2? This post will inform entire\u00a0Magento 2 System Requirements\u00a0for you to follow and get the\u2026","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"magento system requirements","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/11\/magento-system-requirements.png?fit=713%2C400&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/11\/magento-system-requirements.png?fit=713%2C400&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/11\/magento-system-requirements.png?fit=713%2C400&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2019\/11\/magento-system-requirements.png?fit=713%2C400&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":9819,"url":"https:\/\/www.magetop.com\/blog\/how-to-install-phpmyadmin-on-ubuntu\/","url_meta":{"origin":5605,"position":4},"title":"How To Install phpMyAdmin On Ubuntu","author":"Aaron LX","date":"February 11, 2025","format":false,"excerpt":"phpMyAdmin is a free, open-source tool used to manage MySQL and MariaDB databases through a web-based interface. Written in PHP, it allows users to perform a wide range of database operations, including creating, modifying, and deleting databases, tables, and records. Please follow the post\u00a0How To Install phpMyAdmin On Ubuntu to\u2026","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Install phpMyAdmin On Ubuntu","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2025\/02\/How-To-Install-phpMyAdmin-On-Ubuntu.png?fit=1200%2C667&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7273,"url":"https:\/\/www.magetop.com\/blog\/change-database-name-in-magento-2\/","url_meta":{"origin":5605,"position":5},"title":"How To Change Database Name In Magento 2","author":"Aaron LX","date":"August 11, 2021","format":false,"excerpt":"In this post, I will guide you on How To Change Database Name In Magento 2. The env file contains information about the database like dbname, username, and password, and you can change them to work with the MySQL server.","rel":"","context":"In &quot;Magento 2 Tutorials&quot;","block_context":{"text":"Magento 2 Tutorials","link":"https:\/\/www.magetop.com\/blog\/magento-2-tutorials\/"},"img":{"alt_text":"How To Change Database Name In Magento 2","src":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.magetop.com\/blog\/wp-content\/uploads\/2021\/08\/How-To-Change-Database-Name-In-Magento-2.png?fit=1063%2C631&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/5605","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/users\/106"}],"replies":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/comments?post=5605"}],"version-history":[{"count":2,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/5605\/revisions"}],"predecessor-version":[{"id":6245,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/posts\/5605\/revisions\/6245"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media\/6244"}],"wp:attachment":[{"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/media?parent=5605"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/categories?post=5605"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.magetop.com\/blog\/wp-json\/wp\/v2\/tags?post=5605"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}