phpMyAdmin is an open-source software tool written in PHP, created to manage tables and data within a database. phpMyAdmin supports various operations on MariaDB and MySQL. The main goal of phpMyAdmin is to manage MySQL administration via the web.
Table of Contents
Import a database
Before proceeding with the database import, you must first have a database already created. If not, you can create one by following this guide.
Once the database is created, follow these steps:
In the Databases section, click on phpMyAdmin.
On the next page, click on the database you created and where you want to import the data, then click on Import.
Choose the “.sql” file to import, then click on Go.
Export my database
Log in to your cPanel account
In the Databases section, click on phpMyAdmin.
Once in phpMyAdmin, click on the database you want to export.
On the export page, you need to select either a quick or custom export method.
Choosing the ‘Quick’ method allows you to download the .sql file immediately. The “Custom” method gives you more control over the data. Only use the ‘Custom’ method if you are very familiar with managing SQL tables.
In the dropdown menu, choose the format in which you want to save the file. SQL is the most common.
Click the Go button.
A pop-up window will appear allowing you to download the file. (Note: your browser may also download it automatically.)