How to import a database in PhpMyAdmin?

To import your database into phpMyadmin, you must access phpMyadmin through cpanel. 

  
When you are in phpMyAdmin, you must choose a database into which the data will be imported
(the empty database), which is located on the left, as shown in the following image:


For you to import a database that is saved locally on your computer to phpMyAdmin,
you must click on the "Import" button.

  
After that, you must indicate where the file is in the "Select file" button, 
choose all the necessary parameters, and click "Run". 

Wait for the data import process to finish, which may take a few minutes.

• Related Articles

• Import a CSV file to MYSQL via PHPMYADMIN

  I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. ...

• How to export your database in phpMyAdmin?

  To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...

• How to import/export a PostgreSQL database

  Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql 1 - In cPanel, access “phpPgAdmin”; To import: 2 - In the left panel of the screen, click ...

• How to upload a firebird database to your hosting acount

  If you already have a Firebird database and want to host in our host account, just follow these steps: 1- Save/export your local firebird database with your cpanel username and password (the first one that was sent to your email) as the owner ...

• How to access PhpMyAdmin in your hosting?

  When hosting with Scriptcase the phpMyAdmin is already installed as standard, you just need to access it through cPanel.  Through cpanel you go to "Database", then click on "phpMyAdmin", and you will be directed to the phpMyAdmin page. You will be ...