phpMyAdmin<\/strong> is a free software tool written in PHP<\/strong>, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.<\/p>\n here are some of the most features may it useful for MySQL Administrators:<\/p>\n In cPanel you can import and export databases using the phpMyAdmin<\/strong> menu which you can find in the Databases<\/strong> section. Database import<\/p>\n <\/strong>The main purpose of using database import function is to restore mySQL database<\/strong> using phpMyAdmin , you can import mySQL database by following the next steps: Database export<\/strong><\/p>\n The main purpose of using database export function is to backup mySQL database<\/strong> using phpMyAdmin , you can export mySQL database by following the next steps:<\/p>\n 1. Log into your cPanel<\/strong> And you are Done!.<\/p>\n","protected":false},"excerpt":{"rendered":" What is phpMyAdmin phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still […]<\/p>\n","protected":false},"author":2,"featured_media":50,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[25],"tags":[178,26,27,74],"_links":{"self":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/334"}],"collection":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/comments?post=334"}],"version-history":[{"count":3,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/334\/revisions"}],"predecessor-version":[{"id":337,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/posts\/334\/revisions\/337"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/media\/50"}],"wp:attachment":[{"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/media?parent=334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/categories?post=334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xsofthost.com\/help\/wp-json\/wp\/v2\/tags?post=334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}What is phpMyAdmin Features<\/h2>\n
\n
Import\/Export MySQL in phpMyAdmin<\/h2>\n
\n Note :<\/strong> MySQL databases default option of 50MB maximum<\/strong> can be imported\/exported in phpMyAdmin<\/strong>.
\n Larger databases have to be imported\/exported via SSH.<\/p>\n
\n
\n <\/strong>1. Log into your cPanel
\n 2. Navigate to the phpMyAdmin menu
\n 3. Select the database<\/strong> that you will need import to
\n 4. In the upper bar, click the tab Import<\/strong>
\n 5. Click Browse<\/strong> and locate the .sql file from your computer. Once done, click Go
\n <\/strong>6. And you will see a notification that your database was successfully imported”<\/p>\n
\n 2. Navigate to Navigate to phpMyAdmin<\/strong> menu
\n 3. Select the database<\/strong> that you will need import to
\n 4. Choose the tables that you need to export or click Check All<\/strong>. Click Export<\/strong> to proceed
\n 5. Select the required file from the drop-down menu in Format<\/strong> and click the Go<\/strong> button<\/p>\n