--- title: 'In this article, we will look at how to use phpMyAdmin | Zomro' description: 'How to access phpMyAdmin from: ISPmanager, cPanel, VestaCP, HestiaCP? How to import and export databases in phpMyAdmin?' image: 'https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712195946-2.jpg' --- ![opened image]() * [Zomro](https://zomro.com/) * [FAQ](https://zomro.com/blog/faq/) * How to get into phpMyAdmin from popular server control panels # How to get into phpMyAdmin from popular server control panels 12-07-2023 **Using phpMyAdmin when importing and exporting databases.** **Introduction**. phpMyAdmin is one of the most widely used MySQL database management tools. It provides a web interface that allows system administrators or general users to easily import and export data from databases. In this article, we'll look at how to use phpMyAdmin to perform these tasks on various control panels such as ISPmanager, cPanel, VestaCP, and HestiaCP. ## **Go to phpMyAdmin in different panels** Below are examples of using phpMyAdmin to import/export databases on various control panels: **1\. ISPmanager:** Log in to the ISPmanager 6 control panel. On the main page, click phpMyAdmin. ![How to get into phpMyAdmin from popular server control panels - 1](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712195946-2.jpg) In ISPmanager 5 and find the "Databases" section on the left. Then select the desired database and click on the "phpMyAdmin" or "Database Web Interface" button. ![How to get into phpMyAdmin from popular server control panels - 2](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712200537-3.jpg) **2\. cPanel:** After logging into cPanel, scroll down to the "Databases" section and look for the "phpMyAdmin" icon. Click on it to open phpMyAdmin. ![How to get into phpMyAdmin from popular server control panels - 3](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712201202-4.jpg) **3\. VestaCP:** Log in to the VestaCP control panel and find the "Databases" section. In this section, select the desired database and click on the "phpMyAdmin" link. ![How to get into phpMyAdmin from popular server control panels - 4](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712201442-5.jpg) **4\. HestiaCP:** After logging in to HestiaCP, log in as a user with a database, find the "Databases" section and select the desired database. Clicking on the "phpMyAdmin" button next to the selected database redirects to the page with http://IP/phpmyadmin, but the page at this link in the HestiaCP panel is blocked and unavailable: "Page Not Found". You need to go manually through your domain: http://you.domain.com/phpmyadmin/ ![How to get into phpMyAdmin from popular server control panels - 5](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712202057-6.jpg) ## **Importing databases in phpMyAdmin** Importing databases is the process of restoring a database backup in .sql or .zip format to your system. To log into phpMyAdmin, you must specify the database username and password for this user. ![How to get into phpMyAdmin from popular server control panels - 6](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712192625-1.jpg) In phpMyAdmin, select the database and go to the "Import" tab. Click on the "Browse" button and select the database backup file, then click "Run". ![How to get into phpMyAdmin from popular server control panels - 7](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712203557-8.jpg) ## **Database export in phpMyAdmin** Export databases allows you to create database backups in .sql or .zip format for later restoration. Follow the same steps for your control panel from the previous paragraphs to login to phpMyAdmin. ![How to get into phpMyAdmin from popular server control panels - 8](https://dx86q6oq7ry0e.cloudfront.net/uploads/media/blog/vitaliy.darmoroz%40zomro.org/2023/07/12/image-20230712203449-7.jpg) In phpMyAdmin select on the left the desired database you want to export and on the right above go to the "Export" tab. Select the desired export options and click on the "Run" button. **Results** phpMyAdmin is a powerful tool for importing and exporting MySQL databases. Regardless of the control panel you use, you can easily restore database backups or create them for transfer to another server. Using phpMyAdmin greatly simplifies the database management process and allows administrators to work efficiently with data. If the process was not completed completely during import-export via phpMyAdmin and/or an error occurred, it may have been stopped due to large database timeouts. In this case, import-export of large databases (from 1 GB and more) is recommended to be performed through the console. It is important to remember that data security is a priority. Make sure your database backups are stored securely on an optional external FTP storage and are only accessible by authorized individuals. It is also recommended that you back up your databases regularly to minimize potential data loss. Take advantage of the power of phpMyAdmin in your control panel and simplify the process of importing and exporting your project databases. Similar articles: [Connecting to a Server via SSH](https://zomro.com/blog/faq/142-podkljuchenie-k-serveru-po-ssh) [Create MySQL/MariaDB database in Hestia panel](https://zomro.com/blog/faq/223-sozdanie-bazy-dannyh-v-paneli-hestia) [How to view Centos 7 server logs](https://zomro.com/blog/faq/350-how-to-view-centos-7-server-logs) [How to connect custom ISO image to dedicated server](https://zomro.com/blog/faq/234-kak-podkljuchit-svoj-obraz-iso-k-vydelennomu-serveru) [WordPress Multisite: How to create and manage multiple sites from one admin panel](https://zomro.com/blog/faq/322-wordpress-multisite-how-to-create-and-manage-multiple-sites-from-one-admin-panel) [ Dedicated servers from €88.80/mon ](/dedicated-servers)