Articles on: Databases

How to Import a Database via phpMyAdmin in cPanel

1. Log in to your cPanel account.


2. In the Databases section, click on phpMyAdmin.


phpmyadmin icon


3. From the navigation tree in the left sidebar, select an appropriate database in which you want to import data using the SQL file.


phpmyadmin expand db


4. Click on Import.


phpmyadmin import

%27%20fill-opacity%3D%27.5%27%3E%3Cellipse%20fill%3D%22%23fcfcfc%22%20fill-opacity%3D%22.5%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22rotate(-93.4%2030%20-5.5)%20scale(159.36905%2042.64621)%22%2F%3E%3Cellipse%20fill%3D%22%23bcbcbc%22%20fill-opacity%3D%22.5%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22matrix(-313.81169%208.21745%20-6.27557%20-239.65447%20395.7%2034.8)%22%2F%3E%3Cpath%20fill%3D%22%23e0e0e0%22%20fill-opacity%3D%22.5%22%20d%3D%22M-34.8%2039.3L82-16.8l-4.5%2060.6z%22%2F%3E%3Cpath%20fill%3D%22%23e6e6e6%22%20fill-opacity%3D%22.5%22%20d%3D%22M77.7-12.4l1.9%2026.9-2.3.1-1.9-26.8z%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)


5. Under File to Import, click on Browse and select SQL file from your computer.

phpmyadmin import2

%22%20transform%3D%22translate(1.2%201.2)%20scale(2.30078)%22%20fill-opacity%3D%22.5%22%3E%3Cellipse%20fill%3D%22%23cecece%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22matrix(-9.46645%2032.77325%20-84.69365%20-24.4635%2048.3%2056.7)%22%2F%3E%3Cellipse%20fill%3D%22%23fff%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22rotate(12.4%2025.9%20949.3)%20scale(194.39454%2056.78363)%22%2F%3E%3Cellipse%20fill%3D%22%23fff%22%20cx%3D%22194%22%20cy%3D%2226%22%20rx%3D%2274%22%20ry%3D%2274%22%2F%3E%3Cellipse%20fill%3D%22%23fff%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22matrix(182.34199%2033.79509%20-2.8569%2015.41444%20127.3%2018.6)%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)


6. Scroll down and click on *Go*.


If it shows a success message, your SQL has been successfully uploaded.

phpmyadmin successfully

%27%20fill-opacity%3D%27.5%27%3E%3Cpath%20fill%3D%22%23e0eba8%22%20fill-opacity%3D%22.5%22%20d%3D%22M109.5%2019.8h25v18.8h-25zM224.2%201h8.4v33.4h-8.4z%22%2F%3E%3Cellipse%20fill%3D%22%23e0eba8%22%20fill-opacity%3D%22.5%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22rotate(158.1%20261.2%2059.2)%20scale(11.05488%2025.54402)%22%2F%3E%3Cellipse%20fill%3D%22%23e0eba8%22%20fill-opacity%3D%22.5%22%20rx%3D%221%22%20ry%3D%221%22%20transform%3D%22matrix(-1.50296%2024.57326%20-36.3682%20-2.22437%20129.5%2021.4)%22%2F%3E%3C%2Fg%3E%3C%2Fsvg%3E)

Updated on: 21/05/2026

Was this article helpful?

Share your feedback

Cancel

Thank you!