How to Import a Database using PHPMyAdmin
This needs to be done before you import data. If you have used Softaculous to install a CMS like WordPress or Joomla, the database would have been created as part of the installation process.
Step 1 – Log into cPanel
Step 2 – Click on phpMyAdmin
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-27.png)
Step 3 – Select the correct database from the left panel
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-28.png)
Step 4 – Click the Import button
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-29.png)
Step 5 – Select the database you wish to upload
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-30.png)
6 – Click Go!
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-31.png)
How to Export a Database using PHPMyAdmin
Step 1 – Log in to cPanel
Step 2 – Click on the PHPMyAdmin icon
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-32.png)
Step 3 – Select the Database or the table you wish to export
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-33.png)
Step 4 – Click on the Export option up the top
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-34.png)
Step 5 – Click Go
![](https://kb.buzinessware.com/wp-content/uploads/2018/12/image-35.png)
NOTE: You can use the Custom option to change a whole host of settings relating to how the database will be output. However, for 99% of cases, this won’t be required. You can also use the Format: option if you want the file to be output as a LaTeX, CSV, PDF or anything else other than the standard SQL format. Again, for most cases, this won’t ever be required.